public bool Update(PrjLoadModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update Fund_Prj_Loan set "); builder.Append("LoanCode=@LoanCode,"); builder.Append("PrjGuid=@PrjGuid, "); builder.Append("LoanDate=@LoanDate,"); builder.Append("LoanMan=@LoanMan,"); builder.Append("LoanFund=@LoanFund,"); builder.Append("LoanCause=@LoanCause,"); builder.Append("PlanReturnDate=@PlanReturnDate,"); builder.Append("LoanRate=@LoanRate,"); builder.Append("Remark=@Remark"); builder.Append(" where LoanID=@LoanID "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@LoanCode", SqlDbType.VarChar, 50), new SqlParameter("@PrjGuid", SqlDbType.UniqueIdentifier), new SqlParameter("@LoanDate", SqlDbType.DateTime), new SqlParameter("@LoanMan", SqlDbType.VarChar, 50), new SqlParameter("@LoanFund", SqlDbType.Decimal, 9), new SqlParameter("@LoanCause", SqlDbType.VarChar, 500), new SqlParameter("@PlanReturnDate", SqlDbType.DateTime), new SqlParameter("@LoanRate", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@LoanID", SqlDbType.UniqueIdentifier, 0x10) }; commandParameters[0].Value = model.LoanCode; commandParameters[1].Value = model.PrjGuid; commandParameters[2].Value = model.LoanDate; commandParameters[3].Value = model.LoanMan; commandParameters[4].Value = model.LoanFund; commandParameters[5].Value = model.LoanCause; commandParameters[6].Value = model.PlanReturnDate; commandParameters[7].Value = model.LoanRate; commandParameters[8].Value = model.Remark; commandParameters[9].Value = model.LoanID; return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters) > 0); }
public int Add(PrjLoadModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Fund_Prj_Loan("); builder.Append("LoanID,LoanCode,PrjGuid,LoanDate,LoanMan,LoanFund,LoanCause,PlanReturnDate,LoanRate,FlowState,Remark,ReturnState)"); builder.Append(" values ("); builder.Append("@LoanID,@LoanCode,@PrjGuid,@LoanDate,@LoanMan,@LoanFund,@LoanCause,@PlanReturnDate,@LoanRate,@FlowState,@Remark,@ReturnState)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@LoanID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@LoanCode", SqlDbType.VarChar, 50), new SqlParameter("@PrjGuid", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@LoanDate", SqlDbType.DateTime), new SqlParameter("@LoanMan", SqlDbType.VarChar, 50), new SqlParameter("@LoanFund", SqlDbType.Decimal, 9), new SqlParameter("@LoanCause", SqlDbType.VarChar, 500), new SqlParameter("@PlanReturnDate", SqlDbType.DateTime), new SqlParameter("@LoanRate", SqlDbType.Decimal, 9), new SqlParameter("@FlowState", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@ReturnState", SqlDbType.Int) }; commandParameters[0].Value = model.LoanID; commandParameters[1].Value = model.LoanCode; commandParameters[2].Value = model.PrjGuid; if (model.LoanDate.HasValue) { commandParameters[3].Value = model.LoanDate; } else { commandParameters[3].Value = DBNull.Value; } commandParameters[4].Value = model.LoanMan; commandParameters[5].Value = model.LoanFund; commandParameters[6].Value = model.LoanCause; if (model.PlanReturnDate.HasValue) { commandParameters[7].Value = model.PlanReturnDate; } else { commandParameters[7].Value = DBNull.Value; } commandParameters[8].Value = model.LoanRate; if (model.FlowState.HasValue) { commandParameters[9].Value = model.FlowState; } else { commandParameters[9].Value = -1; } commandParameters[10].Value = model.Remark; commandParameters[11].Value = model.ReturnState; object obj2 = SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters); if (obj2 == null) { return(0); } return(Convert.ToInt32(obj2)); }
public PrjLoadModel GetModel(Guid LoanID) { StringBuilder builder = new StringBuilder(); builder.Append("SELECT TOP 1 fpl.LoanID,fpl.LoanCode,fpl.PrjGuid, "); builder.Append("fpl.LoanDate,fpl.LoanMan, "); builder.Append("fpl.LoanFund,fpl.LoanCause, "); builder.Append("fpl.PlanReturnDate,fpl.LoanRate, "); builder.Append("fpl.Remark,fpl.FlowState, "); builder.Append("fpl.ReturnDate,fpl.ReturnMan, "); builder.Append("fpl.ReturnState,"); builder.Append("py.v_xm AS LoanManName,"); builder.Append("pyc.v_xm AS ReturnManName "); builder.Append(",ppi.PrjName "); builder.Append("FROM Fund_Prj_Loan fpl "); builder.Append("LEFT JOIN PT_yhmc py ON fpl.LoanMan=py.v_yhdm "); builder.Append(" LEFT JOIN PT_PrjInfo ppi ON ppi.PrjGuid=fpl.PrjGuid "); builder.Append(" LEFT JOIN PT_yhmc pyc ON fpl.ReturnMan=py.v_yhdm "); builder.Append(" where LoanID=@LoanID "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@LoanID", SqlDbType.UniqueIdentifier, 0x10) }; commandParameters[0].Value = LoanID; PrjLoadModel model = new PrjLoadModel(); DataTable table = SqlHelper.ExecuteQuery(CommandType.Text, builder.ToString(), commandParameters); if (table.Rows.Count <= 0) { return(null); } if ((table.Rows[0]["LoanID"] != null) && (table.Rows[0]["LoanID"].ToString() != "")) { model.LoanID = new Guid(table.Rows[0]["LoanID"].ToString()); } if ((table.Rows[0]["LoanCode"] != null) && (table.Rows[0]["LoanCode"].ToString() != "")) { model.LoanCode = table.Rows[0]["LoanCode"].ToString(); } if ((table.Rows[0]["PrjGuid"] != null) && (table.Rows[0]["PrjGuid"].ToString() != "")) { model.PrjGuid = new Guid(table.Rows[0]["PrjGuid"].ToString()); } if ((table.Rows[0]["LoanDate"] != null) && (table.Rows[0]["LoanDate"].ToString() != "")) { model.LoanDate = new DateTime?(DateTime.Parse(table.Rows[0]["LoanDate"].ToString())); } if ((table.Rows[0]["LoanMan"] != null) && (table.Rows[0]["LoanMan"].ToString() != "")) { model.LoanMan = table.Rows[0]["LoanMan"].ToString(); } if ((table.Rows[0]["LoanFund"] != null) && (table.Rows[0]["LoanFund"].ToString() != "")) { model.LoanFund = new decimal?(decimal.Parse(table.Rows[0]["LoanFund"].ToString())); } if ((table.Rows[0]["LoanCause"] != null) && (table.Rows[0]["LoanCause"].ToString() != "")) { model.LoanCause = table.Rows[0]["LoanCause"].ToString(); } if ((table.Rows[0]["PlanReturnDate"] != null) && (table.Rows[0]["PlanReturnDate"].ToString() != "")) { model.PlanReturnDate = new DateTime?(DateTime.Parse(table.Rows[0]["PlanReturnDate"].ToString())); } if ((table.Rows[0]["LoanRate"] != null) && (table.Rows[0]["LoanRate"].ToString() != "")) { model.LoanRate = new decimal?(decimal.Parse(table.Rows[0]["LoanRate"].ToString())); } if ((table.Rows[0]["Remark"] != null) && (table.Rows[0]["Remark"].ToString() != "")) { model.Remark = table.Rows[0]["Remark"].ToString(); } if ((table.Rows[0]["FlowState"] != null) && (table.Rows[0]["FlowState"].ToString() != "")) { model.FlowState = new int?(int.Parse(table.Rows[0]["FlowState"].ToString())); } if ((table.Rows[0]["ReturnDate"] != null) && (table.Rows[0]["ReturnDate"].ToString() != "")) { model.ReturnDate = new DateTime?(DateTime.Parse(table.Rows[0]["ReturnDate"].ToString())); } if ((table.Rows[0]["ReturnMan"] != null) && (table.Rows[0]["ReturnMan"].ToString() != "")) { model.ReturnMan = table.Rows[0]["ReturnMan"].ToString(); } if ((table.Rows[0]["LoanManName"] != null) && (table.Rows[0]["LoanManName"].ToString() != "")) { model.LoanmanName = table.Rows[0]["LoanManName"].ToString(); } if ((table.Rows[0]["ReturnManName"] != null) && (table.Rows[0]["ReturnManName"].ToString() != "")) { model.ReturnmanName = table.Rows[0]["ReturnManName"].ToString(); } if ((table.Rows[0]["PrjName"] != null) && (table.Rows[0]["PrjName"].ToString() != "")) { model.PrjName = table.Rows[0]["PrjName"].ToString(); } model.ReturnState = 0; if (table.Rows[0]["ReturnState"].ToString() != "") { model.ReturnState = new int?(Convert.ToInt32(table.Rows[0]["ReturnState"].ToString())); } return(model); }