public bool Update(RequestPayDetailModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update Fund_RequestPay_Detail set "); builder.Append("RPayMainID=@RPayMainID,"); builder.Append("PlanUID=@PlanUID,"); builder.Append("ContractID=@ContractID,"); builder.Append("RPaysubject=@RPaysubject,"); builder.Append("RPayMoney=@RPayMoney,"); builder.Append("ReMark=@ReMark,"); builder.Append("RPayUser=@RPayUser,"); builder.Append("RPayCause=@RPayCause,"); builder.Append("isInterest=@isInterest"); builder.Append(" where RPayUID=@RPayUID "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@RPayMainID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@RPayUID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@PlanUID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@RPaysubject", SqlDbType.VarChar, 30), new SqlParameter("@RPayMoney", SqlDbType.Money, 8), new SqlParameter("@ReMark", SqlDbType.VarChar, 100), new SqlParameter("@RPayUser", SqlDbType.VarChar, 50), new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@RPayCause", SqlDbType.Text), new SqlParameter("@isInterest", SqlDbType.Bit, 1) }; commandParameters[0].Value = model.RPayMainID; commandParameters[1].Value = model.RPayUID; commandParameters[2].Value = model.PlanUID; commandParameters[3].Value = model.ContractID; commandParameters[4].Value = model.RPaysubject; commandParameters[5].Value = model.RPayMoney; commandParameters[6].Value = model.ReMark; commandParameters[7].Value = model.RPayUser; commandParameters[8].Value = model.OrderID; commandParameters[9].Value = model.RPayCause; commandParameters[10].Value = model.isInterest; return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters) > 0); }
public List <RequestPayDetailModel> DataTableToList(DataTable dt) { List <RequestPayDetailModel> list = new List <RequestPayDetailModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RequestPayDetailModel item = new RequestPayDetailModel(); if (dt.Rows[i]["RPayMainID"].ToString() != "") { item.RPayMainID = new Guid(dt.Rows[i]["RPayMainID"].ToString()); } if (dt.Rows[i]["RPayUID"].ToString() != "") { item.RPayUID = new Guid(dt.Rows[i]["RPayUID"].ToString()); } if (dt.Rows[i]["PlanUID"].ToString() != "") { item.PlanUID = new Guid(dt.Rows[i]["PlanUID"].ToString()); } item.ContractID = dt.Rows[i]["ContractID"].ToString(); item.RPaysubject = dt.Rows[i]["RPaysubject"].ToString(); if (dt.Rows[i]["RPayMoney"].ToString() != "") { item.RPayMoney = new decimal?(decimal.Parse(dt.Rows[i]["RPayMoney"].ToString())); } item.ReMark = dt.Rows[i]["ReMark"].ToString(); item.RPayUser = dt.Rows[i]["RPayUser"].ToString(); if (dt.Rows[i]["OrderID"].ToString() != "") { item.OrderID = int.Parse(dt.Rows[i]["OrderID"].ToString()); } item.RPayCause = dt.Rows[i]["RPayCause"].ToString(); if (dt.Rows[i]["isInterest"].ToString() != "") { if ((dt.Rows[i]["isInterest"].ToString() == "1") || (dt.Rows[i]["isInterest"].ToString().ToLower() == "true")) { item.isInterest = true; } else { item.isInterest = false; } } list.Add(item); } } return(list); }
public RequestPayDetailModel GetModel(Guid RPayUID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 * from Fund_RequestPay_Detail "); builder.Append(" where RPayUID=@RPayUID"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@RPayUID", SqlDbType.UniqueIdentifier) }; commandParameters[0].Value = RPayUID; RequestPayDetailModel model = new RequestPayDetailModel(); DataTable table = SqlHelper.ExecuteQuery(CommandType.Text, builder.ToString(), commandParameters); if (table.Rows.Count <= 0) { return(null); } if (table.Rows[0]["RPayMainID"].ToString() != "") { model.RPayMainID = new Guid(table.Rows[0]["RPayMainID"].ToString()); } if (table.Rows[0]["RPayUID"].ToString() != "") { model.RPayUID = new Guid(table.Rows[0]["RPayUID"].ToString()); } if (table.Rows[0]["PlanUID"].ToString() != "") { model.PlanUID = new Guid(table.Rows[0]["PlanUID"].ToString()); } model.ContractID = table.Rows[0]["ContractID"].ToString(); model.RPaysubject = table.Rows[0]["RPaysubject"].ToString(); if (table.Rows[0]["RPayMoney"].ToString() != "") { model.RPayMoney = new decimal?(decimal.Parse(table.Rows[0]["RPayMoney"].ToString())); } model.ReMark = table.Rows[0]["ReMark"].ToString(); model.RPayUser = table.Rows[0]["RPayUser"].ToString(); if (table.Rows[0]["OrderID"].ToString() != "") { model.OrderID = int.Parse(table.Rows[0]["OrderID"].ToString()); } model.RPayCause = table.Rows[0]["RPayCause"].ToString(); if (table.Rows[0]["isInterest"].ToString() != "") { if ((table.Rows[0]["isInterest"].ToString() == "1") || (table.Rows[0]["isInterest"].ToString().ToLower() == "true")) { model.isInterest = true; return(model); } model.isInterest = false; } return(model); }
protected void SavePlanDetails() { this.SaveEditData(); DataTable dataTable = new DataTable(); if (this.ViewState["PlanTable"] != null) { dataTable = (this.ViewState["PlanTable"] as DataTable); } for (int i = 0; i < dataTable.Rows.Count; i++) { this.detailModel = new RequestPayDetailModel(); if (dataTable.Rows[i]["ContractID"].ToString() != "" && dataTable.Rows[i]["ContractID"] != null) { this.detailModel.ContractID = dataTable.Rows[i]["ContractID"].ToString(); } else { this.detailModel.ContractID = ""; } if (dataTable.Rows[i]["PlanUID"] != null && dataTable.Rows[i]["PlanUID"].ToString() != "") { this.detailModel.PlanUID = new Guid(dataTable.Rows[i]["PlanUID"].ToString()); } this.detailModel.ReMark = dataTable.Rows[i]["ReMark"].ToString(); this.detailModel.RPayMainID = new Guid(dataTable.Rows[i]["RPayMainID"].ToString()); this.detailModel.RPayMoney = new decimal?(Convert.ToDecimal(dataTable.Rows[i]["RPayMoney"].ToString())); this.detailModel.RPaysubject = dataTable.Rows[i]["RPaysubject"].ToString(); this.detailModel.RPayUser = dataTable.Rows[i]["RPayUser"].ToString(); this.detailModel.RPayUID = new Guid(dataTable.Rows[i]["RPayUID"].ToString()); this.detailModel.RPayCause = ""; this.detailModel.OrderID = 0; this.detailModel.isInterest = false; if (this.detailBill.Exists(this.detailModel.RPayUID)) { this.detailBill.Update(this.detailModel); } else { this.detailBill.Add(this.detailModel); } } }
public bool Add(RequestPayDetailModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Fund_RequestPay_Detail("); builder.Append("RPayMainID,RPayUID,PlanUID,ContractID,RPaysubject,RPayMoney,ReMark,RPayUser,RPayCause,isInterest)"); builder.Append(" values ("); builder.Append("@RPayMainID,@RPayUID,@PlanUID,@ContractID,@RPaysubject,@RPayMoney,@ReMark,@RPayUser,@RPayCause,@isInterest)"); builder.Append(";select @@IDENTITY"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@RPayMainID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@RPayUID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@PlanUID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@RPaysubject", SqlDbType.VarChar, 30), new SqlParameter("@RPayMoney", SqlDbType.Money, 8), new SqlParameter("@ReMark", SqlDbType.VarChar, 100), new SqlParameter("@RPayUser", SqlDbType.VarChar, 50), new SqlParameter("@RPayCause", SqlDbType.Text), new SqlParameter("@isInterest", SqlDbType.Bit, 1) }; commandParameters[0].Value = model.RPayMainID; commandParameters[1].Value = model.RPayUID; commandParameters[2].Value = model.PlanUID; commandParameters[3].Value = model.ContractID; commandParameters[4].Value = model.RPaysubject; commandParameters[5].Value = model.RPayMoney; commandParameters[6].Value = model.ReMark; commandParameters[7].Value = model.RPayUser; commandParameters[8].Value = model.RPayCause; commandParameters[9].Value = model.isInterest; return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters) > 0); }
public bool Add(RequestPayDetailModel model) { return(this.dal.Add(model)); }
public bool Update(RequestPayDetailModel model) { return(this.dal.Update(model)); }