public bool Update(PlanSummaryDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Fund_Plan_Summary_Detail set ");
builder.Append("MID=@MID,");
builder.Append("PlanID=@PlanID,");
builder.Append("PrjID=@PrjID,");
builder.Append("LastPlanMoney=@LastPlanMoney,");
builder.Append("LastActualMoney=@LastActualMoney,");
builder.Append("CurrPlanMoney=@CurrPlanMoney,");
builder.Append("InputPeople=@InputPeople,");
builder.Append("InputTime=@InputTime,");
builder.Append("Remark=@Remark");
builder.Append(" where DID=@DID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@DID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@MID", SqlDbType.VarChar, 50), new SqlParameter("@PlanID", SqlDbType.VarChar, 50), new SqlParameter("@PrjID", SqlDbType.VarChar, 50), new SqlParameter("@LastPlanMoney", SqlDbType.Decimal, 9), new SqlParameter("@LastActualMoney", SqlDbType.Decimal, 9), new SqlParameter("@CurrPlanMoney", SqlDbType.Decimal, 9), new SqlParameter("@InputPeople", SqlDbType.VarChar, 50), new SqlParameter("@InputTime", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.VarChar) };
commandParameters[0].Value = model.DID;
commandParameters[1].Value = model.MID;
commandParameters[2].Value = model.PlanID;
commandParameters[3].Value = model.PrjID;
commandParameters[4].Value = model.LastPlanMoney;
commandParameters[5].Value = model.LastActualMoney;
commandParameters[6].Value = model.CurrPlanMoney;
commandParameters[7].Value = model.InputPeople;
commandParameters[8].Value = model.InputTime;
commandParameters[9].Value = model.Remark;
return(((int)SqlHelper.ExecuteScalar(CommandType.Text, builder.ToString(), commandParameters)) > 0);
}
private void SaveDetail(string MID)
{
this.DetaillBLL.DeleteByMain(MID);
this.SaveView();
DataTable dataTable = new DataTable();
if (this.ViewState["DetailTab"] != null)
{
dataTable = (this.ViewState["DetailTab"] as DataTable);
}
for (int i = 0; i < dataTable.Rows.Count; i++)
{
this.detailModel = new PlanSummaryDetail();
this.detailModel.DID = new Guid(dataTable.Rows[i]["DID"].ToString());
this.detailModel.MID = MID;
this.detailModel.PlanID = dataTable.Rows[i]["MonthPlanID"].ToString();
this.detailModel.PrjID = dataTable.Rows[i]["PrjGuid"].ToString();
this.detailModel.Remark = dataTable.Rows[i]["Remark"].ToString();
this.detailModel.InputPeople = dataTable.Rows[i]["OperatorCode"].ToString();
this.detailModel.InputTime = new DateTime?(Convert.ToDateTime(dataTable.Rows[i]["OperateTime"].ToString()));
this.detailModel.LastActualMoney = new decimal?(Convert.ToDecimal(dataTable.Rows[i]["LastActualMoney"].ToString()));
this.detailModel.LastPlanMoney = new decimal?(Convert.ToDecimal(dataTable.Rows[i]["LastPlanMoney"].ToString()));
this.detailModel.CurrPlanMoney = new decimal?(Convert.ToDecimal(dataTable.Rows[i]["CurrPlanMoney"].ToString()));
this.DetaillBLL.Add(this.detailModel);
}
}
public PlanSummaryDetail GetModel(Guid DID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 DID,MID,PlanID,PrjID,LastPlanMoney,LastActualMoney,CurrPlanMoney,InputPeople,InputTime,Remark from Fund_Plan_Summary_Detail ");
builder.Append(" where DID=@DID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@DID", SqlDbType.UniqueIdentifier) };
commandParameters[0].Value = DID;
PlanSummaryDetail detail = new PlanSummaryDetail();
DataTable table = SqlHelper.ExecuteQuery(CommandType.Text, builder.ToString(), commandParameters);
if (table.Rows.Count <= 0)
{
return(null);
}
if (table.Rows[0]["DID"].ToString() != "")
{
detail.DID = new Guid(table.Rows[0]["DID"].ToString());
}
detail.MID = table.Rows[0]["MID"].ToString();
detail.PlanID = table.Rows[0]["PlanID"].ToString();
detail.PrjID = table.Rows[0]["PrjID"].ToString();
if (table.Rows[0]["LastPlanMoney"].ToString() != "")
{
detail.LastPlanMoney = new decimal?(decimal.Parse(table.Rows[0]["LastPlanMoney"].ToString()));
}
if (table.Rows[0]["LastActualMoney"].ToString() != "")
{
detail.LastActualMoney = new decimal?(decimal.Parse(table.Rows[0]["LastActualMoney"].ToString()));
}
if (table.Rows[0]["CurrPlanMoney"].ToString() != "")
{
detail.CurrPlanMoney = new decimal?(decimal.Parse(table.Rows[0]["CurrPlanMoney"].ToString()));
}
detail.InputPeople = table.Rows[0]["InputPeople"].ToString();
if (table.Rows[0]["InputTime"].ToString() != "")
{
detail.InputTime = new DateTime?(DateTime.Parse(table.Rows[0]["InputTime"].ToString()));
}
detail.Remark = table.Rows[0]["Remark"].ToString();
return(detail);
}
public bool Add(PlanSummaryDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Fund_Plan_Summary_Detail(");
builder.Append("DID,MID,PlanID,PrjID,LastPlanMoney,LastActualMoney,CurrPlanMoney,InputPeople,InputTime,Remark)");
builder.Append(" values (");
builder.Append("@DID,@MID,@PlanID,@PrjID,@LastPlanMoney,@LastActualMoney,@CurrPlanMoney,@InputPeople,@InputTime,@Remark)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@DID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@MID", SqlDbType.VarChar, 50), new SqlParameter("@PlanID", SqlDbType.VarChar, 50), new SqlParameter("@PrjID", SqlDbType.VarChar, 50), new SqlParameter("@LastPlanMoney", SqlDbType.Decimal, 9), new SqlParameter("@LastActualMoney", SqlDbType.Decimal, 9), new SqlParameter("@CurrPlanMoney", SqlDbType.Decimal, 9), new SqlParameter("@InputPeople", SqlDbType.VarChar, 50), new SqlParameter("@InputTime", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.VarChar) };
commandParameters[0].Value = model.DID;
commandParameters[1].Value = model.MID;
commandParameters[2].Value = model.PlanID;
commandParameters[3].Value = model.PrjID;
commandParameters[4].Value = model.LastPlanMoney;
commandParameters[5].Value = model.LastActualMoney;
commandParameters[6].Value = model.CurrPlanMoney;
commandParameters[7].Value = model.InputPeople;
commandParameters[8].Value = model.InputTime;
commandParameters[9].Value = model.Remark;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters) > 0);
}
public List <PlanSummaryDetail> DataTableToList(DataTable dt)
{
List <PlanSummaryDetail> list = new List <PlanSummaryDetail>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PlanSummaryDetail item = new PlanSummaryDetail();
if (dt.Rows[i]["DID"].ToString() != "")
{
item.DID = new Guid(dt.Rows[i]["DID"].ToString());
}
item.MID = dt.Rows[i]["MID"].ToString();
item.PlanID = dt.Rows[i]["PlanID"].ToString();
item.PrjID = dt.Rows[i]["PrjID"].ToString();
if (dt.Rows[i]["LastPlanMoney"].ToString() != "")
{
item.LastPlanMoney = new decimal?(decimal.Parse(dt.Rows[i]["LastPlanMoney"].ToString()));
}
if (dt.Rows[i]["LastActualMoney"].ToString() != "")
{
item.LastActualMoney = new decimal?(decimal.Parse(dt.Rows[i]["LastActualMoney"].ToString()));
}
if (dt.Rows[i]["CurrPlanMoney"].ToString() != "")
{
item.CurrPlanMoney = new decimal?(decimal.Parse(dt.Rows[i]["CurrPlanMoney"].ToString()));
}
item.InputPeople = dt.Rows[i]["InputPeople"].ToString();
if (dt.Rows[i]["InputTime"].ToString() != "")
{
item.InputTime = new DateTime?(DateTime.Parse(dt.Rows[i]["InputTime"].ToString()));
}
item.Remark = dt.Rows[i]["Remark"].ToString();
list.Add(item);
}
}
return(list);
}
public void Add(PlanSummaryDetail model)
{
this.dal.Add(model);
}
public void Update(PlanSummaryDetail model)
{
this.dal.Update(model);
}
