/// <summary>
/// 获取所有数据
/// </summary>
/// <param name="status"></param>
/// <returns></returns>
public DataTable GetAllData(Entities.QueryWOrderBusiTypeInfo query)
{
string sql = "SELECT [RecID] ,[BusiTypeName] ,[SortNum] ,[Status] FROM WOrderBusiType WHERE status<>'-1'";
if (!string.IsNullOrEmpty(query.RecID))
{
sql += " and RecID=" + SqlFilter(query.RecID);
}
if (!string.IsNullOrEmpty(query.NoRecID))
{
sql += " and RecID<>" + SqlFilter(query.NoRecID);
}
if (!string.IsNullOrEmpty(query.BusiTypeName))
{
sql += " and BusiTypeName='" + SqlFilter(query.BusiTypeName) + "'";
}
if (!string.IsNullOrEmpty(query.Status))
{
sql += " and status in (" + SqlFilter(query.Status) + ")";
}
sql += " ORDER BY SortNum";
DataSet ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.Text, sql);
return(ds.Tables[0]);
}
/// <summary>
/// 检查是否有重名
/// </summary>
/// <param name="name"></param>
/// <param name="pid"></param>
/// <returns></returns>
private bool CheckName(string name, string id)
{
try
{
Entities.QueryWOrderBusiTypeInfo query = new Entities.QueryWOrderBusiTypeInfo();
query.BusiTypeName = name;
query.Status = "1,0";
query.NoRecID = id;
DataTable dt = BLL.WOrderBusiType.Instance.GetAllData(query);
//
if (dt != null && dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
catch {
return(false);
}
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <param name="status">是否可用,可以用“,”分割</param>
/// <returns></returns>
public DataTable GetAllData(Entities.QueryWOrderBusiTypeInfo query)
{
return(Dal.WOrderBusiType.Instance.GetAllData(query));
}
