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