WebUI/consumes/consumeview.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace hyst.consumes
{
    using DBUtility;
    using Model;
    using System;
    using System.Data;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;

    public class consumeview : Page
    {
        private BaseClass bc = new BaseClass();
        protected Button Button2;
        protected DropDownList ddlcDiscount;
        protected DropDownList ddlcIfbargain;
        protected DropDownList ddlIfshow;
        protected DropDownList ddlIsZeng;
        protected DropDownList ddljifen;
        protected DropDownList ddltype;
        public DataTable dt;
        protected HtmlForm form1;
        protected HtmlHead Head1;
        protected HtmlInputText txtBargain;
        protected HtmlInputText txtcount;
        protected HtmlInputText txtinprice;
        protected HtmlInputText txtname;
        protected HtmlInputText txtnum;
        protected HtmlInputText txtprice;
        protected TextBox txtremark;
        protected HtmlInputText txttixing;

        protected void Button2_Click(object sender, EventArgs e)
        {
            string sqlup = "update  consumes  set cNum='" + this.txtnum.Value + "',cName='" + this.txtname.Value + "',cPrice='" + this.txtprice.Value + "',cIfbargain='" + this.ddlcIfbargain.SelectedValue + "',cBargain='" + this.txtBargain.Value + "',cJifen='" + this.ddljifen.SelectedValue + "',cDiscount='" + this.ddlcDiscount.SelectedValue + "',cIfshow='" + this.ddlIfshow.SelectedValue + "',cRemark='" + this.txtremark.Text + "',cInprice='" + this.txtinprice.Value + "',cCount='" + this.txtcount.Value + "',IsZeng='" + this.ddlIsZeng.SelectedValue + "',cRemind='" + this.txttixing.Value + "' where cNum = '" + base.Request.QueryString["cnum"].ToString() + "' and csNum ='" + PublicMethod.GetSessionValue("shopnum") + "'";
            this.bc.execsql(sqlup);
            base.ClientScript.RegisterStartupScript(base.ClientScript.GetType(), "myscript", "<script> $.ligerDialog.success('保存成功！');</script>");
            string str = "项目编号：" + this.txtnum.Value + ",项目名称：" + this.txtname.Value + ",类别" + this.ddltype.SelectedItem.Text;
            string strl = " insert into WorkNote(Wn_Person,Wn_Time,Wn_type,wn_dianpu,wn_ip,wn_Remark) values ('" + PublicMethod.GetSessionValue("names") + "','" + DateTime.Now.ToString() + "','修改消费项目','" + PublicMethod.GetSessionValue("shopnum") + "','" + Userinfo.getIPAddress() + "','" + str + "')";
            this.bc.execsql(strl);
            this.loadlevel();
            this.load();
        }

        public void load()
        {
            string sqlf = "select * from consumes where cNum = '" + base.Request.QueryString["cnum"].ToString() + "' and csNum ='" + PublicMethod.GetSessionValue("shopnum") + "'";
            this.dt = this.bc.ReadTable(sqlf);
            if (this.dt.Rows.Count > 0)
            {
                this.txtnum.Value = this.dt.Rows[0]["cNum"].ToString();
                this.txtname.Value = this.dt.Rows[0]["cName"].ToString();
                this.txtprice.Value = this.dt.Rows[0]["cPrice"].ToString();
                this.ddltype.SelectedValue = this.dt.Rows[0]["cTnum"].ToString();
                this.ddlcIfbargain.SelectedValue = this.dt.Rows[0]["cIfbargain"].ToString();
                this.txtBargain.Value = this.dt.Rows[0]["cBargain"].ToString();
                this.ddljifen.SelectedValue = this.dt.Rows[0]["cJifen"].ToString();
                this.ddlcDiscount.SelectedValue = this.dt.Rows[0]["cDiscount"].ToString();
                this.ddlIfshow.SelectedValue = this.dt.Rows[0]["cIfshow"].ToString();
                this.txtremark.Text = this.dt.Rows[0]["cRemark"].ToString();