public int Update(YF_AssetMainRecordModel ObjModel) { int num = 0; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); try { try { num = new YF_AssetMainRecordBLL().Update(ObjModel, transaction); transaction.Commit(); } catch (SqlException exception) { transaction.Rollback(); throw exception; } return(num); } finally { connection.Close(); } } return(num); }
private YF_AssetMainRecordModel _DataBind(int Code) { YF_AssetMainRecordModel model = new YF_AssetMainRecordModel(); StringBuilder builder = new StringBuilder(); builder.Append("select * from YF_AssetMainRecord "); builder.Append(" where Code=@Code"); this._DataProcess.CommandText = builder.ToString(); this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, Code); SqlDataReader sqlDataReader = null; try { try { sqlDataReader = this._DataProcess.GetSqlDataReader(); while (sqlDataReader.Read()) { this.Initialize(sqlDataReader, model); } } catch (SqlException exception) { throw exception; } } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } return(model); }
private int _Update(YF_AssetMainRecordModel mObj) { StringBuilder builder = new StringBuilder(); builder.Append("update YF_AssetMainRecord set "); if (mObj.FKCode != 0) { builder.Append("FKCode=@FKCode,"); this._DataProcess.ProcessParametersAdd("@FKCode", SqlDbType.Int, 4, mObj.FKCode); } if (mObj.Content != null) { builder.Append("Content=@Content,"); this._DataProcess.ProcessParametersAdd("@Content", SqlDbType.VarChar, 0x7d0, mObj.Content); } if (mObj.CostTime != 0) { builder.Append("CostTime=@CostTime,"); this._DataProcess.ProcessParametersAdd("@CostTime", SqlDbType.Int, 4, mObj.CostTime); } if (mObj.CostMoney != 0M) { builder.Append("CostMoney=@CostMoney,"); this._DataProcess.ProcessParametersAdd("@CostMoney", SqlDbType.Decimal, 9, mObj.CostMoney); } if (mObj.ChangeDetail != null) { builder.Append("ChangeDetail=@ChangeDetail,"); this._DataProcess.ProcessParametersAdd("@ChangeDetail", SqlDbType.VarChar, 0x7d0, mObj.ChangeDetail); } if (mObj.UserSign != null) { builder.Append("UserSign=@UserSign,"); this._DataProcess.ProcessParametersAdd("@UserSign", SqlDbType.VarChar, 50, mObj.UserSign); } if (mObj.MainUser != null) { builder.Append("MainUser=@MainUser,"); this._DataProcess.ProcessParametersAdd("@MainUser", SqlDbType.VarChar, 50, mObj.MainUser); } if (mObj.MainTime != DateTime.MinValue) { builder.Append("MainTime=@MainTime,"); this._DataProcess.ProcessParametersAdd("@MainTime", SqlDbType.DateTime, 8, mObj.MainTime); } if (mObj.Result != null) { builder.Append("Result=@Result,"); this._DataProcess.ProcessParametersAdd("@Result", SqlDbType.VarChar, 50, mObj.Result); } builder.Remove(builder.Length - 1, 1); builder.Append(" where Code=@Code"); this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, mObj.Code); this._DataProcess.CommandText = builder.ToString(); return(this._DataProcess.RunSql()); }
protected void ObjectDataSource1_Inserted(object sender, ObjectDataSourceStatusEventArgs e) { this.ObjectDataSource1.SelectParameters["Code"].DefaultValue = e.ReturnValue.ToString(); ViewState["Code"] = e.ReturnValue.ToString(); YF_AssetMainRecordBFL amrBFL = new YF_AssetMainRecordBFL(); YF_AssetMainRecordModel amrModel = new YF_AssetMainRecordModel(); amrModel.Code = Int32.Parse(e.ReturnValue.ToString()); amrBFL.Insert(amrModel); this.RefreshParentPage(); }
private List <YF_AssetMainRecordModel> _Select(YF_AssetMainRecordQueryModel qmObj) { List <YF_AssetMainRecordModel> list = new List <YF_AssetMainRecordModel>(); StringBuilder builder = new StringBuilder(); builder.Append("select * from YF_AssetMainRecord "); builder.Append(qmObj.QueryConditionStr); if (qmObj.SortColumns.Length == 0) { builder.Append(" ORDER BY Code 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))) { YF_AssetMainRecordModel model = new YF_AssetMainRecordModel(); this.Initialize(sqlDataReader, model); list.Add(model); } num++; } } catch (SqlException exception) { throw exception; } } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } return(list); }
public YF_AssetMainRecordModel GetYF_AssetMainRecord(int Code) { YF_AssetMainRecordModel model = new YF_AssetMainRecordModel(); using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); model = new YF_AssetMainRecordBLL().GetModel(Code, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(model); }
private void Initialize(SqlDataReader reader, YF_AssetMainRecordModel obj) { if (reader.GetValue(0) != DBNull.Value) { obj.Code = reader.GetInt32(0); } if (reader.GetValue(1) != DBNull.Value) { obj.FKCode = reader.GetInt32(1); } if (reader.GetValue(2) != DBNull.Value) { obj.Content = reader.GetString(2); } if (reader.GetValue(3) != DBNull.Value) { obj.CostTime = reader.GetInt32(3); } if (reader.GetValue(4) != DBNull.Value) { obj.CostMoney = reader.GetDecimal(4); } if (reader.GetValue(5) != DBNull.Value) { obj.ChangeDetail = reader.GetString(5); } if (reader.GetValue(6) != DBNull.Value) { obj.UserSign = reader.GetString(6); } if (reader.GetValue(7) != DBNull.Value) { obj.MainUser = reader.GetString(7); } if (reader.GetValue(8) != DBNull.Value) { obj.MainTime = reader.GetDateTime(8); } if (reader.GetValue(9) != DBNull.Value) { obj.Result = reader.GetString(9); } }
public int Update(YF_AssetMainRecordModel ObjModel, SqlTransaction Transaction) { YF_AssetMainRecordDAL ddal = new YF_AssetMainRecordDAL(Transaction); return(ddal.Update(ObjModel)); }
public int Insert(YF_AssetMainRecordModel ObjModel, SqlTransaction Transaction) { YF_AssetMainRecordDAL ddal = new YF_AssetMainRecordDAL(Transaction); return(ddal.Insert(ObjModel)); }
public int Update(YF_AssetMainRecordModel mObj) { return(this._Update(mObj)); }
public int Insert(YF_AssetMainRecordModel mObj) { return(this._Insert(mObj)); }
public int Delete(YF_AssetMainRecordModel mObj) { return(this._Delete(mObj.Code)); }