/// <summary>
/// 物资名称下拉框
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getnameSelectOption(DC_SUPPLIES_SW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.DC_SUPPLIES.getDT(sw);
if (sw.isShowAll == "1")
{
sb.AppendFormat("<option value=\"\">{0}</option>", "--所有--");
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string SUPID = dt.Rows[i]["SUPID"].ToString();
string DCSUPPROPNAME = DC_SUPPLIESPROPCls.getsupname(SUPID);
string DCmodel = DC_SUPPLIESPROPCls.getsupmodel(SUPID);
if (string.IsNullOrEmpty(DCmodel) == false)
{
sb.AppendFormat("<option value=\"{0}\">{1}【{2}】</option>", SUPID, DCSUPPROPNAME, DCmodel);
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", SUPID, DCSUPPROPNAME);
}
}
dt.Clear();
dt.Dispose();
return(sb.ToString());
}
/// <summary>
/// 获取物资名称+型号json
/// </summary>
/// <param name="sw"></param>
/// <param name="type"></param>
/// <returns></returns>
public static string getSupCKJsonStr(DC_SUPPLIES_SW sw, string type)
{
DataTable dt = BaseDT.DC_SUPPLIES.getcombox(sw, type);
char[] specialChars = new char[] { ',' };
string JSONstring = "[";
for (int i = 0; i < dt.Rows.Count; i++)
{
string Id = dt.Rows[i]["SUPID"].ToString();
string Name = dt.Rows[i]["DCSUPPROPNAME"].ToString();
string Model = dt.Rows[i]["DCSUPPROPMODEL"].ToString();
string PRICE = dt.Rows[i]["PRICE"].ToString();
JSONstring += "{";
JSONstring += "\"id\":\"" + Id + "\",";
if (string.IsNullOrEmpty(Model) == false)
{
JSONstring += "\"text\":\"" + Name + "【" + Model + "】" + "￥" + PRICE + "\"";
}
else
{
JSONstring += "\"text\":\"" + Name + "【--】" + "￥" + PRICE + "\"";
}
JSONstring += "},";
}
JSONstring = JSONstring.TrimEnd(specialChars);
JSONstring += "]";
return(JSONstring.ToString());
}
/// <summary>
/// 获取物资表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <DC_SUPPLIES_Model> getModelList(DC_SUPPLIES_SW sw)
{
var result = new List <DC_SUPPLIES_Model>();
DataTable dt = BaseDT.DC_SUPPLIES.getDT(sw);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_SUPPLIES_Model m = new DC_SUPPLIES_Model();
m.DCSUPPLIESID = dt.Rows[i]["DCSUPPLIESID"].ToString();
m.REPID = dt.Rows[i]["REPID"].ToString();
m.SUPID = dt.Rows[i]["SUPID"].ToString();
m.SUPNAME = DC_SUPPLIESPROPCls.getsupname(m.SUPID);
m.DCSUPCOUNT = dt.Rows[i]["DCSUPCOUNT"].ToString();
m.EQUIPTYPEName = DC_EQUIP_NEWCls.getEQUIPTYPEName(m.DCSUPPLIESID);
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DC_SUPPLIES_Model getModel(DC_SUPPLIES_SW sw)
{
var result = new List <DC_SUPPLIES_Model>();
DataTable dt = BaseDT.DC_SUPPLIES.getDT(sw);//列表
DC_SUPPLIES_Model m = new DC_SUPPLIES_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DCSUPPLIESID = dt.Rows[i]["DCSUPPLIESID"].ToString();
m.REPID = dt.Rows[i]["REPID"].ToString();
m.SUPID = dt.Rows[i]["SUPID"].ToString();
m.DCSUPCOUNT = dt.Rows[i]["DCSUPCOUNT"].ToString();
m.EQUIPTYPEName = DC_EQUIP_NEWCls.getEQUIPTYPEName(m.DCSUPPLIESID);
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取物资数量
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getcount(DC_SUPPLIES_SW sw)
{
DC_SUPPLIES_Model m = getModel(sw);
return(m.DCSUPCOUNT);
}
