//绑定客户
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);
// }
//}
}
