/// <summary> /// 得到一个对象实体 /// </summary> public RegReimbursement GetModel(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, payStatus, paymentMode, payerID, payerName, paymentDate, makeTime, makerID, makerName,hasInvoice,hasInvoiceDate,bankId,bankname,banknum,payremark "); strSql.Append(" from RegReimbursement "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 50) }; parameters[0].Value = id; RegReimbursement model = new RegReimbursement(); DataTable dt = DBHelper.GetDataSet(strSql.ToString(), parameters); if (dt.Rows.Count > 0) { model.id = dt.Rows[0]["id"].ToString(); if (dt.Rows[0]["payStatus"].ToString() != "") { model.payStatus = int.Parse(dt.Rows[0]["payStatus"].ToString()); } if (dt.Rows[0]["paymentMode"].ToString() != "") { model.paymentMode = int.Parse(dt.Rows[0]["paymentMode"].ToString()); } if (dt.Rows[0]["payerID"].ToString() != "") { model.payerID = int.Parse(dt.Rows[0]["payerID"].ToString()); } model.payerName = dt.Rows[0]["payerName"].ToString(); if (dt.Rows[0]["paymentDate"].ToString() != "") { model.paymentDate = DateTime.Parse(dt.Rows[0]["paymentDate"].ToString()); } if (dt.Rows[0]["makeTime"].ToString() != "") { model.makeTime = DateTime.Parse(dt.Rows[0]["makeTime"].ToString()); } if (dt.Rows[0]["makerID"].ToString() != "") { model.makerID = int.Parse(dt.Rows[0]["makerID"].ToString()); } model.makerName = dt.Rows[0]["makerName"].ToString(); model.payremark = dt.Rows[0]["payremark"].ToString(); model.bankName = dt.Rows[0]["bankname"].ToString(); model.bankNum = dt.Rows[0]["banknum"].ToString(); model.bankId = Convert.IsDBNull(dt.Rows[0]["bankId"]) ? 0 : Convert.ToInt32(dt.Rows[0]["bankId"].ToString()); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(RegReimbursement model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RegReimbursement ("); strSql.Append("id,payStatus,paymentMode,payerID,payerName,paymentDate,makeTime,makerID,makerName,ausID,payremark,bankname,banknum,bankId"); strSql.Append(") values ("); strSql.Append("@id,@payStatus,@paymentMode,@payerID,@payerName,@paymentDate,@makeTime,@makerID,@makerName,@ausID,@payremark,@bankname,@banknum,@bankId"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 50), new SqlParameter("@payStatus", SqlDbType.TinyInt, 1), new SqlParameter("@paymentMode", SqlDbType.TinyInt, 1), new SqlParameter("@payerID", SqlDbType.Int, 4), new SqlParameter("@payerName", SqlDbType.VarChar, 50), new SqlParameter("@paymentDate", SqlDbType.DateTime), new SqlParameter("@makeTime", SqlDbType.DateTime), new SqlParameter("@makerID", SqlDbType.Int, 4), new SqlParameter("@makerName", SqlDbType.VarChar, 50), new SqlParameter("@ausID", SqlDbType.Int, 4), new SqlParameter("@payremark", SqlDbType.VarChar, 100), new SqlParameter("@bankname", SqlDbType.VarChar, 100), new SqlParameter("@banknum", SqlDbType.VarChar, 100), new SqlParameter("@bankId", SqlDbType.Int, 4), }; parameters[0].Value = model.id; parameters[1].Value = model.payStatus; parameters[2].Value = model.paymentMode; parameters[3].Value = model.payerID; parameters[4].Value = model.payerName; parameters[5].Value = model.paymentDate; parameters[6].Value = model.makeTime; parameters[7].Value = model.makerID; parameters[8].Value = model.makerName; parameters[9].Value = model.ausID; parameters[10].Value = model.payremark; parameters[11].Value = model.bankName; parameters[12].Value = model.bankNum; parameters[13].Value = model.bankId; int row = DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得数据列表 /// </summary> public List <RegReimbursement> DataTableToList(DataTable dt) { List <RegReimbursement> modelList = new List <RegReimbursement>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { RegReimbursement model; for (int n = 0; n < rowsCount; n++) { model = new RegReimbursement(); model.id = dt.Rows[n]["id"].ToString(); if (dt.Rows[n]["payStatus"].ToString() != "") { model.payStatus = int.Parse(dt.Rows[n]["payStatus"].ToString()); } if (dt.Rows[n]["paymentMode"].ToString() != "") { model.paymentMode = int.Parse(dt.Rows[n]["paymentMode"].ToString()); } if (dt.Rows[n]["payerID"].ToString() != "") { model.payerID = int.Parse(dt.Rows[n]["payerID"].ToString()); } model.payerName = dt.Rows[n]["payerName"].ToString(); if (dt.Rows[n]["paymentDate"].ToString() != "") { model.paymentDate = DateTime.Parse(dt.Rows[n]["paymentDate"].ToString()); } if (dt.Rows[n]["makeTime"].ToString() != "") { model.makeTime = DateTime.Parse(dt.Rows[n]["makeTime"].ToString()); } if (dt.Rows[n]["makerID"].ToString() != "") { model.makerID = int.Parse(dt.Rows[n]["makerID"].ToString()); } model.makerName = dt.Rows[n]["makerName"].ToString(); modelList.Add(model); } } return(modelList); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string paystatus = Request.QueryString["pay"]; LoadAusRottenData(); LoadFile(); LoadData(); if (paystatus == "1") //已经支付了 { string regid = Request.QueryString["regID"].ToString().Trim(); RegReimbursementManager rem = new RegReimbursementManager(); RegReimbursement reg = rem.GetModel(regid); this.txtPayer.Text = reg.payerName; this.txtPaymentDate.Text = reg.paymentDate.ToString("yyyy-MM-dd"); //this.ddlPaymentMode.SelectedValue = reg.paymentMode.ToString(); this.iptremark.Value = reg.payremark.ToString(); this.btnSave.Visible = false; this.chkIsPay.Checked = true; this.chkIsPay.Enabled = false; //this.ddlPaymentMode.Enabled = false; this.iptremark.Disabled = true; this.iptbankname.Disabled = true; this.iptbanknum.Disabled = true; this.txtPaymentDate.Attributes.Add("onfocus", ""); } else { txtPayer.Text = (Session["login"] as LoginInfo).Cname; txtPaymentDate.Text = DateTime.Now.ToString("yyyy-MM-dd"); this.txtPaymentDate.CssClass = "inputLine readonly Wdate"; } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RegReimbursement model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RegReimbursement set "); strSql.Append(" id = @id , "); strSql.Append(" payStatus = @payStatus , "); strSql.Append(" paymentMode = @paymentMode , "); strSql.Append(" payerID = @payerID , "); strSql.Append(" payerName = @payerName , "); strSql.Append(" paymentDate = @paymentDate , "); strSql.Append(" makeTime = @makeTime , "); strSql.Append(" makerID = @makerID , "); strSql.Append(" makerName = @makerName, "); strSql.Append(" payremark = @payremark, "); strSql.Append(" bankname = @bankname, "); strSql.Append(" banknum = @banknum, "); strSql.Append(" bankId = @bankId "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 50), new SqlParameter("@payStatus", SqlDbType.TinyInt, 1), new SqlParameter("@paymentMode", SqlDbType.TinyInt, 1), new SqlParameter("@payerID", SqlDbType.Int, 4), new SqlParameter("@payerName", SqlDbType.VarChar, 50), new SqlParameter("@paymentDate", SqlDbType.DateTime), new SqlParameter("@makeTime", SqlDbType.DateTime), new SqlParameter("@makerID", SqlDbType.Int, 4), new SqlParameter("@makerName", SqlDbType.VarChar, 50), new SqlParameter("@payremark", SqlDbType.VarChar, 100), new SqlParameter("@bankname", SqlDbType.VarChar, 100), new SqlParameter("@banknum", SqlDbType.VarChar, 100), new SqlParameter("@bankId", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.payStatus; parameters[2].Value = model.paymentMode; parameters[3].Value = model.payerID; parameters[4].Value = model.payerName; parameters[5].Value = model.paymentDate; parameters[6].Value = model.makeTime; parameters[7].Value = model.makerID; parameters[8].Value = model.makerName; parameters[9].Value = model.payremark; parameters[10].Value = model.bankName; parameters[11].Value = model.bankNum; parameters[12].Value = model.bankId; int rows = DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RegReimbursement model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(RegReimbursement model) { return(dal.Add(model)); }
/// <summary> /// 保存报销登记,保存的信息有(其他信息保存到RegReimbursement表中) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, ImageClickEventArgs e) { #region 无用代码 /////////// //EtNet_Models.RegReimbursement mReg = new RegReimbursement(); //LoginInfo currentUser = Session["login"] as LoginInfo; //mReg.id = Guid.NewGuid().ToString(); //mReg.makerID = currentUser.Id; //mReg.makerName = currentUser.Cname; //mReg.makeTime = DateTime.Now; //mReg.payerID = currentUser.Id; //mReg.payerName = currentUser.Cname; //mReg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim()); //mReg.paymentMode = int.Parse(ddlPaymentMode.SelectedValue.Trim()); //mReg.payStatus = chkIsPay.Checked ? 1 : 0; //mReg.hasInvoice = int.Parse(ddlHasInvoiceNum.SelectedValue.Trim()); //if (txtHasInvoceDate.Text.Trim() != "") //收到发票日期 //{ // mReg.hasInvoiceDate = Convert.ToDateTime(txtHasInvoceDate.Text); //} //if (Request.QueryString["ausID"] != null) //{ // int ausID; // int.TryParse(Request.QueryString["ausID"].ToString(), out ausID); // mReg.ausID = ausID; //} //RegReimbursementManager bReg = new RegReimbursementManager(); //ReimbursementInvoice mRI = new ReimbursementInvoice(); //ReimbursementInvoiceManager bRI = new ReimbursementInvoiceManager(); //if (Request.QueryString["regID"] != null && Request.QueryString["regID"].ToString().Trim() != string.Empty) //{ // string regID = Request.QueryString["regID"].ToString().Trim(); // if (string.Empty != regID) // { // mReg = bReg.GetModel(regID); // if (mReg != null) // { // mReg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim()); // mReg.paymentMode = int.Parse(ddlPaymentMode.SelectedValue.Trim()); // mReg.payStatus = chkIsPay.Checked ? 1 : 0; // mReg.hasInvoice = int.Parse(ddlHasInvoiceNum.SelectedValue.Trim()); // if (this.txtHasInvoceDate.Text.Trim() != "") // { // mReg.hasInvoiceDate = Convert.ToDateTime(this.txtHasInvoceDate.Text); // } // bReg.Update(mReg); // bRI.DeleteByRegID(regID); // } // } //} //else // bReg.Add(mReg); //string jsonString = hidInvoiceDate.Value; //List<InvoiceData> invoiceList = ReadJson(jsonString); //mRI.reimbursementID = mReg.id; //for (int i = 0, len = invoiceList.Count(); i < len; i++) //{ // InvoiceData invoiceData = invoiceList[i]; // mRI.id = Guid.NewGuid().ToString(); // mRI.invoiceNum = invoiceData.Num; // mRI.remark = invoiceData.Remark; // if (mRI.invoiceNum.Trim() == string.Empty && mRI.remark.Trim() == string.Empty) // break; // bRI.Add(mRI); //} //ClientScript.RegisterStartupScript(Page.GetType(), "a", "alert('保存成功');self.location.href='RegReimbursedFormList.aspx';", true); #endregion EtNet_Models.RegReimbursement reg = new RegReimbursement(); LoginInfo payUser = Session["login"] as LoginInfo; if (Request.QueryString["ausID"] != null) { int ausID; int.TryParse(Request.QueryString["ausID"].ToString(), out ausID); reg.ausID = ausID; } reg.makerName = this.lblcanme.Text; //报销人员 reg.makeTime = DateTime.Parse(this.lblapplydate.Text.Trim()); //报销日期 reg.makerID = LoginInfoManager.getLoginIDByname(this.lblcanme.Text.Trim()); //得到报销人员关联id reg.payStatus = chkIsPay.Checked ? 1 : 0; //费用是否支付 reg.paymentMode = 1; /* int.Parse(ddlPaymentMode.SelectedValue.Trim()); //支付方式*/ reg.payerID = payUser.Id; //支付人关联id reg.payerName = payUser.Cname; //支付人名字 reg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim()); //支付时间 reg.payremark = this.iptremark.Value; //支付备注 reg.bankName = this.iptbankname.Value; //支付银行 reg.bankNum = this.iptbanknum.Value; //支付帐号 reg.bankId = int.Parse(this.hidbankid.Value); //支付银行对应id RegReimbursementManager regmanager = new RegReimbursementManager(); if (Request.QueryString["regID"] != null && Request.QueryString["regID"].ToString().Trim() != string.Empty) { string regID = Request.QueryString["regID"].ToString().Trim(); if (string.Empty != regID) { reg = regmanager.GetModel(regID); if (reg != null) { reg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim()); reg.paymentMode = 1; /* int.Parse(ddlPaymentMode.SelectedValue.Trim());*/ reg.payStatus = chkIsPay.Checked ? 1 : 0; reg.payremark = this.iptremark.Value; reg.bankName = this.iptbankname.Value; reg.bankNum = this.iptbanknum.Value; reg.bankId = int.Parse(this.hidbankid.Value); regmanager.Update(reg); } } } else { reg.id = Guid.NewGuid().ToString(); //id主键 regmanager.Add(reg); } ClientScript.RegisterStartupScript(Page.GetType(), "a", "alert('保存成功');self.location.href='RegReimbursedFormList.aspx';", true); }