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[];

public Schdule[] FindSchduleByDate(DateTime day)
{
PersistenceManager pm =
PersistenceManagerFactory.Instance().CreatePersistenceManager();
string filter = "StartTime>@today AND StartTime<@tomrrow AND UserID=@UserID";
QueryParameterCollection parameters =new QueryParameterCollection(2);
parameters.Add("@today",day,DbType.DateTime);
parameters.Add("@tomrrow",day.AddHours(24),DbType.DateTime);
parameters.Add("@UserID",new SecurityService().CurrentUser().UserID,DbType.String);
Query q = pm.NewQuery(typeof(Schdule),filter,parameters);
q.Ordering ="StartTime";
try
{
return q.QueryObjects()as Schdule[];
}
finally
{
pm.Close();
}
}

根据SQL 查询。。。。

DataTable dt = pm.NewCustomerQuery("select * from se_DeliveryRequisition ").QueryData().CurrentTable;

//事务保存数据

public void SavaSMS(int hr, string result)
        {
            PersistenceManager pm = PersistenceManagerFactory.Instance().CreatePersistenceManager();
            Transaction t = pm.CurrentTransaction;
            t.Begin();
            DataEntity.EntityClass.se_SMS en = SHIFT.Websharp.ORM.Base.EntityManager.CreateObject(typeof(DataEntity.EntityClass.se_SMS)) as DataEntity.EntityClass.se_SMS;
            try
            {
                en.InnerID = Guid.NewGuid().ToString();
                en.ClientInnerID = this.ctrClient1.Text.Trim();
                en.ContactMan = cbxContact.SelectedValue.ToString();
                en.Phone = this.txtPhoneNum.Text.Trim();
                en.SendMsg = this.txtMessage.Text.Trim();
                en.SendCode = hr;
                en.SendCodeString = result;
                en.SendDate = CommonClass.StringExChange.str2realtype<DateTime>(BLL.GetServerDataTime(), DateTime.Now);
                pm.PersistNewObject(en);
                t.Commit();
                this.lblResult.Text = result;


            }
            catch (Exception ex)
            {
                BLL.MesShowOK("发送失败!\n" + ex.Message);
                PublicDAL.writelog("发送短信异常[异常信息:" + ex.Message + "]");
                t.Rollback();
            }
            finally
            {
                pm.Close();
            }
        }