Websharp 个人记要

Websharp 个人记录

1.根据主键获得实体

PersistenceManager pm = PersistenceManagerFactory.Instance().CreatePersistenceManager();
se_OrderMain order = pm.FindObjectByPrimaryKey(this.Tag.ToString(), typeof(se_OrderMain)) as se_OrderMain;

2.事务处理

 PersistenceManager pm = PersistenceManagerFactory.Instance().CreatePersistenceManager();
            Transaction trans = pm.CurrentTransaction;
            trans.Begin();

try
            {

                    putin.InnerID = Guid.NewGuid().ToString();
                    putin.PackID = "";

                    pm.PersistNewObject(putin);
                    updateSQL = "update ba_Product set Inventory=" + putin.TotalQuantityFact + " where InnerID='" + putin.ProdectID + "'";
                    pm.updatebySql(updateSQL);
                trans.Commit();
                SHIFT.MesShowOK("成功盘点");
                
            }
            catch (Exception ex)
            {
                PublicDAL.writelog("盘点数据异常[异常信息:" + ex.Message + "]");
                trans.Rollback();
            }
            finally
            {
                pm.Close();
            }

3. 查询

 QueryParameterCollection parameters = new QueryParameterCollection();
            string code=this.txtFreightMode.Text.Trim();
            parameters.Add("@ParentCode", code);
            Query q = pm.NewQuery(typeof(ba_FreightMode), "ParentCode=@ParentCode", parameters);
            ba_FreightMode[] c3 = q.QueryObjects() as ba_FreightMode[];