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