//绑定客户 public void BindKH() { System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch(); sw.Start(); if (mCompany.RoleType != 1) { SQLEXDAL_Base sqlexdal_base = new SQLEXDAL_Base(); DataTable table = sqlexdal_base.GetGYLowerEmpolyees(mCompany.UninCode); selKH_0.Items.Clear(); selKH_0.Items.Add(new ListItem("---请选择客户名称---", "")); if (table != null && table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { //LoginName:登录账号 UninCode:公司编号 Uid:用户id Cid:用户所在公司id UninAllName:公司全称 ListItem li = new ListItem(dr["LoginName"].ToString() + "-" + dr["UninAllName"].ToString(), dr["UninCode"].ToString() + "@" + dr["LoginName"].ToString() + "@" + dr["UninAllName"].ToString() + "@" + dr["Uid"].ToString() + "@" + dr["Cid"].ToString()); selKH_0.Items.Add(li); } } } sw.Stop(); string strCarry = sw.Elapsed.ToString(); PnrAnalysis.LogText.LogWrite("BindKH:" + strCarry, "HandleTime"); }
//绑定供应和落地运营商 public void BindGY() { if (mCompany.RoleType == 1) { System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch(); sw.Start(); SQLEXDAL_Base sqlexdal_base = new SQLEXDAL_Base(); DataTable table = sqlexdal_base.GetGYEmpolyees(); selGY_0.Items.Clear(); selGY_0.Items.Add(new ListItem("---请选择落地运营商---", "")); if (table != null && table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { if (dr["RoleType"].ToString() == "2") { ListItem li = new ListItem(dr["LoginName"].ToString() + "-" + dr["UninAllName"].ToString(), dr["UninCode"].ToString() + "@" + dr["LoginName"].ToString() + "@" + dr["UninAllName"].ToString() + "@" + dr["Uid"].ToString() + "@" + dr["Cid"].ToString()); selGY_0.Items.Add(li); } } } sw.Stop(); string strCarry = sw.Elapsed.ToString(); PnrAnalysis.LogText.LogWrite("BindKH:" + strCarry, "HandleTime"); } }
/// <summary> /// 绑定城市 /// </summary> //public void BindCity() //{ // if (list == null) // { // list = GetCity("1"); // } // //出发城市 // ddlFromCity.DataSource = list; // ddlFromCity.DataFiledText = "CityCodeWord-CityName"; // ddlFromCity.DataFiledValue = "CityCodeWord"; // ddlFromCity.DataBind(); // //到达城市 // ddlToCity.DataSource = list; // ddlToCity.DataFiledText = "CityCodeWord-CityName"; // ddlToCity.DataFiledValue = "CityCodeWord"; // ddlToCity.DataBind(); //} /// <summary> /// 绑定供应或者落地运营商 /// </summary> public void BindGY() { SQLEXDAL_Base sqlexdal_base = new SQLEXDAL_Base(); DataTable table = sqlexdal_base.GetGYEmpolyees(); ddlGY.Items.Clear(); ddlGY.Items.Add(new ListItem("---供应商或运营商---", "")); if (table != null && table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { ListItem li = new ListItem(dr["LoginName"].ToString() + "-" + dr["UninAllName"].ToString(), dr["UninCode"].ToString() + "@" + dr["LoginName"].ToString() + "@" + dr["UninAllName"].ToString() + "@" + dr["Uid"].ToString() + "@" + dr["Cid"].ToString()); ddlGY.Items.Add(li); } ddlGY.SelectedIndex = 0; } }
/// <summary> /// 获取要修改的信息 /// </summary> protected void GetOnePosInfo() { try { Tb_PosInfo mpos = (baseDataManage.CallMethod("Tb_PosInfo", "GetList", null, new Object[] { "id='" + Guid.Parse(ViewState["Id"].ToString()) + "'" }) as List <Tb_PosInfo>)[0]; SQLEXDAL_Base sqlexdal_base = new SQLEXDAL_Base(); DataTable table = sqlexdal_base.ExecuteStrSQL("select UninAllName,UninCode,RoleType,LoginName from User_Company _cpy inner join User_Employees _user on _cpy.UninCode=_user.CpyNo where _user.IsAdmin=0 and UninCode = '" + mpos.CpyNo + "'"); txtTerminalNo.Text = mpos.PosNo.ToString(); ddltype.SelectedValue = mpos.PosMode.ToString(); ddlGYList.Value = table.Rows[0]["UninCode"].ToString() + "-" + table.Rows[0]["RoleType"].ToString(); txtfeil.Text = mpos.PosRate.ToString(); ddlGYList.Text = table.Rows[0]["LoginName"].ToString() + "-" + table.Rows[0]["UninAllName"].ToString(); } catch (Exception) { throw; } }
/// <summary> /// 绑定证件 /// </summary> protected void Bind() { //绑定pos机类型 List <Bd_Base_Dictionary> list = baseDataManage.CallMethod("Bd_Base_Dictionary", "GetList", null, new Object[] { "ParentID=4 and ChildID in(9,10,11,12,13)" }) as List <Bd_Base_Dictionary>; this.ddltype.DataSource = list; ddltype.DataTextField = "ChildName"; ddltype.DataValueField = "ChildID"; this.ddltype.DataBind(); SQLEXDAL_Base sqlexdal_base = new SQLEXDAL_Base(); DataTable table = sqlexdal_base.ExecuteStrSQL("select UninAllName,UninCode,RoleType,LoginName from User_Company _cpy inner join User_Employees _user on _cpy.UninCode=_user.CpyNo where _user.IsAdmin=0 and len(UninCode) > 12 and UninCode like '" + mCompany.UninCode + "%' order by LoginName"); ddlGYList.DataTableSource = table; ddlGYList.DataFiledText = "LoginName-UninAllName"; ddlGYList.DataFiledValue = "UninCode-RoleType"; ddlGYList.DataBind(); //绑定 //List<User_Company> listcpy = baseDataManage.CallMethod("User_Company", "GetList", null, new Object[] { "len(UninCode) > 12 and UninCode like '" + mCompany.UninCode + "%'" }) as List<User_Company>; //for (int i = 0; i < listcpy.Count; i++) //{ // listcpy[i].UninCode = listcpy[i].UninCode + "^" + listcpy[i].RoleType; //} //ddlcpy.DataSource = listcpy; //ddlcpy.DataTextField = "UninAllName"; //ddlcpy.DataValueField = "UninCode"; //ddlcpy.DataBind(); //hidCustomervalue(listcpy); /////////////////////////////// //SQLEXDAL_Base sqlexdal_base = new SQLEXDAL_Base(); //DataTable table = sqlexdal_base.ExecuteStrSQL("select UninAllName,UninCode,RoleType,LoginName from User_Company _cpy inner join User_Employees _user on _cpy.UninCode=_user.CpyNo where _user.IsAdmin=0 and len(UninCode) > 12 and UninCode like '" + mCompany.UninCode + "%'"); //ddlcpy_0.Items.Clear(); //ddlcpy_0.Items.Add(new ListItem("---请选择用户---", "")); //if (table != null && table.Rows.Count > 0) //{ // foreach (DataRow dr in table.Rows) // { // ListItem li = new ListItem(dr["LoginName"].ToString() + "-" + dr["UninAllName"].ToString(), dr["UninCode"].ToString() + "@" + dr["LoginName"].ToString() + "@" + dr["UninAllName"].ToString()+"@"+dr["RoleType"].ToString()); // ddlcpy_0.Items.Add(li); // } //} }