コード例 #1
0
        private string getconcode()
        {
            pp_contract pc = new pp_contract();

            string strpdcode  = pc.getmaxconcode();
            string strprecode = "SC";

            if (strpdcode.Length == 1)
            {
                strpdcode = strprecode + "000" + strpdcode;
            }
            else if (strpdcode.Length == 2)
            {
                strpdcode = strprecode + "00" + strpdcode;
            }
            else if (strpdcode.Length == 3)
            {
                strpdcode = strprecode + "0" + strpdcode;
            }
            else
            {
                strpdcode = strprecode + strpdcode;
            }

            return(strpdcode);
        }
コード例 #2
0
        private void initinfo(string strID)
        {
            pp_contract pc = new pp_contract();

            System.Data.DataTable dt = pc.getEditdata(strID);

            DataRow r = dt.Rows[0];

            editID.Text          = strID;
            conname.Text         = r["conname"].ToString().Trim();
            concode.Text         = r["concode"].ToString().Trim();
            partyA.Text          = r["partyA"].ToString().Trim();
            conserial.Text       = r["conserial"].ToString().Trim();
            condate.SelectedDate = DateTime.Parse(r["condate"].ToString().Trim());
        }
コード例 #3
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            int[] intRowindexarray = mainGrid.SelectedRowIndexArray;

            if (intRowindexarray.Length > 0)
            {
                pp_contract pc    = new pp_contract();
                object[]    keys  = mainGrid.DataKeys[intRowindexarray[0]];
                string      strID = keys[0].ToString();

                List <Dictionary <string, string> > listdic = new List <Dictionary <string, string> >();
                Dictionary <string, string>         dic     = new Dictionary <string, string>();
                List <string> listTablename = new List <string>();

                dic.Add("ID", " cast(ID as varchar(36))='" + strID + "' ");
                listdic.Add(dic);
                dic = new Dictionary <string, string>();
                dic.Add("pid", " cast(pid as varchar(36))='" + strID + "' ");
                listdic.Add(dic);

                listTablename.Add("pp_contract");
                listTablename.Add("pp_contract_content");
                int intresult = pc.deleteMutri(listdic, listTablename);

                setPageContent(5);
                childGrid.DataSource = null;
                childGrid.DataBind();
                erasechild();

                Alert alert = new Alert();

                if (intresult > 0)
                {
                    alert.Icon    = Icon.Information;
                    alert.Message = "成功移除数据";
                }
                else
                {
                    alert.MessageBoxIcon = MessageBoxIcon.Error;
                    alert.Message        = "数据移除失败";
                }

                alert.Show();
            }
        }
コード例 #4
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Dictionary <string, string> dic = initDatadic();
            string      strID     = editID.Text.ToString().Trim();
            pp_contract pc        = new pp_contract();
            int         intresult = 0;

            if (strID == "")
            {
                dic.Add("ID", Guid.NewGuid().ToString());

                intresult = pc.add(dic, "pp_contract");
            }
            else
            {
                intresult = pc.update(dic, "pp_contract", "ID", strID);
            }

            if (CurPage.Text.Trim() == "")
            {
                setPageContent(1);
            }
            else
            {
                setPageContent(5);
            }

            Alert alert = new Alert();

            if (intresult == 1)
            {
                alert.Icon    = Icon.Information;
                alert.Message = "数据保存成功";
            }
            else
            {
                alert.MessageBoxIcon = MessageBoxIcon.Error;
                alert.Message        = "数据保存失败";
            }

            alert.Show();
        }
コード例 #5
0
        private void BindGrid()
        {
            string strf_partyA  = f_partyA.Text.Trim();
            string strf_conname = f_conname.Text.Trim();

            Dictionary <string, string> dic = new Dictionary <string, string>();

            dic.Add("partyA", strf_partyA);
            dic.Add("conname", strf_conname);

            int    intPageindex     = Convert.ToInt32(CurPage.Text.Trim());
            int    intPagesize      = Convert.ToInt32(GridPageSize.Text.Trim());
            string strSort          = mainGrid.SortField;
            string strSortDirection = mainGrid.SortDirection;

            pp_contract pc = new pp_contract();
            DataTable   dt = pc.getBindDataAsdt(dic, strSort, strSortDirection, intPagesize, intPageindex);

            TotalPage.Text = pc.gettotalpage(dic);

            mainGrid.DataSource = dt;
            mainGrid.DataBind();
        }