//查询用户信息
public bool QueryUser(Model.User user)
{
string SQL = "select * from news_user where id ='" + user.id + "'";
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
user.id = ds.Tables[0].Rows[0][0].ToString();
user.username = ds.Tables[0].Rows[0][1].ToString();
user.password = ds.Tables[0].Rows[0][2].ToString();
user.email = ds.Tables[0].Rows[0][3].ToString();
user.realname = ds.Tables[0].Rows[0][4].ToString();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 查询全部
/// </summary>
public static List <Results> AllData(string WhereSrc, string PXzd, string PXType)
{
List <Results> list = new List <Results>();
string sql = "select * from Results where 1=1";
if (!string.IsNullOrEmpty(WhereSrc))
{
sql += string.Format(WhereSrc + " order by {0} {1}", PXzd, PXType);
}
else
{
sql += string.Format(" order by {0} {1}", PXzd, PXType);
}
using (DataTable table = DBHelper.GetDataSet(sql))
{
list = GetList(table);
}
return(list);
}
//查询新闻
public bool QueryNews(Model.News news)
{
string SQL = "select * from news where id='" + news.id + "'";
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
news.category = ds.Tables[0].Rows[0][1].ToString();
news.title = ds.Tables[0].Rows[0][2].ToString();
news.author = ds.Tables[0].Rows[0][3].ToString();
news.contents = ds.Tables[0].Rows[0][4].ToString();
news.createTime = ds.Tables[0].Rows[0][5].ToString();
news.click = ds.Tables[0].Rows[0][6].ToString();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取当前编码最大值
/// </summary>
/// <returns></returns>
public long GetMaxMaterielID()
{
string d1 = DateTime.Now.ToString("yyyyMMdd");
string sqlstr = "select ID from Materiel where ID LIKE '" + d1 + "%'";
DataTable dt = DBHelper.GetDataSet(sqlstr).Tables[0];
if (dt.Rows.Count > 0)
{
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
list.Add(long.Parse(row[0].ToString()));
}
list.Sort();
return(long.Parse(list[list.Count - 1].ToString()));
}
return(0);
}
/// <summary>
/// 根据风格查询歌手信息
/// </summary>
/// <param name="style"></param>
/// <returns></returns>
public static List <Singer> SelectSingerByStyle(string style)
{
List <Singer> list = new List <Singer>();
string sql = "select * from Music where style in('" + style + "') ";
DataSet ds = DBHelper.GetDataSet(sql, CommandType.Text);
foreach (DataRow row in ds.Tables[0].Rows)
{
Singer s = new Singer();
s.Id = Convert.ToInt32(row["Id"]);
s.Name = row["Name"].ToString();
s.EName = row["EName"].ToString();
s.Style = row["Style"].ToString();
s.Nationality = row["Nationality"].ToString();
s.RepresentativeWorks = row["RepresentativeWorks"].ToString();
s.Profile = row["Profile"].ToString();
list.Add(s);
}
return(list);
}
/// <summary>
/// 根据分组查询联系人
/// </summary>
/// <param name="uid"></param>
/// <param name="id"></param>
/// <returns></returns>
public static List <Friend> SelectFriendByGroup(string uid, string id)
{
List <Friend> list = new List <Friend>();
string table = "Friend_" + uid;
string sql = "select * from " + table + " where F_Group='" + id + "'";
DataSet ds = DBHelper.GetDataSet(sql, CommandType.Text);
foreach (DataRow row in ds.Tables[0].Rows)
{
Friend f = new Friend();
f.F_Id = Convert.ToInt32(row["F_Id"]);
f.F_User = row["F_User"].ToString();
f.F_Mail = row["F_Mail"].ToString();
f.F_Fname = row["F_Fname"].ToString();
f.F_Phone = row["F_Phone"].ToString();
f.F_Group = GroupService.SelectGroupById(uid, Convert.ToInt32(row["F_Group"]));
list.Add(f);
}
return(list);
}
/// <summary>
/// 查询全部
/// </summary>
public static List <Room> AllData(string NewWHere)
{
List <Room> list = new List <Room>();
string sql = "";
if (!string.IsNullOrEmpty(NewWHere))
{
sql = "select * from Room where 1=1 " + NewWHere;
}
else
{
sql = "select * from Room";
}
using (DataTable table = DBHelper.GetDataSet(sql))
{
list = GetList(table);
}
return(list);
}
/// <summary>
/// 获取全部文章信息（编号[从大到小]）
/// </summary>
/// <returns></returns>
public static List <Article> GetArticleAllByDesc()
{
List <Article> list = new List <Article>();
DataSet ds = DBHelper.GetDataSet("Select_ArticleAllByDesc", CommandType.StoredProcedure);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Article article = new Article()
{
A_Author = dr["A_Author"].ToString(),
A_Content = dr["A_Content"].ToString(),
A_DateTime = dr["A_DateTime"].ToString(),
A_No = Convert.ToInt32(dr["A_No"]),
A_Title = dr["A_Title"].ToString(),
A_TypeName = dr["A_TypeName"].ToString(),
A_CoverImageUrl = dr["A_CoverImageUrl"].ToString()
};
list.Add(article);
}
return(list);
}
//查询投稿
public bool QueryContribute(Model.Contribute contribute)
{
string SQL = "select * from contribute where id='" + contribute.id + "'";
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
contribute.username = ds.Tables[0].Rows[0][1].ToString();
contribute.category = ds.Tables[0].Rows[0][2].ToString();
contribute.title = ds.Tables[0].Rows[0][3].ToString();
contribute.author = ds.Tables[0].Rows[0][4].ToString();
contribute.contents = ds.Tables[0].Rows[0][5].ToString();
contribute.createTime = ds.Tables[0].Rows[0][6].ToString();
return(true);
}
else
{
return(false);
}
}
private static List <T_BaseInfo> GetT_BaseInfosBySql(string sql, params SqlParameter[] values)
{
List <T_BaseInfo> list = new List <T_BaseInfo>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_BaseInfo t_BaseInfo = new T_BaseInfo();
try{
t_BaseInfo.Id = (int)row["Id"];
}catch
{}
try{
t_BaseInfo.Config_name = (string)row["config_name"];
}catch
{}
try{
t_BaseInfo.Config_value = (string)row["config_value"];
}catch
{}
try{
t_BaseInfo.Config_status = (bool)row["config_status"];
}catch
{}
list.Add(t_BaseInfo);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 查询某一用户所有邮件（分页查询）
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="user"></param>
/// <returns></returns>
public static List <Email> GetEmailByUser(int pageIndex, string user)
{
//当前页第一条记录对应的行号
int start = (pageIndex - 1) * 16 + 1;
//当前页最后一条记录对应的行号
int end = start + 15;
List <Email> list = new List <Email>();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@start", start),
new SqlParameter("@end", end),
new SqlParameter("@user", user)
};
DataSet ds = DBHelper.GetDataSet("P_Email_SelectEmailByUser", CommandType.StoredProcedure, para);
foreach (DataRow row in ds.Tables[0].Rows)
{
Email e = new Email();
e.E_Id = Convert.ToInt32(row["E_Id"]);
e.E_Title = row["E_Title"].ToString();
e.E_Time = Convert.ToDateTime(row["E_Time"]);
e.E_SendMan = row["E_SendMan"].ToString();
e.E_ReceiveMan = row["E_ReceiveMan"].ToString();
e.E_Content = row["E_Content"].ToString();
e.E_Litter = row["E_Litter"].ToString();
e.E_Read = row["E_Read"].ToString();
e.E_Delete = row["E_Delete"].ToString();
e.E_Report = row["E_Report"].ToString();
list.Add(e);
}
return(list);
}
catch (Exception)
{
return(null);
}
}
private static List <T_District> GetT_DistrictsBySql(string sql, params SqlParameter[] values)
{
List <T_District> list = new List <T_District>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_District t_District = new T_District();
try{
t_District.Id = (int)row["Id"];
}catch
{}
try{
t_District.District_name = (string)row["district_name"];
}catch
{}
try{
t_District.District_level = (int)row["district_level"];
}catch
{}
try{
t_District.Parent_district = (int)row["parent_district"];
}catch
{}
list.Add(t_District);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private static List <T_Department> GetT_DepartmentsBySql(string sql, params SqlParameter[] values)
{
List <T_Department> list = new List <T_Department>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_Department t_Department = new T_Department();
try{
t_Department.Id = (int)row["Id"];
}catch
{}
try{
t_Department.Depart_name = (string)row["depart_name"];
}catch
{}
try{
t_Department.Depart_addr = (string)row["depart_addr"];
}catch
{}
try{
t_Department.Depart_status = (bool)row["depart_status"];
}catch
{}
list.Add(t_Department);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 获取所有投诉邮件
/// </summary>
/// <returns></returns>
public static List <Email> GetAllReportEmail()
{
List <Email> list = new List <Email>();
string sql = "select * from Email where E_Report='是'";
DataSet ds = DBHelper.GetDataSet(sql, CommandType.Text);
foreach (DataRow row in ds.Tables[0].Rows)
{
Email e = new Email();
e.E_Id = Convert.ToInt32(row["E_Id"]);
e.E_Title = row["E_Title"].ToString();
e.E_Time = Convert.ToDateTime(row["E_Time"]);
e.E_SendMan = row["E_SendMan"].ToString();
e.E_ReceiveMan = row["E_ReceiveMan"].ToString();
e.E_Content = row["E_Content"].ToString();
e.E_Litter = row["E_Litter"].ToString();
e.E_Read = row["E_Read"].ToString();
e.E_Delete = row["E_Delete"].ToString();
e.E_Report = row["E_Report"].ToString();
list.Add(e);
}
return(list);
}
/// <summary>
/// 获取联机任务列表
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public DataTable getList(int type)
{
string sql = @"select a.Dec_ID,a.C_DH,case I_INOUT when 10 then '零件出库' when 20 then '零件入库'
when 12 then '刀具使用出库' when 21 then '新刀具入库' when 22 then '刀具使用入库' else '' end as c_inout,
a.C_MATERIEL,b.C_NAME as C_MATERIEL_NAME,a.DEC_COUNT,a.C_CZY,a.C_PLACE
from T_Runing_Dolist a left join T_JB_MATERIEL b on a.C_MATERIEL = b.c_id where I_RUN = 0";
DataTable dt = new DataTable();
try
{
sql += " order by a.Dec_ID ";
dt = dbHelper.GetDataSet(sql);
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
return(dt);
}
/// <summary>
/// 查询用户所有已发送邮件数量与页数
/// </summary>
/// <param name="user"></param>
/// <param name="count"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public static string SelectAllSendEmailCountAndPageCountByUser(string user, out int count, out int pageCount)
{
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@user", user),
new SqlParameter("@count", SqlDbType.Int),
new SqlParameter("@pageCount", SqlDbType.Int) //输出参数一定要指定在DB中的数据类型
};
para[1].Direction = ParameterDirection.Output; //指定参数为输出参数
para[2].Direction = ParameterDirection.Output;
DataSet ds = DBHelper.GetDataSet("SelectSendEmailCountAndPageCount", CommandType.StoredProcedure, para);
count = Convert.ToInt32(para[1].Value);
pageCount = Convert.ToInt32(para[2].Value);
return("/");
}
catch (Exception)
{
pageCount = 0;
count = 0;
return("/");
}
}
private static List <T_Role> GetT_RolesBySql(string sql, params SqlParameter[] values)
{
List <T_Role> list = new List <T_Role>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_Role t_Role = new T_Role();
try{
t_Role.Id = (int)row["Id"];
}catch
{}
try{
t_Role.Role_name = (string)row["role_name"];
}catch
{}
try{
t_Role.Role_pris = (bool)row["role_pris"];
}catch
{}
list.Add(t_Role);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 根据歌单编号查询音乐信息
/// </summary>
/// <param name="playListId"></param>
/// <returns></returns>
public static List <Music> SelectPlaylistMusicById(int playListId)
{
List <Music> list = new List <Music>();
string sql = "select * from Music where playListId ='" + playListId + "'";
DataSet ds = DBHelper.GetDataSet(sql, CommandType.Text);
foreach (DataRow row in ds.Tables[0].Rows)
{
Music m = new Music();
m.Id = Convert.ToInt32(row["Id"]);
m.Title = row["Title"].ToString();
m.Singer = row["Singer"].ToString();
m.WriteSong = row["WriteSong"].ToString();
m.Value = row["Value"].ToString();
m.Lyric = row["Lyric"].ToString();
m.AlbumsId = Convert.ToInt32(row["AlbumsId"]);
m.Style = row["Style"].ToString();
m.ReleaseTime = Convert.ToDateTime(row["ReleaseTime"]);
m.Language = row["Language"].ToString();
m.Click = Convert.ToInt32(row["Click"]);
list.Add(m);
}
return(list);
}
private static List <T_RoleMenuRelation> GetT_RoleMenuRelationsBySql(string sql, params SqlParameter[] values)
{
List <T_RoleMenuRelation> list = new List <T_RoleMenuRelation>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_RoleMenuRelation t_RoleMenuRelation = new T_RoleMenuRelation();
try{
t_RoleMenuRelation.Id = (int)row["Id"];
}catch
{}
try{
t_RoleMenuRelation.Role_id = (int)row["role_id"];
}catch
{}
try{
t_RoleMenuRelation.Menu_id = (int)row["menu_id"];
}catch
{}
list.Add(t_RoleMenuRelation);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private static List <T_Checkup> GetT_CheckupsBySql(string sql, params SqlParameter[] values)
{
List <T_Checkup> list = new List <T_Checkup>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_Checkup t_Checkup = new T_Checkup();
try{
t_Checkup.Id = (int)row["Id"];
}catch
{}
try{
t_Checkup.Investigate_id = (int)row["investigate_id"];
}catch
{}
try{
t_Checkup.Off_grades = (string)row["off_grades"];
}catch
{}
try{
t_Checkup.Rank_scores = (string)row["rank_scores"];
}catch
{}
try{
t_Checkup.Anti_seismics = (string)row["anti_seismics"];
}catch
{}
try{
t_Checkup.Repairables = (string)row["repairables"];
}catch
{}
try{
t_Checkup.Checkup_suggestions = (string)row["checkup_suggestions"];
}catch
{}
try{
t_Checkup.Evaluate_suggestions = (string)row["evaluate_suggestions"];
}catch
{}
try{
t_Checkup.Solutions = (string)row["solutions"];
}catch
{}
try{
t_Checkup.Remakes = (string)row["remakes"];
}catch
{}
try{
t_Checkup.Create_user = (string)row["create_user"];
}catch
{}
try{
t_Checkup.Create_time = (DateTime)row["create_time"];
}catch
{}
try{
t_Checkup.Update_user = (string)row["update_user"];
}catch
{}
try{
t_Checkup.Update_time = (DateTime)row["update_time"];
}catch
{}
try{
t_Checkup.Status = (bool)row["status"];
}catch
{}
try{
t_Checkup.Checkup_category = (string)row["checkup_category"];
}catch
{}
list.Add(t_Checkup);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 获得全部物料信息
/// </summary>
/// <returns></returns>
public DataTable getMaterielListForQuerry(string id, string name, string area, string type, int finish, string standerd, string userid)
{
string sql = " select a.C_ID,a.C_NAME,a.C_TYPE,b.C_NAME as C_TYPENAME,a.C_STANDARD,a.C_AREA,c.C_NAME as C_AREANAME," +
" I_FINISH, [C_PICCODE], [I_LAYOUTCOUNT], [C_SURFACE], [C_SCIENCE], [DEC_AREA], [DEC_WEIGHT], " +
" case I_BUY when 1 then '是' else '否' end as I_BUY, [DEC_production]," +
" case I_FINISH when 1 then '是' else '否' end as C_FINISH,I_LENGTH,I_WIDTH,I_THICK,a.C_MEMO " +
" from T_JB_MATERIEL a left join T_JB_MATERIELTYPE b on a.C_TYPE = b.C_ID left join t_jb_placeArea c on a.C_AREA = c.C_ID where a.C_ID in ( " +
" select C_MATERIEL from T_JB_MATERIEL_USER where C_JIAOSE = @JIAOSE ) ";
DataTable dt = new DataTable();
try
{
Hashtable table = new Hashtable();
table.Add("JIAOSE", userid);
if (id != null)
{
sql += " and a.C_ID like @C_ID";
table.Add("C_ID", "%" + id + "%");
}
if (name != null)
{
sql += " and a.C_NAME like @C_NAME";
table.Add("C_NAME", "%" + name + "%");
}
if (area != null)
{
sql += " and a.C_AREA = @C_AREA";
table.Add("C_AREA", area);
}
if (type != null)
{
sql += " and a.C_TYPE = @C_TYPE";
table.Add("C_TYPE", type);
}
if (finish != -1)
{
sql += " and a.I_FINISH = @I_FINISH";
table.Add("I_FINISH", finish);
}
if (standerd != null)
{
sql += " and a.C_STANDARD like @C_STANDARD";
table.Add("C_STANDARD", "%" + standerd + "%");
}
sql += " order by a.C_ID ";
if (table.Count > 0)
{
DbParameter[] parms = dbHelper.getParams(table);
dt = dbHelper.GetDataSet(sql, parms);
}
else
{
dt = dbHelper.GetDataSet(sql);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
return(dt);
}
/// <summary>
/// 根据用户角色获得可以显示的所有功能组名称
/// </summary>
/// <returns>组名称列表</returns>
public List <string> getAllGroupName()
{
List <string> list = new List <string>();
string sql = "select GROUPNAME from OUTLOOK_TABLE_JB_USER where jiaose = @role and yesno = '1' group by GROUPNAME,OB_NAME order by OB_NAME";
try
{
Hashtable table = new Hashtable();
table.Add("@role", Global.longid);
DbParameter[] parms = dbHelper.getParams(table);
DataTable ds = dbHelper.GetDataSet(sql, parms);
for (int i = 0; i < ds.Rows.Count; i++)
{
string temp = ds.Rows[i]["GROUPNAME"].ToString();
list.Add(temp);
}
dbHelper.getConnection().Close();
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
return(list);
}
/// <summary>
/// 分页
///</summary>
public static DataTable PageSelectConsumption2(int pageSize, int pageIndex, string WhereSrc, string PXzd, string PXType)
{
string sql = string.Format("SELECT top {0} * FROM Live INNER JOIN Consumption ON Live.L_Id = Consumption.L_Id where C_Id not in( select top {1} C_Id from Live INNER JOIN Consumption ON Live.L_Id = Consumption.L_Id where 1=1 {2} order by {3} {4}) and 1=1 {2} order by {3} {4} ", pageSize, pageSize * pageIndex, WhereSrc, PXzd, PXType);
return(DBHelper.GetDataSet(sql));
}
private static IList <T_Investigate> GetT_InvestigatesBySql(string sql, params SqlParameter[] values)
{
List <T_Investigate> list = new List <T_Investigate>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_Investigate t_Investigate = new T_Investigate();
try{
t_Investigate.Id = (int)row["id"];
}catch
{}
try{
t_Investigate.Building_id = (string)row["building_id"];
}catch
{}
try{
t_Investigate.Building_name = (string)row["building_name"];
}catch
{}
try{
t_Investigate.Building_owner = (string)row["building_owner"];
}catch
{}
try{
t_Investigate.Building_user = (string)row["building_user"];
}catch
{}
try{
t_Investigate.Start_date = (DateTime)row["start_date"];
}catch
{}
try{
t_Investigate.Finish_date = (DateTime)row["finish_date"];
}catch
{}
try{
t_Investigate.Design_corp = (string)row["design_corp"];
}catch
{}
try{
t_Investigate.Construct_corp = (string)row["construct_corp"];
}catch
{}
try{
t_Investigate.Total_area = (int)row["total_area"];
}catch
{}
try{
t_Investigate.Floors = (int)row["floors"];
}catch
{}
try{
t_Investigate.Struct_type = (string)row["struct_type"];
}catch
{}
try{
t_Investigate.Building_purpose = (string)row["building_purpose"];
}catch
{}
try{
t_Investigate.Contacts = (string)row["contacts"];
}catch
{}
try{
t_Investigate.Contact_numbers = (string)row["contact_numbers"];
}catch
{}
try{
t_Investigate.Problems = (string)row["problems"];
}catch
{}
try{
t_Investigate.Checkup_suggestions = (string)row["checkup_suggestions"];
}catch
{}
try{
t_Investigate.Rectifications = (string)row["rectifications"];
}catch
{}
try{
t_Investigate.Remarks = (string)row["remarks"];
}catch
{}
try{
t_Investigate.Create_user = (string)row["create_user"];
}catch
{}
try{
t_Investigate.Create_datetime = (DateTime)row["create_datetime"];
}catch
{}
try{
t_Investigate.Update_user = (string)row["update_user"];
}catch
{}
try{
t_Investigate.Update_time = (DateTime)row["update_time"];
}catch
{}
try{
t_Investigate.Investigate_category = (string)row["investigate_category"];
}catch
{}
list.Add(t_Investigate);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 获得出入库信息
/// </summary>
/// <returns></returns>
public DataTable getStocksList(string materiel, string materieName, string place, string stand, string userid, string materielId)
{
string sql = @"select * from (
select a.C_MATERIEL_ID,b.C_NAME,c.C_NAME as C_TYPENAME,b.C_STANDARD,a.C_PLACE,a.DEC_COUNT,
a.DEC_COUNT -isnull( d.usecount,0) as canuse, a.PRIID,a.DEC_COUNT -isnull( d.usecount,0) as num
from T_OPERATE_STOCKS a
left join T_JB_MATERIEL b on a.C_MATERIEL_ID = b.C_ID
left join T_JB_MATERIELTYPE c on b.C_TYPE = c.C_ID
left join (select isnull( DEC_COUNT,0) as usecount ,C_MATERIEL,C_PLACE from T_Runing_Dolist where I_INOUT = 1) d on d.C_MATERIEL = a.C_MATERIEL_ID
and d.C_PLACE = a.C_PLACE where b.C_TYPE = '0002'
) g
where g.canuse >0 and g.C_PLACE not in (select C_PLACE from T_Runing_Dolist) ";
DataTable dt = new DataTable();
try
{
Hashtable table = new Hashtable();
table.Add("JIAOSE", userid);
if (materiel != null && !(string.Empty.Equals(materiel)))
{
sql += " and g.C_MATERIEL_ID like @materiel ";
table.Add("materiel", "%" + materiel + "%");
}
if (materielId != null && !(string.Empty.Equals(materielId)))
{
sql += " and g.C_MATERIEL_ID = @materielId ";
table.Add("materielId", materielId);
}
if (materieName != null && !(string.Empty.Equals(materieName)))
{
sql += " and g.C_NAME like @materieName ";
table.Add("materieName", "%" + materieName + "%");
}
if (place != null && !(string.Empty.Equals(place)))
{
sql += " and g.C_PLACE like @place ";
table.Add("place", "%" + place + "%");
}
if (stand != null && !(string.Empty.Equals(stand)))
{
sql += " and g.C_STANDARD like @stand ";
table.Add("stand", "%" + stand + "%");
}
if (table.Count > 0)
{
DbParameter[] parms = dbHelper.getParams(table);
dt = dbHelper.GetDataSet(sql, parms);
}
else
{
dt = dbHelper.GetDataSet(sql);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
return(dt);
}