public void DataBindEx2(int CompanyID) { DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL(); DataSet list1 = bll.GetListEx2(CompanyID, ""); DropDownList1.DataTextField = "gcmc"; DropDownList1.DataValueField = "SingleProjectID"; DropDownList1.DataSource = list1; DropDownList1.DataBind(); }
public void UpdatedhNew(string ArchiveID) { int wzCount_P = 0; int tzCount_P = 0; int zpCount_P = 0; T_Archive_MDL mdl = dal.GetModel(int.Parse(ArchiveID)); DataSet ds = dal.GetList("ShortDH='' AND SingleProjectID=" + mdl.SingleProjectID); if (ds != null && ds.Tables.Count > 0) { DataRow[] drList = ds.Tables[0].Select("", "xh"); int maxShortDH = dal.GetMaxShortDH(); maxShortDH++; BLL.T_FileList_BLL fileBLL = new T_FileList_BLL(); foreach (DataRow dr in drList) { mdl = dal.GetModel(int.Parse(dr["archiveid"].ToString())); mdl.ShortDH = maxShortDH.ToString(); //Leo 案卷sl统计 2012-09-26 int ManualCount = fileBLL.GetManualCountByArchiveID(mdl.ArchiveID); if (mdl.ajlx == "183") { mdl.wzCount = ManualCount; wzCount_P += ManualCount; } if (mdl.ajlx == "184") { mdl.tzCount = ManualCount; tzCount_P += ManualCount; } if (mdl.ajlx == "185") { mdl.zpCount = ManualCount; zpCount_P += ManualCount; } dal.Update(mdl); maxShortDH++; } } //Leo 2012-09-26 if (mdl.SingleProjectID != null) { BLL.T_SingleProject_BLL projBLL = new T_SingleProject_BLL(); Model.T_SingleProject_MDL projMDL = projBLL.GetModel(int.Parse(mdl.SingleProjectID.ToString())); projMDL.wzCount = wzCount_P; projMDL.tzCount = tzCount_P; projMDL.zpCount = zpCount_P; projBLL.Update(projMDL); } }
public void DataBindEx(int CompanyID) { DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL(); //string strwhere = ""; //strwhere = "SingleProjectID in (select SingleProjectID from t_singleprojectuser where roleid=" + Common.Session.GetSession("RoleId") + ")"; DataSet list1 = bll.GetListEx(CompanyID, ""); DropDownList1.DataTextField = "gcmc"; DropDownList1.DataValueField = "SingleProjectID"; DropDownList1.DataSource = list1; DropDownList1.DataBind(); }
public void DataBindEx() { DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL(); string strwhere = ""; if (Common.Session.GetSession("SuperAdmin").ToLower() == "true") { strwhere = " Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'"; } else { strwhere = "SingleProjectID in (select SingleProjectID from t_singleprojectuser where roleid=" + Common.Session.GetSession("RoleId") + ") "; strwhere += "And Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'"; } DataSet list1 = bll.GetList(strwhere); DropDownList1.DataTextField = "gcmc"; DropDownList1.DataValueField = "SingleProjectID"; DropDownList1.DataSource = list1; DropDownList1.DataBind(); }