/// <summary>
/// 获取数据
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(DC_TYPE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" from DC_TYPE a ");
sb.AppendFormat("where 1=1");
if (string.IsNullOrEmpty(sw.DCTYPEID) == false)
{
sb.AppendFormat("and DCTYPEID = '{0}'", ClsSql.EncodeSql(sw.DCTYPEID));
}
if (string.IsNullOrEmpty(sw.DCTYPETOPID) == false)
{
sb.AppendFormat("and DCTYPETOPID = '{0}'", ClsSql.EncodeSql(sw.DCTYPETOPID));
}
if (string.IsNullOrEmpty(sw.DCTYPENAME) == false)
{
sb.AppendFormat("and DCTYPENAME = '{0}'", ClsSql.EncodeSql(sw.DCTYPENAME));
}
if (string.IsNullOrEmpty(sw.ORDERBY) == false)
{
sb.AppendFormat("and ORDERBY = '{0}'", ClsSql.EncodeSql(sw.ORDERBY));
}
if (string.IsNullOrEmpty(sw.DCTYPEFLAG) == false)
{
sb.AppendFormat(" AND DCTYPEFLAG = '{0}'", ClsSql.EncodeSql(sw.DCTYPEFLAG));
}
string sql = ("select DCTYPEID,DCTYPETOPID,DCTYPENAME,ORDERBY,DCTYPEFLAG") + sb.ToString() + (" order by DCTYPEID ");
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 获取序号id
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getID(DC_TYPE_SW sw)
{
DataTable dt = getDT(sw);
string dctypeid = "";
if (dt.Rows.Count > 0)
{
dctypeid = dt.Rows[0]["DCTYPEID"].ToString();
}
dt.Clear();
dt.Dispose();
return(dctypeid);
}
/// <summary>
/// 仓库树形菜单
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getdepotTree(DC_TYPE_SW sw)
{
DataTable dtTYPE = BaseDT.DC_TYPE.getDT(new DC_TYPE_SW {
DCTYPEFLAG = "EQUIP"
});
string dctypetopid = BaseDT.DC_TYPE.getID(new DC_TYPE_SW {
DCTYPEFLAG = "EQUIP", DCTYPETOPID = "0"
});
JArray DEPOT = getDC_TYPEChild(dtTYPE, dctypetopid);
dtTYPE.Clear();
dtTYPE.Dispose();
return(JsonConvert.SerializeObject(DEPOT));
}
/// <summary>
/// 仓库树形菜单
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getREPOSITORYTree(DC_TYPE_SW sw)
{
DataTable dtTYPE = BaseDT.DC_TYPE.getDT(new DC_TYPE_SW {
DCTYPEFLAG = "REPOSITORY"
});
string dctypetopid = BaseDT.DC_TYPE.getID(new DC_TYPE_SW {
DCTYPEFLAG = "REPOSITORY", DCTYPETOPID = "0"
});
DataTable dtREPOSITORY = BaseDT.DC_REPOSITORY.getDT(new DC_REPOSITORY_SW {
});
JArray REPOSITORY = getDC_typeREPOSITORYChild(dtTYPE, dtREPOSITORY, dctypetopid);
dtTYPE.Clear();
dtTYPE.Dispose();
return(JsonConvert.SerializeObject(REPOSITORY));
}
/// <summary>
/// 组成装备树形菜单
/// </summary>
/// <returns></returns>
public static string getEQUIPTree(DC_TYPE_SW sw)
{
DataTable dtTYPE = BaseDT.DC_TYPE.getDT(new DC_TYPE_SW {
DCTYPEFLAG = "EQUIP"
});
string dctypetopid = BaseDT.DC_TYPE.getID(new DC_TYPE_SW {
DCTYPEFLAG = "EQUIP", DCTYPETOPID = "0"
});
DataTable dtEQUIP = BaseDT.DC_EQUIP.getDT(new DC_EQUIP_SW {
});
JArray EQUIP = getDC_typeEQUIPChild(dtTYPE, dtEQUIP, dctypetopid);
dtTYPE.Clear();
dtTYPE.Dispose();
return(JsonConvert.SerializeObject(EQUIP));
}
/// <summary>
/// 组成设施树形菜单
/// </summary>
/// <returns></returns>
public static string getFACILITYTree(DC_TYPE_SW sw)
{
DataTable dtTYPE = BaseDT.DC_TYPE.getDT(new DC_TYPE_SW {
DCTYPEFLAG = "FACILITY"
});
string dctypetopid = BaseDT.DC_TYPE.getID(new DC_TYPE_SW {
DCTYPEFLAG = "FACILITY", DCTYPETOPID = "0"
});
DataTable dtFACILITY = BaseDT.DC_FACILITY.getDT(new DC_FACILITY_SW {
});
JArray FACILITYT = getDC_typeFACILITYChild(dtTYPE, dtFACILITY, dctypetopid);
dtTYPE.Clear();
dtTYPE.Dispose();
return(JsonConvert.SerializeObject(FACILITYT));
}
/// <summary>
/// 根据查询条件获取某一条信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DC_TYPE_Model getModel(DC_TYPE_SW sw)
{
DataTable dt = BaseDT.DC_TYPE.getDT(sw);//列表
DC_TYPE_Model m = new DC_TYPE_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DCTYPEID = dt.Rows[i]["DCTYPEID"].ToString();
m.DCTYPETOPID = dt.Rows[i]["DCTYPETOPID"].ToString();
m.DCTYPENAME = dt.Rows[i]["DCTYPENAME"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.DCTYPEFLAG = dt.Rows[i]["DCTYPEFLAG"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取文档列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <DC_TYPE_Model> getModelList(DC_TYPE_SW sw)
{
var result = new List <DC_TYPE_Model>();
DataTable dt = BaseDT.DC_TYPE.getDT(sw);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_TYPE_Model m = new DC_TYPE_Model();
m.DCTYPEID = dt.Rows[i]["DCTYPEID"].ToString();
m.DCTYPETOPID = dt.Rows[i]["DCTYPETOPID"].ToString();
m.DCTYPENAME = dt.Rows[i]["DCTYPENAME"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.DCTYPEFLAG = dt.Rows[i]["DCTYPEFLAG"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
