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