/// <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); }