public bool Update(MonthDetailModel model, SqlTransaction trans) { StringBuilder builder = new StringBuilder(); builder.Append("update Fund_Plan_MonthDetail set "); builder.Append("MonthPlanID=@MonthPlanID,"); builder.Append("ContractID=@ContractID,"); builder.Append("Plansubject=@Plansubject,"); builder.Append("PlanMoney=@PlanMoney,"); builder.Append("OldBalance=@OldBalance,"); builder.Append("OrderID=@OrderID,"); builder.Append("ReMark=@ReMark"); builder.Append(" where UID=@UID "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@MonthPlanID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@Plansubject", SqlDbType.VarChar, 20), new SqlParameter("@PlanMoney", SqlDbType.Money, 8), new SqlParameter("@OldBalance", SqlDbType.Money, 8), new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@ReMark", SqlDbType.NVarChar, 50), new SqlParameter("@UID", SqlDbType.UniqueIdentifier, 0x10) }; commandParameters[0].Value = model.MonthPlanID; commandParameters[1].Value = model.ContractID; commandParameters[2].Value = model.Plansubject; commandParameters[3].Value = model.PlanMoney; commandParameters[4].Value = model.OldBalance; commandParameters[5].Value = model.OrderID; commandParameters[6].Value = model.ReMark; commandParameters[7].Value = model.UID; int num = 0; if (trans == null) { num = SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters); } else { num = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters); } return(num > 0); }
public MonthDetailModel GetModel(Guid UID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 UID,MonthPlanID,ContractID,Plansubject,PlanMoney,OldBalance,OrderID,ReMark,ThisBalance from Fund_Plan_MonthDetail "); builder.Append(" where UID=@UID "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@UID", SqlDbType.UniqueIdentifier) }; commandParameters[0].Value = UID; MonthDetailModel model = new MonthDetailModel(); DataTable table = SqlHelper.ExecuteQuery(CommandType.Text, builder.ToString(), commandParameters); if (table.Rows.Count <= 0) { return(null); } if ((table.Rows[0]["UID"] != null) && (table.Rows[0]["UID"].ToString() != "")) { model.UID = new Guid(table.Rows[0]["UID"].ToString()); } if ((table.Rows[0]["MonthPlanID"] != null) && (table.Rows[0]["MonthPlanID"].ToString() != "")) { model.MonthPlanID = new Guid(table.Rows[0]["MonthPlanID"].ToString()); } if ((table.Rows[0]["ContractID"] != null) && (table.Rows[0]["ContractID"].ToString() != "")) { model.ContractID = table.Rows[0]["ContractID"].ToString(); } if ((table.Rows[0]["Plansubject"] != null) && (table.Rows[0]["Plansubject"].ToString() != "")) { model.Plansubject = table.Rows[0]["Plansubject"].ToString(); } if ((table.Rows[0]["PlanMoney"] != null) && (table.Rows[0]["PlanMoney"].ToString() != "")) { model.PlanMoney = new decimal?(decimal.Parse(table.Rows[0]["PlanMoney"].ToString())); } if ((table.Rows[0]["OldBalance"] != null) && (table.Rows[0]["OldBalance"].ToString() != "")) { model.OldBalance = new decimal?(decimal.Parse(table.Rows[0]["OldBalance"].ToString())); } if ((table.Rows[0]["OrderID"] != null) && (table.Rows[0]["OrderID"].ToString() != "")) { model.OrderID = new int?(int.Parse(table.Rows[0]["OrderID"].ToString())); } if ((table.Rows[0]["ReMark"] != null) && (table.Rows[0]["ReMark"].ToString() != "")) { model.ReMark = table.Rows[0]["ReMark"].ToString(); } if ((table.Rows[0]["ThisBalance"] != null) && (table.Rows[0]["ThisBalance"].ToString() != "")) { model.ThisBalance = new decimal?(decimal.Parse(table.Rows[0]["ThisBalance"].ToString())); } return(model); }
public bool Add(MonthDetailModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Fund_Plan_MonthDetail("); builder.Append("UID,MonthPlanID,ContractID,Plansubject,PlanMoney,OldBalance,OrderID,ReMark)"); builder.Append(" values ("); builder.Append("@UID,@MonthPlanID,@ContractID,@Plansubject,@PlanMoney,@OldBalance,@OrderID,@ReMark)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@UID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@MonthPlanID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@Plansubject", SqlDbType.VarChar, 20), new SqlParameter("@PlanMoney", SqlDbType.Money, 8), new SqlParameter("@OldBalance", SqlDbType.Money, 8), new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@ReMark", SqlDbType.NVarChar, 50), new SqlParameter("@ThisBalance", SqlDbType.Money, 8) }; commandParameters[0].Value = model.UID; commandParameters[1].Value = model.MonthPlanID; commandParameters[2].Value = model.ContractID; commandParameters[3].Value = model.Plansubject; commandParameters[4].Value = model.PlanMoney; commandParameters[5].Value = model.OldBalance; commandParameters[6].Value = model.OrderID; commandParameters[7].Value = model.ReMark; commandParameters[8].Value = model.ThisBalance; return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters) > 0); }