/// <summary>
/// 查询bom表记录
/// </summary>
/// <returns></returns>
public string GetQueryBom(string nodesid)
{
StringBuilder strJson = new StringBuilder();
T_ProductBom record = new T_ProductBom();
record = new AIDSvc().GetQueryBom(nodesid);
strJson.Append(new JavaScriptSerializer().Serialize(record));
return(strJson.ToString());
}
///// <summary>
///// 提交节点
///// </summary>
///// <returns></returns>
public bool SubmitProductBomRecord(T_ProductBom form)
{
DBHelper dh = new DBHelper();
dh.strCmd = "SP_UpdProductBomDeatil";
dh.AddPare("@MaterielManage_GUID", SqlDbType.NVarChar, 40, form.MaterielManage_GUID);
dh.AddPare("@nodesid", SqlDbType.NVarChar, 40, form.nodesid);
dh.AddPare("@subnodes", SqlDbType.NVarChar, 40, form.MaterielManage_GUID);
dh.AddPare("@tags", SqlDbType.Int, 0, form.tags);
try
{
dh.NonQuery();
return(true);
}
catch
{
return(false);
}
}
///// <summary>
///// 更新物料数量
///// </summary>
///// <returns></returns>
public string EditProductBomRecord(T_ProductBom form)
{
ExceResult rs = new ExceResult();
bool result = false;
string msg = string.Empty;
result = new AIDSvc().UpdProductBomRecord(form);
if (result)
{
rs.success = true;
rs.msg = "修改成功";
}
else
{
rs.success = true;
rs.msg = "修改失败";
}
return(JsonConvert.SerializeObject(rs));
}
///// <summary>
///// 更新物料数量
///// </summary>
///// <returns></returns>
public bool UpdProductBomRecord(T_ProductBom form)
{
DBHelper dh = new DBHelper();
dh.strCmd = "SP_UpdProductBom";
dh.AddPare("@nodesid", SqlDbType.NVarChar, 40, form.nodesid);
dh.AddPare("@nodes", SqlDbType.NVarChar, 40, form.nodes);
dh.AddPare("@nodelevel", SqlDbType.NVarChar, 40, form.nodelevel);
dh.AddPare("@tags", SqlDbType.Int, 0, form.tags);
try
{
dh.NonQuery();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 添加bom物料前的查询
/// </summary>
/// <param name="partner">更新父类别前查询</param>
/// <returns></returns>
public string GetUpdPurchasingBomTypeRecord(T_ProductBom pb)
{
string rs = "";
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_ProductBom> Record = new List <T_ProductBom>();
Record = new AIDSvc().GetUpdPurchasingBomTypeRecord(out count, C_GUID, pb.nodes, pb.subnodes, pb.nodelevel, pb.nodesid, pb.MaterielManage_GUID);
if (Record.Count == 0)
{
rs = "true";
}
else
{
rs = "false";
}
return(rs);
//return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
// , result.ToString().ToLower(), msg);
}
