private void CopySPInfoToZC(string bid, string spid) { List <SearchField> list1 = new List <SearchField>(); list1.Add(new SearchField("id", spid, SearchFieldType.数值型)); Hashtable ht = this.tabCommand.SearchData(list1); ht.Remove("bid"); U_ZCBAOBU zcb1 = new U_ZCBAOBU(); string ids = zcb1.GetZCIDByBID(bid); zcb1.Close(); string[] str = ids.Split(','); U_ZCBU zc1 = new U_ZCBU(); this.tabCommand.TabName = "U_ZCSP"; for (int i = 0; i < str.Length; i++) { if (zc1.GetCurrentZcCZbyID1(str[i]) != null) { string czid = zc1.GetCurrentZcCZbyID1(str[i])["zcczid"].ToString(); ht["zcid"] = str[i]; ht["czid"] = czid; ht["PSCount"] = "0"; this.tabCommand.InsertData(ht); } } this.tabCommand.TabName = TabName; }
void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e) { ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch; if (search1 != null) { int totalRow = 0; int curpage = 1; List <SearchField> list1 = search1.SearchConditon; U_ZCBU Zc1 = new U_ZCBU(); DataSet ds1 = Zc1.GetZcBaoList(list1, curpage, -1, out totalRow); DataView dv1 = ds1.Tables[0].DefaultView; dv1.Sort = "num2"; this.GridView1.DataSource = dv1; this.GridView1.DataBind(); ds1.Dispose(); Zc1.Close(); this.PageNavigator1.TotalRows = totalRow; this.PageNavigator1.CurrentPage = curpage; } }
//显示资产数据 private void BindData(string danwei) { int totalRow = 0; int curpage = 1; if (ViewState["curpage"] != null) { curpage = (int)ViewState["curpage"]; } U_ZCBU Zc1 = new U_ZCBU(); List <SearchField> list1 = new List <SearchField>(); if (danwei != null) { list1.Add(new SearchField("danwei", danwei, SearchOperator.包含)); } string sql = " bstatus is null"; list1.Add(new SearchField("", sql, SearchOperator.用户定义)); DataSet ds1 = Zc1.GetZcBaoList(list1, curpage, -1, out totalRow); this.GridView1.DataSource = ds1; this.GridView1.DataBind(); ds1.Dispose(); Zc1.Close(); this.PageNavigator1.TotalRows = totalRow; this.PageNavigator1.CurrentPage = curpage; }
//绑定资产处置数据 private void BindData2(U_ZCBU zc1, string czid) { DataSet ds1 = zc1.GetCZFSByCZID(czid); int i = 1; String[] Afields = new string[] { "czfs", "czjg", "czss", "qcl", "yjfy" }; foreach (DataRow dr in ds1.Tables[0].Rows) { for (int j = 1; j <= 5; j++) { HiddenField hid1 = this.xmbj.Parent.FindControl(Afields[j - 1] + i) as HiddenField; if (hid1 != null) { hid1.Value = dr[Afields[j - 1]].ToString(); } } i++; if (i > 5) { break; } } ds1.Dispose(); }
//资产包详细信息 private void BindZcInfo() { U_ZCBAOBU zcb1 = new U_ZCBAOBU(); string ids = zcb1.GetZCIDByBID(Request["ID"].ToString()); U_ZCBU zc1 = new U_ZCBU(); DataSet ds1 = zc1.GetZCInfoByID(ids); this.Repeater1.DataSource = ds1; this.Repeater1.DataBind(); zcb1.Close(); //统计总和 for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { DataRow dr = ds1.Tables[0].Rows[i]; if (dr["bj"] != DBNull.Value) { this.sum1 = this.sum1 + double.Parse(dr["bj"].ToString()); } if (dr["lxhj"] != DBNull.Value) { this.sum2 = this.sum2 + double.Parse(dr["lxhj"].ToString()); } } }
//绑定律师及事务所的基本情况 private void BindSSQK() { if (Request["id"] != null) { U_ZCBU zc2 = new U_ZCBU(); DataSet ds = zc2.GetZCDBInfoByID(Request["id"].ToString()); string[] arr1 = { "lssws", "frdb", "wtls", "lxdh", "dwdz", "dzyj" }; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < arr1.Length; i++) { if (owner) { Util.SetControlValue(this.frdb.Parent.FindControl(arr1[i]), ds.Tables[0].Rows[0][arr1[i]]); this.frdb.Parent.FindControl(arr1[i] + "_1").Visible = false; } else { Util.SetControlValue(this.frdb.Parent.FindControl(arr1[i] + "_1"), ds.Tables[0].Rows[0][arr1[i]]); this.frdb.Parent.FindControl(arr1[i]).Visible = false; } } ds.Dispose(); } zc2.Close(); } }
//得到包内资产的本金合计 public Hashtable GetZcBbjANDlx(string bid) { string ids = this.GetZCIDByBID(bid); string[] str = ids.Split(','); double bbjhj = 0; double blxhj = 0; U_ZCBU zc1 = new U_ZCBU(); for (int i = 0; i < str.Length; i++) { DataSet ds = zc1.GetDetailByID(str[i]); if (ds.Tables[0].Rows[0]["bj"] != null && ds.Tables[0].Rows[0]["bj"].ToString() != "") { string m = ds.Tables[0].Rows[0]["bj"].ToString(); bbjhj = bbjhj + Convert.ToDouble(m.Trim()); } if (ds.Tables[0].Rows[0]["bxhj"] != null && ds.Tables[0].Rows[0]["bxhj"].ToString() != "") { string n = ds.Tables[0].Rows[0]["bxhj"].ToString(); blxhj = blxhj + Convert.ToDouble(n.Trim()); } ds.Dispose(); } Hashtable ht = new Hashtable(); ht["bbjhj"] = bbjhj.ToString(); ht["blxhj"] = blxhj.ToString(); return(ht); }
//设置资产责任人 protected void Button1_Click(object sender, EventArgs e) { if (this.zeren.SelectedValue == "") { Util.alert(this.Page, "错误提示:请选择一个责任人!"); } else { U_ZCBU zc1 = new U_ZCBU(); String kind = "0"; if (String.IsNullOrEmpty(Request.QueryString["renkind"]) == false) { kind = Request.QueryString["renkind"]; } bool check1 = zc1.SetZeren(Request["id"], this.zeren.SelectedValue, kind); zc1.Close(); string info = null; if (check1) { info = "提示:成功地将资产的责任人设置为【" + this.zeren.SelectedValue + "】!"; } else { info = "提示:设置资产责任人操作失败!"; } string url = Application["root"] + "/ZcMng1/ZiChangFengPei.aspx"; if (Request["ReturnUrl"] != null && Request["ReturnUrl"] != "") { url = Request["ReturnUrl"]; } Comm.ShowInfo(info, url); } }
private void SetPageData() { if (Request["tcid"] != null) { U_ZCTimeBU time1 = new U_ZCTimeBU(); Hashtable ht = time1.GetTimeDataByID(Request["tcid"]); time1.Close(); if (ht.Count > 0) { foreach (string item in arr1) { Util.SetControlValue(this.timename.Parent.FindControl(item), ht[item]); } } if (this.time0.Text != "" && this.time0.Text != null) { this.time0.Text = DateTime.Parse(this.time0.Text).ToString("yyyy-M-d"); } string sName = ""; string zcid = ht["zcid"].ToString(); U_ZCBU zc1 = new U_ZCBU(); DataSet ds2 = zc1.GetDetailByID(zcid); if (ds2.Tables[0].Rows.Count > 0) { sName = ds2.Tables[0].Rows[0]["danwei"].ToString(); } zc1.Close(); this.hidCorp.Value = sName; this.HiddenField1.Value = ht["zcid"].ToString(); } }
private void BindData() { if (Request["zcid"] != null) { string id = Request["zcid"]; U_ZCBU zc1 = new U_ZCBU(); string fs = "danwei,depart,zeren,bj,lx,pbj,plx,fee1,fee2,fee3,fee4,fee5,fee6,fee7,fee8,fee9,fee10,fee11,fee12,bjye,lxye,hbxh,bxhjye,fyhj"; DataSet ds = zc1.GetDetailByID(id, "danwei,depart,zeren,bj,pbj,plx,fee1,fee2,fee3,fee4,fee5,fee6,fee7,fee8,fee9,fee10,fee11,fee12,isnull(bj,0)-isnull(pbj,0) as bjye ,isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0)-plx as lxye,isnull(pbj,0)+isnull(plx,0) as hbxh,isnull(bj,0)+isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0)-isnull(pbj,0)-isnull(plx,0) as bxhjye,isnull(fee1,0)+isnull(fee2,0)+isnull(fee3,0)+isnull(fee4,0)+isnull(fee5,0)+isnull(fee6,0)+isnull(fee7,0)+isnull(fee8,0)+isnull(fee9,0)+isnull(fee10,0)+isnull(fee11,0)+isnull(fee12,0)+isnull(fee13,0)+isnull(fee14,0)+isnull(fee15,0)+isnull(fee16,0)+isnull(fee17,0)+isnull(fee18,0)+isnull(fee19,0)+isnull(fee20,0) as fyhj,isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) as lx"); zc1.Close(); string[] AF = fs.Split(','); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < AF.Length; i++) { Util.SetControlValue(this.pbj.Parent.FindControl(AF[i]), ds.Tables[0].Rows[0][AF[i]]); } } //设置数字金额的显示 string[] num1 = new string[] { "pbj", "plx", "fee1", "fee2", "fee3", "fee4", "fee5", "fee6", "fee7", "fee8", "fee9", "fee10", "fee11", "fee12", "bjye", "lxye", "hbxh", "bxhjye", "fyhj" }; for (int i = 0; i < num1.Length; i++) { Label l1 = this.pbj.Parent.FindControl(num1[i]) as Label; if (l1 != null) { l1.Text = Comm.GetNumberFormat(l1.Text); } } ds.Dispose(); } }
//更新资产担保资料 protected void SaveDataClick(object sender, EventArgs e) { Hashtable ht = new Hashtable(); foreach (string item in arr1) { ht[item] = Util.GetControlValue(this.bzyx.Parent.FindControl(item)); } try { U_ZCBU zc1 = new U_ZCBU(); ht["id"] = Request["id"]; ht.Remove("zeren"); ht.Remove("danwei"); ht.Remove("depart"); zc1.UpDateZCDBInfo(Request["id"], ht); zc1.Close(); Util.alert(this.Page, "操作提示:更新资料成功!"); } catch (Exception err1) { Util.alert(this.Page, "错误提示:更新资产数据失败,可能的原因是数据类型有错误,请检查重新输入!"); } }
private void BindDZYW() { if (Request["zcid"] != null) { string zcid = Request["zcid"].ToString(); U_ZCBU zc2 = new U_ZCBU(); for (int i = 1; i < 3; i++) { Repeater repeater1 = this.repeater1.Parent.FindControl("repeater" + i) as Repeater; if (repeater1 != null) { int wpkind = i - 1; DataSet ds = zc2.GetDZYWInfo(zcid, wpkind.ToString()); repeater1.DataSource = ds; repeater1.DataBind(); if (ds.Tables[0].Rows.Count == 0) { repeater1.Visible = false; } } } zc2.Close(); } }
private void BindData(U_ZCFilesBU file1) { bool flag = false; if (file1 == null) { file1 = new U_ZCFilesBU(); flag = true; } DataSet ds1 = file1.GetAttachListByZCID(Request["id"].ToString()); this.Repeater1.DataSource = ds1; this.Repeater1.DataBind(); string id = Request["id"]; U_ZCBU zc1 = new U_ZCBU(); DataSet ds = zc1.GetDetailByID(id, "depart,zeren,danwei"); zc1.Close(); if (ds.Tables[0].Rows.Count > 0) { this.danwei.Text = ds.Tables[0].Rows[0]["danwei"].ToString(); this.depart.Text = ds.Tables[0].Rows[0]["depart"].ToString(); this.zeren.Text = ds.Tables[0].Rows[0]["zeren"].ToString(); } if (flag) { file1.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Context.Items["id"] != null) { U_ZCBU zc1 = new U_ZCBU(); DataSet ds1 = zc1.GetCZFSInfoByID(Context.Items["id"].ToString()); zc1.Close(); ViewState["id"] = Context.Items["id"]; Util.SetControlValue(czfs, ds1.Tables[0].Rows[0]["czfs"]); Util.SetControlValue(czjg, ds1.Tables[0].Rows[0]["czjg"]); Util.SetControlValue(czss, ds1.Tables[0].Rows[0]["czss"]); Util.SetControlValue(qcl, ds1.Tables[0].Rows[0]["qcl"]); Util.SetControlValue(yjfy, ds1.Tables[0].Rows[0]["yjfy"]); } if (Context.Items["zcid"] != null) { ViewState["zcid"] = Context.Items["zcid"]; } if (Context.Items["czid"] != null) { ViewState["czid"] = Context.Items["czid"]; } } }
private void BindList() { string id = Request.QueryString["id"]; U_ZCBU zc1 = new U_ZCBU(); DataSet ds = zc1.GetDetailByID(id, "danwei,depart,zeren"); this.danwei.Text = ds.Tables[0].Rows[0]["danwei"].ToString(); this.depart.Text = ds.Tables[0].Rows[0]["depart"].ToString(); this.zeren.Text = ds.Tables[0].Rows[0]["zeren"].ToString(); zc1.Close(); CW_StockBillBU stock1 = new CW_StockBillBU(); this.Repeater1.DataSource = stock1.GetStockListByZcID1(id); this.Repeater1.DataBind(); stock1.Close(); //////////////////////////////////////// CW_ShouKuanBU shoukuan1 = new CW_ShouKuanBU(); List <SearchField> list1 = new List <SearchField>(); list1.Add(new SearchField("zcid", Request.QueryString["id"], SearchFieldType.数值型)); this.Repeater2.DataSource = shoukuan1.GetBillList("2", list1, true); this.Repeater2.DataBind(); //////////////////////////////////////////////////////////// list1.Clear(); list1.Add(new SearchField("zcid", Request.QueryString["id"], SearchFieldType.数值型)); this.Repeater3.DataSource = shoukuan1.GetBillList("3", list1, true); this.Repeater3.DataBind(); shoukuan1.Close(); }
//Bind data private void BindData(string danwei) { U_ZCBU zc1 = new U_ZCBU(); DataSet ds1 = zc1.GetMyZc11(User.Identity.Name, danwei); string zcid = ""; if (ds1.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { if (i == 0) { zcid = ds1.Tables[0].Rows[i]["id"].ToString(); } else { zcid = zcid + "," + ds1.Tables[0].Rows[i]["id"].ToString(); } } } Session["Myzcid"] = zcid; this.GridView1.DataSource = ds1; this.GridView1.DataBind(); zc1.Close(); ds1.Dispose(); }
protected void SaveDataClick(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht["xmbj"] = this.xmbj.Text; ht["zclx"] = this.zclx.Text; ht["zcse"] = this.zcse.Text; ht["fsxzly"] = this.fsxzly.Text; ht["djyj"] = this.djyj.Text; U_ZCBU zc3 = new U_ZCBU(); if (this.zcczid.Text != "") { zc3.UpdateZcBCzsbbByCZID(this.zcczid.Text, ht); } else { if (Request["id"] != null) { ht["zcid"] = Request["id"].ToString(); } ht["status"] = "04"; zc3.InsertZcBsbb(ht); } zc3.Close(); Response.Redirect(Request.RawUrl, true); }
//处理资产处置 protected void Repeater6_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.Item.FindControl("zccz") != null) { string id = ((Label)e.Item.FindControl("zccz")).Text; //删除资产处置方式 if (e.CommandName == "delete") { U_ZCBU zc3 = new U_ZCBU(); zc3.DelZCFS(id); this.BindZCCZDetail(zc3); zc3.Close(); } else { Context.Items["id"] = id; if (Request["id"] != null) { Context.Items["zcid"] = Request["id"].ToString(); } // Context.Items["czid"] = this.zcczid.Text; Server.Transfer("EditZcCzfs.aspx", false); } } }
void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e) { ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch; if (search1 != null) { List <SearchField> list1 = search1.SearchConditon; list1.Add(new SearchField(String.Format("(zeren1='{0}' or zeren2='{0}')", User.Identity.Name), "", SearchOperator.用户定义)); U_ZCBU Zc1 = new U_ZCBU(); DataSet ds1 = Zc1.GetMyZcInfo(list1); string zcid = ""; if (ds1.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { if (i == 0) { zcid = ds1.Tables[0].Rows[i]["id"].ToString(); } else { zcid = zcid + "," + ds1.Tables[0].Rows[i]["id"].ToString(); } } } Session["Myzcid"] = zcid; this.GridView1.DataSource = ds1; this.GridView1.DataBind(); ds1.Dispose(); Zc1.Close(); } }
private void BindDate() { List <SearchField> list1 = new List <SearchField>(); string idlist = Session["zcid"].ToString(); string[] arr = idlist.Split(','); string temp = ""; for (int i = 0; i < arr.Length; i++) { if (i == 0) { temp = " id =" + arr[i]; } else { temp = temp + " or id =" + arr[i]; } } if (temp != "") { list1.Add(new SearchField("", temp, SearchOperator.用户定义)); } U_ZCBU zc1 = new U_ZCBU(); DataSet ds = zc1.GetSearchResultByID1("*,isnull(pbj,0)+isnull(plx,0) as hbxh,isnull(bj,0)+isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0)-isnull(pbj,0)-isnull(plx,0) as bxhjye", list1); zc1.Close(); this.GridView1.DataSource = ds; this.GridView1.DataBind(); ds.Dispose(); }
protected void SaveDataClick(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht["zcid"] = ViewState["zcid"].ToString(); ht["wpkind"] = ViewState["wpkind"].ToString(); ht["wplb"] = this.wplb.SelectedValue; ht["wpsl"] = this.wpsl.Text; ht["wpdw"] = this.wpdw.Text; if (this.wpjz.Text != "") { ht["wpjz"] = this.wpjz.Text; } U_ZCBU zc2 = new U_ZCBU(); if (ViewState["id"] == null) { zc2.InsertDZYW(ht); } else { zc2.UpdateDZYWInfo(ViewState["id"].ToString(), ht); } zc2.Close(); Response.Redirect("ZcDetail9.aspx?id=" + ViewState["zcid"].ToString(), true); }
private void BindData() { if (Request["zcid"] != null) { string zcid = Request["zcid"].ToString(); U_ZCBU zc1 = new U_ZCBU(); DataSet ds = zc1.GetZCDBInfoByID(zcid); zc1.Close(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < arr1.Length; i++) { Util.SetControlValue(this.bzyx.Parent.FindControl(arr1[i]), ds.Tables[0].Rows[0][arr1[i]]); } if (ds.Tables[0].Rows[0]["hssj"] != DBNull.Value) { string dt = DateTime.Parse(ds.Tables[0].Rows[0]["hssj"].ToString()).ToString("yyyy-MM-dd"); Util.SetControlValue(this.bzyx.Parent.FindControl("hssj"), dt); } } string[] num1 = new string[] { "zwrhsgz", "bzrhsgz", "qthsgz", "bzje", "klazfy", "dyhsgz1", "dyhsgz2" }; for (int i = 0; i < num1.Length; i++) { Label l1 = this.zwrhsgz.Parent.FindControl(num1[i]) as Label; if (l1 != null) { l1.Text = Comm.GetNumberFormat(l1.Text); } } ds.Dispose(); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.Item.FindControl("dzyw") != null) { string id = ((Label)e.Item.FindControl("dzyw")).Text; if (e.CommandName == "delete") { try { U_ZCBU zc3 = new U_ZCBU(); zc3.DelDZYWInfo(id); this.BindDZYW(); zc3.Close(); } catch (Exception err1) { Util.alert(this.Page, err1.Message); } } else { Context.Items["id"] = id; if (Request["id"] != null) { Context.Items["zcid"] = Request["id"].ToString(); } Context.Items["wpkind"] = e.CommandArgument.ToString(); Server.Transfer("EditZcDB.aspx", false); } } }
protected void SaveDataClick(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht["zcid"] = ViewState["zcid"].ToString(); ht["czid"] = ViewState["czid"].ToString(); ht["czfs"] = this.czfs.Text; if (this.czjg.Text != "") { ht["czjg"] = this.czjg.Text; } if (this.czss.Text != "") { ht["czss"] = this.czss.Text; } if (this.qcl.Text != "") { ht["qcl"] = this.qcl.Text; } if (this.yjfy.Text != "") { ht["yjfy"] = this.yjfy.Text; } U_ZCBU zc2 = new U_ZCBU(); zc2.InsertCZFS(ht); zc2.Close(); Response.Redirect("ZcDetail3.aspx?id=" + ViewState["zcid"].ToString(), true); }
//显示资产数据 private void BindData(string danwei) { int totalRow = 0; int curpage = 1; if (ViewState["curpage"] != null) { curpage = (int)ViewState["curpage"]; } U_ZCBU Zc1 = new U_ZCBU(); List <SearchField> list1 = new List <SearchField>(); if (danwei != null) { list1.Add(new SearchField("danwei", danwei, SearchOperator.包含)); } list1.Add(new SearchField("zeren", User.Identity.Name, SearchOperator.等于)); DataSet ds1 = Zc1.GetZcUserkingList(list1, curpage, -1, out totalRow); this.GridView1.DataSource = ds1; this.GridView1.DataBind(); ds1.Dispose(); Zc1.Close(); this.PageNavigator1.TotalRows = totalRow; this.PageNavigator1.CurrentPage = curpage; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request.QueryString["kind"] != null && Request.QueryString["kind"] == "31") { U_ZCBU zc1 = new U_ZCBU(); zc1.SetUserKind(Request.QueryString["id"], "31", ""); zc1.Close(); PubComm.ShowInfo("提示:清除用户自定义分类操作成功!", Application["root"] + "/ZcMng1/FixZcUserKind.aspx"); } else if (Request.QueryString["kind"] != null && Request.QueryString["kind"] == "32") { U_ZCBU zc1 = new U_ZCBU(); zc1.SetUserKind(Request.QueryString["id"], "32", ""); zc1.Close(); PubComm.ShowInfo("提示:清除用户自定义分类操作成功!", Application["root"] + "/ZcMng1/MyFixZcUserKind.aspx"); } else { U_ItemBU item = new U_ItemBU(); item.Setuserkind(this.userkind); item.Close(); if (this.userkind.Items.Count > 0) { this.userkind.SelectedIndex = 0; } } } }
//保存资产处置 protected void SaveDataClick(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht["xmbj"] = this.xmbj.Text; ht["zclx"] = this.zclx.Text; ht["zcse"] = this.zcse.Text; // ht["fsxzly"] = this.fsxzly.Text; // ht["djyj"] = this.djyj.Text; U_ZCBU zc3 = new U_ZCBU(); /* * //if (this.zcczid.Text != "") * //{ * //zc3.UpdateZcCzsbbByCZID(this.zcczid.Text, ht); * //} * else * { * if (Request["id"] != null) * { * ht["zcid"] = Request["id"].ToString(); * } * ht["status"] = "04"; * zc3.InsertZcsbb(ht); * } * zc3.Close(); * * Response.Redirect(Request.RawUrl, true); */ }
//绑定资产处置数据 private void BindData2(U_ZCBU zc1, string czid) { DataSet ds1 = zc1.GetCZFSByCZID(czid); this.repeater1.DataSource = ds1; this.repeater1.DataBind(); ds1.Dispose(); }
//将信息复制到所有的资产 public bool CopyZcTctoZc(string bid, string id, string wz) { this.tabCommand.TableConnect.BeginTrans(); try { this.tabCommand.TabName = "U_ZCBAOInfo"; List <SearchField> list1 = new List <SearchField>(); list1.Add(new SearchField("bid", bid, SearchFieldType.数值型)); DataSet ds = this.tabCommand.SearchData("*", list1); string ids = ""; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (i == 0) { ids = ds.Tables[0].Rows[i]["zcid"].ToString(); } else { ids = ids + "," + ds.Tables[0].Rows[i]["zcid"].ToString(); } } } this.tabCommand.TabName = TabName; List <SearchField> list2 = new List <SearchField>(); list2.Add(new SearchField("id", id, SearchFieldType.数值型)); Hashtable ht = this.tabCommand.SearchData(list2); ht.Remove("id"); if (ids != "") { string[] str = ids.Split(','); for (int i = 0; i < str.Length; i++) { U_ZCBU zc1 = new U_ZCBU(); ht["zeren"] = zc1.GetZerenByZCID(str[i]); ht["zcid"] = str[i]; ht["bkind"] = "0"; this.tabCommand.InsertData(ht); } } U_ZCBAOBU zcb1 = new U_ZCBAOBU(); zcb1.UpdateZcstatus(bid, ht["kind"].ToString(), wz); zcb1.Close(); this.tabCommand.TableConnect.CommitTrans(); return(true); } catch (Exception err1) { this.tabCommand.TableConnect.RollBackTrans(); return(false); } }
//BindData private void BindData(string danwei) { U_ZCBU zc1 = new U_ZCBU(); DataSet ds = zc1.GetNoZerenZc(danwei); zc1.Close(); this.GridView1.DataSource = ds; this.GridView1.DataBind(); }