public OAOfficeResJoinDrawItem GetModel(string UserCode)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" UserCode,DrawItemID,FactNumber,SumFee,DrawDate ");
builder.Append(" from OA_OfficeRes_JoinDrawItem ");
builder.Append(" where UserCode='" + UserCode + "'");
OAOfficeResJoinDrawItem item = new OAOfficeResJoinDrawItem();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
item.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["DrawItemID"].ToString() != "")
{
item.DrawItemID = int.Parse(set.Tables[0].Rows[0]["DrawItemID"].ToString());
}
if (set.Tables[0].Rows[0]["FactNumber"].ToString() != "")
{
item.FactNumber = int.Parse(set.Tables[0].Rows[0]["FactNumber"].ToString());
}
if (set.Tables[0].Rows[0]["SumFee"].ToString() != "")
{
item.SumFee = decimal.Parse(set.Tables[0].Rows[0]["SumFee"].ToString());
}
if (set.Tables[0].Rows[0]["DrawDate"].ToString() != "")
{
item.DrawDate = DateTime.Parse(set.Tables[0].Rows[0]["DrawDate"].ToString());
}
return(item);
}
public int Update(OAOfficeResJoinDrawItem model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_JoinDrawItem set ");
builder.Append("FactNumber=" + model.FactNumber + ",");
builder.Append("SumFee=" + model.SumFee + ",");
builder.Append("DrawDate='" + model.DrawDate + "'");
builder.Append(" where UserCode='" + model.UserCode + "'");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(OAOfficeResJoinDrawItem model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_OfficeRes_JoinDrawItem(");
builder.Append("UserCode,DrawItemID,FactNumber,SumFee,DrawDate");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.UserCode + "',");
builder.Append(model.DrawItemID + ",");
builder.Append(model.FactNumber + ",");
builder.Append(model.SumFee + ",");
builder.Append("'" + model.DrawDate + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
private ArrayList GetData()
{
ArrayList arrayList = new ArrayList();
foreach (GridViewRow gridViewRow in this.GVBook.Rows)
{
OAOfficeResJoinDrawItem oAOfficeResJoinDrawItem = new OAOfficeResJoinDrawItem();
oAOfficeResJoinDrawItem.DrawDate = DateTime.Now;
oAOfficeResJoinDrawItem.DrawItemID = ((((HtmlInputHidden)gridViewRow.Cells[4].FindControl("HdnMatterialID")).Value.Trim() == "") ? 0 : int.Parse(((HtmlInputHidden)gridViewRow.Cells[4].FindControl("HdnMatterialID")).Value.Trim()));
oAOfficeResJoinDrawItem.FactNumber = ((((HtmlInputText)gridViewRow.Cells[4].FindControl("factNum")).Value.Trim() == "") ? 0 : int.Parse(((HtmlInputText)gridViewRow.Cells[4].FindControl("factNum")).Value.Trim()));
decimal d = (((HtmlInputHidden)gridViewRow.Cells[4].FindControl("HdnPlanFee")).Value.Trim() == "") ? 0m : Convert.ToDecimal(((HtmlInputHidden)gridViewRow.Cells[4].FindControl("HdnPlanFee")).Value.Trim());
oAOfficeResJoinDrawItem.SumFee = oAOfficeResJoinDrawItem.FactNumber * d;
oAOfficeResJoinDrawItem.UserCode = this.JoinUserCode;
arrayList.Add(oAOfficeResJoinDrawItem);
}
return(arrayList);
}
