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));
}
