コード例 #1
0
 public int CreateCompany(CompanyEntity entity)
 {
     int entityid = 0;
     base.UseTran((tran) =>
     {
         var cmd = GetCreateCompanyCommand(this.Database, entity);
         base.Database.ExecuteNonQuery(cmd, tran);
         entityid = (int)base.Database.GetParameterValue(cmd, "CompanyId");
     });
     return entityid;
 }
コード例 #2
0
 public static DbCommand GetUpdateProductCommand(Database database, CompanyEntity entity)
 {
     DbCommand cmd = database.GetStoredProcCommand("P_UpdateCompany");
     #region 参数赋值
     database.AddInParameter(cmd, "CompanyId", DbType.Int32, entity.CompanyId);
     database.AddInParameter(cmd, "CompanyNo", DbType.String, entity.CompanyNo);
     database.AddInParameter(cmd, "CompanyName", DbType.String, entity.CompanyName);
     database.AddInParameter(cmd, "Address", DbType.String, entity.Address);
     database.AddInParameter(cmd, "Tel", DbType.String, entity.Tel);
     database.AddInParameter(cmd, "Fax", DbType.String, entity.Fax);
     database.AddInParameter(cmd, "PostCode", DbType.String, entity.PostCode);
     database.AddInParameter(cmd, "EMail", DbType.String, entity.EMail);
     database.AddInParameter(cmd, "Person", DbType.String, entity.Person);
     database.AddInParameter(cmd, "BankAndAcount", DbType.String, entity.BankAndAcount);
     database.AddInParameter(cmd, "TaxNumber", DbType.String, entity.TaxNumber);
     database.AddInParameter(cmd, "ARTotal", DbType.Decimal, entity.ARTotal);
     database.AddInParameter(cmd, "APTotal", DbType.Decimal, entity.APTotal);
     database.AddInParameter(cmd, "Remark", DbType.String, entity.Remark);
     database.AddInParameter(cmd, "Password", DbType.String, entity.Password);
     database.AddInParameter(cmd, "Enable", DbType.Boolean, entity.Enable);
     database.AddInParameter(cmd, "LastModifyId", DbType.String, entity.LastModifyId);
     #endregion
     return cmd;
 }
コード例 #3
0
 private static CompanyEntity DataRowToEntity(DataRow row)
 {
     if (row == null)
         return null;
     var result = new CompanyEntity()
     {
         CompanyId = (int)(row["CompanyId"]),
         CompanyNo = (string)(row["CompanyNo"]),
         CompanyName = (string)(row["CompanyName"]),
         Address = (string)(row["Address"]),
         Tel = (string)(row["Tel"]),
         Fax = (string)(row["Fax"]),
         PostCode = (string)(row["PostCode"]),
         EMail = (string)(row["EMail"]),
         Person = (string)(row["Person"]),
         BankAndAcount = (string)(row["BankAndAcount"]),
         TaxNumber = (string)(row["TaxNumber"]),
         ARTotal = (decimal)(row["ARTotal"]),
         APTotal = (decimal)(row["APTotal"]),
         Remark = (string)(row["Remark"]),
         CreateId = (string)(row["CreateId"]),
         CreateDate = (DateTime)(row["CreateDate"]),
         LastModifyId = (string)(row["LastModifyId"]),
         LastModifyDate = (DateTime)(row["LastModifyDate"]),
         Password = (string)(row["Password"]),
         Enable = (bool)(row["Enable"]),
         PId = (int)(row["PId"]),
         Level_Path = (string)(row["Level_Path"]),
         Level_Num = (int)(row["Level_Num"]),
         Level_Total = (int)(row["Level_Total"]),
         Level_Deep = (int)(row["Level_Deep"]),
     };
     return result;
 }
コード例 #4
0
 private static CompanyEntity[] DataTableToEntitys(DataTable dt)
 {
     if (dt == null)
         return null;
     var results = new CompanyEntity[dt.Rows.Count];
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         results[i] = CompanyService.DataRowToEntity(dt.Rows[i]);
     }
     return results;
 }
コード例 #5
0
 public void UpdateCompany(CompanyEntity entity)
 {
     base.UseTran((tran) =>
     {
         var cmd = GetUpdateProductCommand(this.Database, entity);
         base.Database.ExecuteNonQuery(cmd, tran);
     });
 }