/// <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); // } //} }
/// <summary> /// 执行查询语句 /// </summary> /// <param name="sql"></param> /// <returns></returns> public DataTable ExecuteStrSQL(string sql) { return(sqlEXDAL_Base.ExecuteStrSQL(sql)); }