public static DbCommand GetUpdateRegisterCommand(Database database, RegisterEntity entity) { DbCommand cmd = database.GetStoredProcCommand("P_UpdateRegister"); #region 参数赋值 database.AddInParameter(cmd, "RegisterId", DbType.String, entity.RegisterId); database.AddInParameter(cmd, "RegisterNo", DbType.String, entity.RegisterNo); database.AddInParameter(cmd, "RegisterProductName", DbType.String, entity.RegisterProductName); database.AddInParameter(cmd, "StandardCode", DbType.String, entity.StandardCode); database.AddInParameter(cmd, "RegisterNo1", DbType.String, entity.RegisterNo1); database.AddInParameter(cmd, "RegisterProductName1", DbType.String, entity.RegisterProductName1); database.AddInParameter(cmd, "StandardCode1", DbType.String, entity.StandardCode1); database.AddInParameter(cmd, "RegisterFile", DbType.String, entity.RegisterFile); database.AddInParameter(cmd, "StartDate", DbType.String, entity.StartDate); database.AddInParameter(cmd, "EndDate", DbType.String, entity.EndDate); database.AddInParameter(cmd, "LastModifyId", DbType.String, entity.LastModifyId); database.AddInParameter(cmd, "Remark", DbType.String, entity.Remark); #endregion return cmd; }
public string CreateRegisterWithAttachment(RegisterEntity entity, RegisterAttachmentEntityNewLogic[] registerAttachmentEntityNewLogic) { string registerId = string.Empty; #region 使用事务 base.UseTran((tran) => { DbCommand cmd = RegisterService.GetCreateRegisterCommand(this.Database, entity); base.Database.ExecuteNonQuery(cmd, tran); registerId = (string)base.Database.GetParameterValue(cmd, "RegisterId"); base.DeleteRelationData("registerattach", registerId, tran); registerAttachmentEntityNewLogic.ToList().ForEach((item) => { item.RegisterId = registerId; DbCommand cmd1 = GetCreateAttachmentCommand(this.Database, item); base.Database.ExecuteNonQuery(cmd1, tran); var attachId = base.Database.GetParameterValue(cmd1, "Id").ToString(); }); }); #endregion return registerId; }
private static RegisterEntity DataRowToEntity(DataRow row) { if (row == null) return null; var result = new RegisterEntity() { RegisterId = (string)(row["RegisterId"]), RegisterNo = (string)(row["RegisterNo"]), RegisterProductName = (string)(row["RegisterProductName"]), StandardCode = (string)(row["StandardCode"]), RegisterNo1 = (string)(row["RegisterNo1"]), RegisterProductName1 = (string)(row["RegisterProductName1"]), StandardCode1 = (string)(row["StandardCode1"]), RegisterFile = (string)(row["RegisterFile"]), StartDate = (string)(row["StartDate"]), EndDate = (string)(row["EndDate"]), CreateId = (string)(row["CreateId"]), CreateDate = (DateTime)(row["CreateDate"]), LastModifyId = (string)(row["LastModifyId"]), LastModifyDate = (DateTime)(row["LastModifyDate"]), Remark = (string)(row["Remark"]), }; return result; }
private static RegisterEntity[] DataTableToEntitys(DataTable dt) { if (dt == null) return null; var results = new RegisterEntity[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { results[i] = DataRowToEntity(dt.Rows[i]); } return results; }
public void UpdateRegisterWithAttachment(RegisterEntity entity, RegisterAttachmentEntityNewLogic[] registerAttachmentEntityNewLogic) { base.UseTran((tran) => { var cmd = GetUpdateRegisterCommand(this.Database, entity); base.Database.ExecuteNonQuery(cmd, tran); base.DeleteRelationData("registerattach", entity.RegisterId, tran); registerAttachmentEntityNewLogic.ToList().ForEach((item) => { #region CreateAttachment DbCommand cmd1 = RegisterService.GetCreateAttachmentCommand(this.Database, item); base.Database.ExecuteNonQuery(cmd1, tran); var attachId = base.Database.GetParameterValue(cmd1, "Id").ToString(); #endregion }); }); }