/// <summary> /// 更新父类别 /// </summary> /// <param name="partner">更新父类别</param> /// <returns></returns> public string UpdPurchasingTypeRecord(T_PTR ptr) { string rs = ""; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); if (string.IsNullOrEmpty(ptr.AT_GUID)) { ptr.AT_GUID = Guid.NewGuid().ToString(); } bool result = new AIDSvc().UpdPurchasingTypeRecord(ptr); if (result) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
/// <summary> /// 获取公共父类 /// </summary> /// <returns></returns> public List <T_PTR> GetComParentAidType(T_PTR ptr) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_GetComParentAidType"; dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, ptr.C_GUID); return(dh.Reader <T_PTR>()); }
/// <summary> /// 获取父类 /// </summary> /// <returns></returns> public List <T_PTR> GetSubAidType(T_PTR ptr) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_GetSubAidType"; dh.AddPare("@Parent", SqlDbType.NVarChar, 50, ptr.Parent); return(dh.Reader <T_PTR>()); }
/// <summary> /// 获取公共父类 /// </summary> /// <returns></returns> public string GetComParentAidType(T_PTR ptr) { ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); var subTypeList = new AIDSvc().GetComParentAidType(ptr); var strJson = ConvertToSelectJson(subTypeList, "AidTypeName", "AT_GUID"); return(strJson.ToString()); }
/// <summary> /// 删除物料 /// </summary> /// <returns></returns> public bool DelMaterielManage(T_PTR ptr) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_DelMM"; dh.AddPare("@MM_GUID", SqlDbType.NVarChar, 50, ptr.MM_GUID); dh.AddPare("@Flag", SqlDbType.NVarChar, 1, ptr.MM_FLAG); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, ptr.C_GUID); try { dh.NonQuery(); return(true); } catch { return(false); } }
/// <summary> /// 删除类别 /// </summary> /// <returns></returns> public bool DelPurchasingTypeRecord(T_PTR ptr) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_DelPTR"; dh.AddPare("@AT_GUID", SqlDbType.NVarChar, 50, ptr.AT_GUID); dh.AddPare("@Flag", SqlDbType.NVarChar, 1, ptr.AID_FLAG); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, ptr.C_GUID); try { dh.NonQuery(); return(true); } catch { return(false); } }
/// <summary> /// 删除物料 /// </summary> /// <param name="partner">删除物料</param> /// <returns></returns> public string DelMaterielManage(T_PTR ptr) { string rs = ""; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); bool result = new AIDSvc().DelMaterielManage(ptr); if (result) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
public bool UpdPurchasingSubTypeRecord(T_PTR ptr) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_UpdPSTR"; dh.AddPare("@AST_GUID", SqlDbType.NVarChar, 50, ptr.AST_GUID); dh.AddPare("@Depreciation_year", SqlDbType.NVarChar, 50, ptr.Depreciation_year); dh.AddPare("@AST_ParentAidType", SqlDbType.NVarChar, 50, ptr.AST_ParentAidType); dh.AddPare("@Remark", SqlDbType.NVarChar, 50, ptr.Remark); dh.AddPare("@ASTTypeName", SqlDbType.NVarChar, 50, ptr.ASTTypeName); dh.AddPare("@AID_FLAG", SqlDbType.NVarChar, 50, ptr.AID_FLAG); try { dh.NonQuery(); return(true); } catch { return(false); } }
/// <summary> /// 更新父类别前查询 /// </summary> /// <param name="partner">更新父类别前查询</param> /// <returns></returns> public string GetUpdPurchasingTypeRecord(T_PTR ptr) { string rs = ""; int count = 0; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); List <T_AIDRecord> Record = new List <T_AIDRecord>(); Record = new AIDSvc().GetUpdPurchasingTypeRecord(out count, ptr.AidTypeName, ptr.AID_FLAG, ptr.C_GUID); if (Record.Count == 0) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
/// <summary> /// 删除类别前查询 /// </summary> /// <param name="partner">删除类别</param> /// <returns></returns> public string GetDelMaterielManage(T_PTR ptr) { string rs = ""; int count = 0; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); List <T_AIDRecord> Record = new List <T_AIDRecord>(); Record = new AIDSvc().GetDelMaterielManage(out count, ptr.C_GUID, ptr.MM_GUID, ptr.MM_FLAG); if (Record.Count == 0) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
public bool UpdMaterielManage(T_PTR ptr) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_UpdMM"; dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, ptr.C_GUID); dh.AddPare("@MM_GUID", SqlDbType.NVarChar, 50, ptr.MM_GUID); dh.AddPare("@Parent", SqlDbType.NVarChar, 50, ptr.Parent); dh.AddPare("@Depreciation_year", SqlDbType.NVarChar, 50, ptr.Depreciation_year); dh.AddPare("@MM_Name", SqlDbType.NVarChar, 50, ptr.MM_Name); dh.AddPare("@Remark", SqlDbType.NVarChar, 50, ptr.Remark); dh.AddPare("@Asset_class", SqlDbType.NVarChar, 50, ptr.Asset_class); dh.AddPare("@MM_FLAG", SqlDbType.NVarChar, 50, ptr.MM_FLAG); try { dh.NonQuery(); return(true); } catch { return(false); } }