//public static bool UpdateProviderInfo(ProviderInfoModel model, string no)
public static bool UpdateProviderInfo(ProviderInfoModel model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (model.ID <= 0)
{
return(false);
}
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERINFO_ADD;
succ = ProviderInfoDBHelper.UpdateProviderInfo(model);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static bool InsertProviderInfo(ProviderInfoModel model, out string ID)
{
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERINFO_ADD;
succ = ProviderInfoDBHelper.InsertProviderInfo(model, out ID);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// </summary>
/// <returns>DataTable</returns>
public static DataTable PurchaseProviderCount(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string ProviderID, string StartOrderDate, string EndOrderDate)
{
try
{
return(ProviderInfoDBHelper.PurchaseProviderCount(pageIndex, pageCount, orderBy, ref TotalCount, ProviderID, StartOrderDate, EndOrderDate));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// </summary>
/// <returns>DataTable</returns>
public static DataTable PurchaseProviderAccount(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string ProviderID, string ProviderName, string StartConfirmDate, string EndConfirmDate, string CompanyCD)
{
try
{
return(ProviderInfoDBHelper.PurchaseProviderAccount(pageIndex, pageCount, orderBy, ref TotalCount, ProviderID, ProviderName, StartConfirmDate, EndConfirmDate, CompanyCD));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetProviderInfo(ProviderInfoModel ProviderInfoM, int pageIndex, int pageCount, string OrderBy, out int totalCount)
{
try
{
return(ProviderInfoDBHelper.GetProviderInfo(ProviderInfoM, pageIndex, pageCount, OrderBy, out totalCount));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// </summary>
/// <returns>DataTable</returns>
public static DataTable PurchaseProviderAccountPrint(string ProviderID, string ProviderName, string StartConfirmDate, string EndConfirmDate, string CompanyCD, string orderBy)
{
try
{
return(ProviderInfoDBHelper.PurchaseProviderAccountPrint(ProviderID, ProviderName, StartConfirmDate, EndConfirmDate, CompanyCD, orderBy));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SelectProviderInfo(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string CustNo, string CustName, string CustNam, string PYShort, string CustType, string CustClass, string AreaID, string CreditGrade, string Manager, string StartCreateDate, string EndCreateDate)
{
try
{
return(ProviderInfoDBHelper.SelectProviderInfoList(pageIndex, pageCount, orderBy, ref TotalCount, CustNo, CustName, CustNam, PYShort, CustType, CustClass, AreaID, CreditGrade, Manager, StartCreateDate, EndCreateDate));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SelectProviderInfo2(int ID)
{
try
{
return(ProviderInfoDBHelper.SelectProviderInfo2(ID));
}
catch
{
return(null);
}
}
public static bool isValues(int ID)
{
try
{
return(ProviderInfoDBHelper.isValues(ID));
}
catch
{
throw;
}
}
public static DataTable GetProviderClass()
{
try
{
return(ProviderInfoDBHelper.GetProviderClass());
}
catch
{
return(null);
throw;
}
}
/// <summary>
/// 获取当前企业的供应商信息 Add by jiangym
/// </summary>
/// <param name="CompanyCD">企业编码</param>
/// <returns>DataTable</returns>
public static DataTable GetProviderInfo()
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
return(ProviderInfoDBHelper.GetProviderInfo(CompanyCD));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteProviderInfoAll(string CustNo, string CompanyCD)
{
LogInfoModel logModel = InitLogInfo(CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERINFOINFO;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//string[] sql = new string[3];
//int index = 0;
SqlCommand[] cmdList = new SqlCommand[3];
cmdList [0] = ProviderInfoDBHelper.DeleteProviderInfo(CustNo, CompanyCD); //供应商信息
cmdList[1] = ProviderInfoDBHelper.DeleteProviderLinkMan(CustNo, CompanyCD); //供应商联系人
cmdList[2] = ProviderInfoDBHelper.DeleteProviderProduct(CustNo, CompanyCD); //供应商产品
SqlHelper.ExecuteTransForList(cmdList);
bool isSucc = SqlHelper.Result.OprateCount > 0 ? true : false;
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
logModel.Remark = remark;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
logModel.Remark = remark;
}
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
/// <summary>
/// 绑定采购供应商优质级别
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpCreditGrade()
{
DataTable dt = ProviderInfoDBHelper.GetdrpCreditGrade();
return(dt);
}
public static DataTable GetProviderSelect(ProviderInfoModel ProviderInfoM)
{
return(ProviderInfoDBHelper.GetProviderSelect(ProviderInfoM));
}
/// <summary>
/// 绑定采购供应商分类
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpCustClass()
{
DataTable dt = ProviderInfoDBHelper.GetdrpCustClass();
return(dt);
}
/// <summary>
/// 绑定采购供应商所在区域
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpAreaID()
{
DataTable dt = ProviderInfoDBHelper.GetdrpAreaID();
return(dt);
}
//#region 绑定采购支付方式
///// <summary>
///// 绑定采购结算方式
///// </summary>
///// <returns>DataTable</returns>
//public static DataTable GetDrpMoneyType()
//{
// DataTable dt = ProviderInfoDBHelper.GetDrpMoneyType();
// return dt;
//}
//#endregion
#region 绑定采购供应商币种
/// <summary>
/// 绑定采购供应商币种
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpCurrencyType()
{
DataTable dt = ProviderInfoDBHelper.GetdrpCurrencyType();
return(dt);
}
/// <summary>
/// 绑定采购供应商联络期限
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpLinkCycle()
{
DataTable dt = ProviderInfoDBHelper.GetdrpLinkCycle();
return(dt);
}
/// <summary>
/// 绑定采购结算方式
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetDrpPayType()
{
DataTable dt = ProviderInfoDBHelper.GetDrpPayType();
return(dt);
}
