public string GetBanks()
{
var sql = "select Id as ID,[Name] as TypeName from [Bank]";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetMainBankCmb()
{
var sql = string.Format(" select Id as ID,BankName as TypeName from CooperativeBank order by Sort asc ");
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetSysDeparementCmb(string RoleID)
{
var sql = "select ID,DepartmentName as TypeName from SysDepartment where RoleID = '" + RoleID + "'";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetReceivers()
{
var sql = "select ID,DepartmentName as TypeName from SysDepartment where RoleID=2";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetSysRolesCmb()
{
var sql = "select ID as ID,RolesDec as TypeName from SysRoles where ID != 1";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetMainBank()
{
var sql = "select Id as ID,BankName as TypeName from MainBank";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string LookUp(string key)
{
var sql = string.Format("select Id as ID,[Desc] as TypeName from [Lookup] where [Name]=N'{0}'", key);
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetUserTypeCmb()
{
var sql = "select ID,TypeName from LookUp where TypeCls = 'UsersType'";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}
public string GetMastBanks(string mainbankid)
{
string sqlPbank = "select BankName from MainBank where Id='" + mainbankid + "'";
var pbankdt = DBHelper.GetDataSet(sqlPbank);
if (pbankdt.Rows.Count > 0)
{
var pbankdr = pbankdt.Rows[0];
mainbankid = pbankdr[0].ToString();
}
if (mainbankid != "中国银行")
{
mainbankid = mainbankid.Replace("中国", "");
}
var sql = "select Id as ID,[Name] as TypeName from [Bank] where 1=1 and iszzd = 0 and Name Like '%" + mainbankid + "%'";
var dt = DBHelper.GetDataSet(sql);
return(JsonHelper.ConvertJosnData(dt));
}