Esempio n. 1
0
        private void simpleButtonOK_Click(object sender, EventArgs e)
        {
            ConnDB conn = new ConnDB();
            string sql  = "update cost_saletype set cname = ltrim(rtrim('" + textEditNew.Text.ToString() + "')) where cname = ltrim(rtrim('" + textEditOld.Text.ToString() + "'))";
            string sql2 = "select cname from cost_saletype where cname = LTRIM(rtrim('" + textEditNew.Text.ToString() + "'))";

            if (textEditNew.Text.ToString().Trim() != "")
            {
                int rows = conn.ReturnRecordCount(sql2);
                if (rows > 0)
                {
                    MessageBox.Show("该营业类型已经存在!");
                }
                else
                {
                    bool isok = conn.EditDatabase(sql);
                    if (isok)
                    {
                        MessageBox.Show("修改成功!");
                        SaleTypeQuery.RefreshEX();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("失败!");
                    }
                }
            }
            else
            {
                MessageBox.Show("新值不能为空!");
            }
            conn.Close();
        }
Esempio n. 2
0
        private void simpleButtonOK_Click(object sender, EventArgs e)
        {
            ConnDB conn = new ConnDB();
            string strsql, strsql2;
            int    rows;

            strsql  = "insert into cost_saletype(CNAME) values(LTRIM(rtrim('" + textEditName.Text.ToString() + "')))";
            strsql2 = "select cname from cost_saletype where cname = LTRIM(rtrim('" + textEditName.Text.ToString() + "'))";
            if (textEditName.Text.ToString().Trim() != "")
            {
                rows = conn.ReturnRecordCount(strsql2);
                if (rows > 0)
                {
                    MessageBox.Show("该营业类型已经存在!");
                }
                else
                {
                    bool isok = conn.EditDatabase(strsql);
                    if (isok)
                    {
                        MessageBox.Show("添加成功!");
                        SaleTypeQuery.RefreshEX();
                        this.Close();
                    }
                }
            }
            else
            {
                MessageBox.Show("名称不能为空!");
            }
            conn.Close();
        }
Esempio n. 3
0
 public static SaleTypeQuery GetInstance()
 {
     if (stqform == null || stqform.IsDisposed)
     {
         stqform = new SaleTypeQuery();
     }
     return(stqform);
 }
Esempio n. 4
0
        private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e)
        {
            SaleTypeQuery Frm = SaleTypeQuery.GetInstance();

            Frm.TopLevel = false;
            Frm.Parent   = this;
            Frm.Show();
            Frm.BringToFront();
        }
Esempio n. 5
0
        private void SaleTypeUpdate_Load(object sender, EventArgs e)
        {
            //this.WindowState = FormWindowState.Maximized;
            string cname = SaleTypeQuery.GetCname();

            if (cname != "")
            {
                textEditOld.Text = cname;
            }
        }
Esempio n. 6
0
        private void SaleType_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            SaleTypeQuery Frm = SaleTypeQuery.GetInstance();

            Frm.TopLevel = false;
            Frm.Parent   = this;
            Frm.Show();
            Frm.BringToFront();
            //Frm.Width = this.Width - 15;
            //Frm.Height = this.Width - 60;
        }
Esempio n. 7
0
        private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e)
        {
            string cname = SaleTypeQuery.GetCname();

            if (cname != "")
            {
                //SaleTypeUpdate Frm = SaleTypeUpdate.GetInstance();
                SaleTypeUpdate Frm = new SaleTypeUpdate();
                Frm.TopLevel = false;
                Frm.Parent   = this;
                Frm.Show();
                Frm.BringToFront();
            }
        }
Esempio n. 8
0
 private void barButtonItem反禁用_ItemClick(object sender, ItemClickEventArgs e)
 {
     SaleTypeQuery.cEnable();
     SaleTypeQuery.RefreshEX();
 }
Esempio n. 9
0
 private void barButtonItem删除_ItemClick(object sender, ItemClickEventArgs e)
 {
     SaleTypeQuery.Delete();
     SaleTypeQuery.RefreshEX();
 }