public int waitBalance(int ViseCode, SqlTransaction Transaction) { LocaleViseModel viseModel = this.GetModel(ViseCode, Transaction); viseModel.ViseBalanceStatus = 3; return(this.Update(viseModel, Transaction)); }
public int StartAudit(int ViseCode, SqlTransaction Transaction) { LocaleViseModel viseModel = this.GetModel(ViseCode, Transaction); viseModel.ViseStatus = 2; return(this.Update(viseModel, Transaction)); }
public int UpdateComeToMoney(int ViseCode, decimal ComeToMoney) { int num = 0; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); try { try { LocaleViseBLL ebll = new LocaleViseBLL(); LocaleViseModel viseModel = ebll.GetModel(ViseCode, transaction); viseModel.ViseComeToMoney = ComeToMoney; num = ebll.Update(viseModel, transaction); transaction.Commit(); } catch (SqlException exception) { transaction.Rollback(); connection.Close(); throw exception; } return(num); } finally { connection.Close(); } } return(num); }
public int Update(LocaleViseModel ViseModel) { int num = 0; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); try { try { num = new LocaleViseBLL().Update(ViseModel, transaction); transaction.Commit(); } catch (SqlException exception) { transaction.Rollback(); connection.Close(); throw exception; } return(num); } finally { connection.Close(); } } return(num); }
public int Balance(int ViseCode, SqlTransaction Transaction) { LocaleViseModel viseModel = new LocaleViseModel(); viseModel.ViseCode = ViseCode; viseModel.ViseBalanceStatus = 2; return(this.Update(viseModel, Transaction)); }
public int Insert(LocaleViseModel ViseModel, SqlTransaction Transaction) { LocaleViseDAL edal = new LocaleViseDAL(Transaction); ViseModel.ViseBalanceStatus = 1; ViseModel.ViseStatus = 1; ViseModel.ViseComeToMoney = 0M; return(edal.Insert(ViseModel)); }
public int Update(LocaleViseModel mObj) { int num; try { num = this._Update(mObj); } catch (Exception exception) { throw exception; } return(num); }
public int Delete(LocaleViseModel mObj) { int num; try { num = this._Delete(mObj.ViseCode); } catch (Exception exception) { throw exception; } return(num); }
private LocaleViseModel _DataBind(int Code) { Exception exception; LocaleViseModel model2; try { LocaleViseModel model = new LocaleViseModel(); StringBuilder builder = new StringBuilder(); builder.Append("select * from LocaleVise"); builder.Append(" where ViseCode=@ViseCode"); this._DataProcess.CommandText = builder.ToString(); this._DataProcess.ProcessParametersAdd("@ViseCode", SqlDbType.Int, 4, Code); SqlDataReader sqlDataReader = null; try { try { sqlDataReader = this._DataProcess.GetSqlDataReader(); while (sqlDataReader.Read()) { this.Initialize(sqlDataReader, model); } } catch (Exception exception1) { exception = exception1; throw exception; } } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } model2 = model; } catch (Exception exception2) { exception = exception2; throw exception; } return(model2); }
private int _Insert(LocaleViseModel mObj) { int viseCode; try { StringBuilder builder = new StringBuilder(); builder.Append("insert into LocaleVise("); builder.Append("ViseId,ViseName,ViseDate,ViseType,VisePerson,ViseSupplier,ViseUnit,ViseEndDate,ViseRemark,ViseScrutiny,ViseReason,ViseStatus,ViseBalanceStatus,ViseProject,ViseContractCode,ViseReasonItem,ViseComeToMoney,ViseID2,ViseReferCode)"); builder.Append(" values ("); builder.Append("@ViseId,@ViseName,@ViseDate,@ViseType,@VisePerson,@ViseSupplier,@ViseUnit,@ViseEndDate,@ViseRemark,@ViseScrutiny,@ViseReason,@ViseStatus,@ViseBalanceStatus,@ViseProject,@ViseContractCode,@ViseReasonItem,@ViseComeToMoney,@ViseID2,@ViseReferCode) "); this._DataProcess.CommandText = builder.ToString(); this._DataProcess.ProcessParametersAdd("@ViseId", SqlDbType.VarChar, 50, mObj.ViseId); this._DataProcess.ProcessParametersAdd("@ViseName", SqlDbType.VarChar, 50, mObj.ViseName); this._DataProcess.ProcessParametersAdd("@ViseDate", SqlDbType.DateTime, 8, mObj.ViseDate); this._DataProcess.ProcessParametersAdd("@ViseType", SqlDbType.VarChar, 50, mObj.ViseType); this._DataProcess.ProcessParametersAdd("@VisePerson", SqlDbType.VarChar, 50, mObj.VisePerson); this._DataProcess.ProcessParametersAdd("@ViseSupplier", SqlDbType.VarChar, 50, mObj.ViseSupplier); this._DataProcess.ProcessParametersAdd("@ViseUnit", SqlDbType.VarChar, 50, mObj.ViseUnit); this._DataProcess.ProcessParametersAdd("@ViseEndDate", SqlDbType.DateTime, 8, mObj.ViseEndDate); this._DataProcess.ProcessParametersAdd("@ViseRemark", SqlDbType.VarChar, 0x7d0, mObj.ViseRemark); this._DataProcess.ProcessParametersAdd("@ViseScrutiny", SqlDbType.VarChar, 0x7d0, mObj.ViseScrutiny); this._DataProcess.ProcessParametersAdd("@ViseReason", SqlDbType.VarChar, 0x7d0, mObj.ViseReason); this._DataProcess.ProcessParametersAdd("@ViseStatus", SqlDbType.Int, 4, mObj.ViseStatus); this._DataProcess.ProcessParametersAdd("@ViseBalanceStatus", SqlDbType.Int, 4, mObj.ViseBalanceStatus); this._DataProcess.ProcessParametersAdd("@ViseProject", SqlDbType.VarChar, 50, mObj.ViseProject); this._DataProcess.ProcessParametersAdd("@ViseContractCode", SqlDbType.VarChar, 50, mObj.ViseContractCode); this._DataProcess.ProcessParametersAdd("@ViseReasonItem", SqlDbType.VarChar, 0x1f40, mObj.ViseReasonItem); this._DataProcess.ProcessParametersAdd("@ViseComeToMoney", SqlDbType.Decimal, 9, mObj.ViseComeToMoney); this._DataProcess.ProcessParametersAdd("@ViseID2", SqlDbType.VarChar, 50, mObj.ViseID2); this._DataProcess.ProcessParametersAdd("@ViseReferCode", SqlDbType.Int, 4, (mObj.ViseReferCode == 0) ? 0 : mObj.ViseReferCode); this._DataProcess.RunSql(); viseCode = mObj.ViseCode; } catch (Exception exception) { throw exception; } return(viseCode); }
public int Delete(LocaleViseModel ViseModel, SqlTransaction Transaction) { return(this.Delete(ViseModel.ViseCode, Transaction)); }
public int Update(LocaleViseModel ViseModel, SqlTransaction Transaction) { LocaleViseDAL edal = new LocaleViseDAL(Transaction); return(edal.Update(ViseModel)); }
private void Initialize(SqlDataReader reader, LocaleViseModel obj) { try { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseCode")) != DBNull.Value) { obj.ViseCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseId")) != DBNull.Value) { obj.ViseId = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseId")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseName")) != DBNull.Value) { obj.ViseName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseName")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseDate")) != DBNull.Value) { obj.ViseDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseType")) != DBNull.Value) { obj.ViseType = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseType")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "VisePerson")) != DBNull.Value) { obj.VisePerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "VisePerson")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseSupplier")) != DBNull.Value) { obj.ViseSupplier = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseSupplier")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseUnit")) != DBNull.Value) { obj.ViseUnit = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseUnit")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseEndDate")) != DBNull.Value) { obj.ViseEndDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseEndDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseRemark")) != DBNull.Value) { obj.ViseRemark = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseRemark")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseScrutiny")) != DBNull.Value) { obj.ViseScrutiny = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseScrutiny")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReason")) != DBNull.Value) { obj.ViseReason = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReason")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseStatus")) != DBNull.Value) { obj.ViseStatus = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseStatus")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseBalanceStatus")) != DBNull.Value) { obj.ViseBalanceStatus = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseBalanceStatus")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseProject")) != DBNull.Value) { obj.ViseProject = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseProject")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseContractCode")) != DBNull.Value) { obj.ViseContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseContractCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReasonItem")) != DBNull.Value) { obj.ViseReasonItem = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReasonItem")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseComeToMoney")) != DBNull.Value) { obj.ViseComeToMoney = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseComeToMoney")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseID2")) != DBNull.Value) { obj.ViseID2 = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseID2")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReferCode")) != DBNull.Value) { obj.ViseReferCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReferCode")); } } catch (Exception exception) { throw exception; } }
private int _Update(LocaleViseModel mObj) { int num; try { StringBuilder builder = new StringBuilder(); builder.Append("update LocaleVise set "); if (mObj.ViseId != null) { builder.Append("ViseId=@ViseId,"); this._DataProcess.ProcessParametersAdd("@ViseId", SqlDbType.VarChar, 50, mObj.ViseId); } if (mObj.ViseName != null) { builder.Append("ViseName=@ViseName,"); this._DataProcess.ProcessParametersAdd("@ViseName", SqlDbType.VarChar, 50, mObj.ViseName); } if (mObj.ViseDate != DateTime.MinValue) { builder.Append("ViseDate=@ViseDate,"); this._DataProcess.ProcessParametersAdd("@ViseDate", SqlDbType.DateTime, 8, mObj.ViseDate); } if (mObj.ViseType != null) { builder.Append("ViseType=@ViseType,"); this._DataProcess.ProcessParametersAdd("@ViseType", SqlDbType.VarChar, 50, mObj.ViseType); } if (mObj.VisePerson != null) { builder.Append("VisePerson=@VisePerson,"); this._DataProcess.ProcessParametersAdd("@VisePerson", SqlDbType.VarChar, 50, mObj.VisePerson); } if (mObj.ViseSupplier != null) { builder.Append("ViseSupplier=@ViseSupplier,"); this._DataProcess.ProcessParametersAdd("@ViseSupplier", SqlDbType.VarChar, 50, mObj.ViseSupplier); } if (mObj.ViseUnit != null) { builder.Append("ViseUnit=@ViseUnit,"); this._DataProcess.ProcessParametersAdd("@ViseUnit", SqlDbType.VarChar, 50, mObj.ViseUnit); } if (mObj.ViseEndDate != DateTime.MinValue) { builder.Append("ViseEndDate=@ViseEndDate,"); this._DataProcess.ProcessParametersAdd("@ViseEndDate", SqlDbType.DateTime, 8, mObj.ViseEndDate); } if (mObj.ViseRemark != null) { builder.Append("ViseRemark=@ViseRemark,"); this._DataProcess.ProcessParametersAdd("@ViseRemark", SqlDbType.VarChar, 0x7d0, mObj.ViseRemark); } if (mObj.ViseScrutiny != null) { builder.Append("ViseScrutiny=@ViseScrutiny,"); this._DataProcess.ProcessParametersAdd("@ViseScrutiny", SqlDbType.VarChar, 0x7d0, mObj.ViseScrutiny); } if (mObj.ViseReason != null) { builder.Append("ViseReason=@ViseReason,"); this._DataProcess.ProcessParametersAdd("@ViseReason", SqlDbType.VarChar, 0x7d0, mObj.ViseReason); } if (mObj.ViseStatus != 0) { builder.Append("ViseStatus=@ViseStatus,"); this._DataProcess.ProcessParametersAdd("@ViseStatus", SqlDbType.Int, 4, mObj.ViseStatus); } if (mObj.ViseBalanceStatus != 0) { builder.Append("ViseBalanceStatus=@ViseBalanceStatus,"); this._DataProcess.ProcessParametersAdd("@ViseBalanceStatus", SqlDbType.Int, 4, mObj.ViseBalanceStatus); } if (mObj.ViseProject != null) { builder.Append("ViseProject=@ViseProject,"); this._DataProcess.ProcessParametersAdd("@ViseProject", SqlDbType.VarChar, 50, mObj.ViseProject); } if (mObj.ViseContractCode != null) { builder.Append("ViseContractCode=@ViseContractCode,"); this._DataProcess.ProcessParametersAdd("@ViseContractCode", SqlDbType.VarChar, 50, mObj.ViseContractCode); } if (mObj.ViseReasonItem != null) { builder.Append("ViseReasonItem=@ViseReasonItem,"); this._DataProcess.ProcessParametersAdd("@ViseReasonItem", SqlDbType.VarChar, 0x1f40, mObj.ViseReasonItem); } if (mObj.ViseComeToMoney != 0M) { builder.Append("ViseComeToMoney=@ViseComeToMoney,"); this._DataProcess.ProcessParametersAdd("@ViseComeToMoney", SqlDbType.Decimal, 9, mObj.ViseComeToMoney); } if (mObj.ViseID2 != null) { builder.Append("ViseID2=@ViseID2,"); this._DataProcess.ProcessParametersAdd("@ViseID2", SqlDbType.VarChar, 50, mObj.ViseID2); } if (mObj.ViseReferCode != 0) { builder.Append("ViseReferCode=@ViseReferCode,"); this._DataProcess.ProcessParametersAdd("@ViseReferCode", SqlDbType.Int, 4, mObj.ViseReferCode); } builder.Remove(builder.Length - 1, 1); builder.Append(" where ViseCode=@ViseCode"); this._DataProcess.ProcessParametersAdd("@ViseCode", SqlDbType.Int, 4, mObj.ViseCode); this._DataProcess.CommandText = builder.ToString(); num = this._DataProcess.RunSql(); } catch (Exception exception) { throw exception; } return(num); }
private List <LocaleViseModel> _Select(LocaleViseQueryModel qmObj) { Exception exception; List <LocaleViseModel> list2; try { List <LocaleViseModel> list = new List <LocaleViseModel>(); StringBuilder builder = new StringBuilder(); builder.Append("select * from LocaleVise "); builder.Append(qmObj.QueryConditionStr); if ((qmObj.SortColumns == null) || (qmObj.SortColumns.Length == 0)) { builder.Append(" ORDER BY ViseCode desc"); } else { builder.Append(" ORDER BY " + qmObj.SortColumns); } this._DataProcess.CommandText = builder.ToString(); this._DataProcess.SqlParameters = qmObj.Parameters; SqlDataReader sqlDataReader = null; int num = 0; try { try { sqlDataReader = this._DataProcess.GetSqlDataReader(); while (sqlDataReader.Read()) { if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1))) { LocaleViseModel model = new LocaleViseModel(); this.Initialize(sqlDataReader, model); list.Add(model); } num++; } } catch (Exception exception1) { exception = exception1; throw exception; } } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } list2 = list; } catch (Exception exception2) { exception = exception2; throw exception; } return(list2); }