/// <summary>
///获取审核记录
/// </summary>
/// <param name="SysNo"></param>
/// <returns></returns>
public DataTable GetAuditHistory(int SysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetAuditHistory");
cmd.SetParameterValue("@SysNo", SysNo);
return(cmd.ExecuteDataTable());
}
protected void Page_Load(object sender, EventArgs e)
{
int categoryId = 2;
//找出属性
using (DataCommand cmd = DataCommandManager.GetDataCommand("MetaType"))
{
cmd.SetParameterValue("@CategoryId", categoryId);
DataTable dt = cmd.ExecuteDataTable();
StringBuilder sb = new StringBuilder();
foreach (DataRow dataRow in dt.Rows)
{
string name = dataRow["Name"].ToString();
string htmlContorlType = dataRow["HtmlContorlType"].ToString();
switch (htmlContorlType)
{
case "password":
sb.AppendFormat(" <input id=\"{0}\" type=\"password\" /><br/>", name);
break;
case "input":
sb.AppendFormat(" <input id=\"{0}\" type=\"text\" /><br/>", name);
break;
default:
break;
}
}
Html = sb.ToString();
}
}
public static string CreateGroupBuyingTicketSequence()
{
DataCommand command = DataCommandManager.GetDataCommand("CreateGroupBuyingTicketSequence");
DataTable dt = command.ExecuteDataTable();
return(dt.Rows[0][0].ToString());
}
/// <summary>
/// 根据属性得到所有属性值
/// </summary>
/// <param name="PropertySysNo"></param>
/// <returns>DataTable</returns>
public DataTable GetPropertyValueByPropertySysNo(int PropertySysNo)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetPropertyValueByPropertySysNo");
dc.SetParameterValue("@PropertySysNo", PropertySysNo);
return(dc.ExecuteDataTable());
}
/// <summary>
/// 根据产品线类别SysNo得到产品线
/// </summary>
/// <param name="CategorySysNo"></param>
/// <returns>DataTable</returns>
public DataTable GetProductLineByProductLineCategorySysNo(int CategorySysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductLineByProductLineCategorySysNo");
cmd.SetParameterValue("@CategorySysNo", CategorySysNo);
return(cmd.ExecuteDataTable());
}
public DataTable GetWaitingRegisters(int?soSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("QueryWaitingRegisterForRefund");
if (soSysNo == null)
{
List <int> waitingSO = ObjectFactory <IRefundDA> .Instance.GetWaitingSOForRefund();
if (waitingSO != null && waitingSO.Count > 0)
{
string sql = "C.[SOSysNo] IN(";
waitingSO.ForEach(item => sql += item + ",");
sql = sql.TrimEnd(',');
sql += ")";
command.ReplaceParameterValue("#SOSysNo#", sql);
}
else
{
command.ReplaceParameterValue("#SOSysNo#", "C.[SOSysNo] IS NULL");
}
}
else
{
command.ReplaceParameterValue("#SOSysNo#", "C.[SOSysNo] = @SOSysNo");
}
command.SetParameterValue("@SOSysNo", soSysNo);
command.SetParameterValue("@RefundStatus", RMARefundStatus.Abandon);
return(command.ExecuteDataTable());
}
public DataTable GetAccessoriesQueryConditionBySysNo(int SysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetAccessoriesQueryConditionBySysNo");
cmd.SetParameterValue("@SysNo", SysNo);
return(cmd.ExecuteDataTable());
}
/// <summary>
/// 查询商品
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryProductEx(NeweggProductQueryFilter filter, out int totalCount)
{
DataCommand command = DataCommandManager.GetDataCommand("QueryProductEx");
filter.CompanyCode = "8601";
filter.CurrentUserSysNo = ServiceContext.Current.UserSysNo;
CreateQueryProductCommand(filter, command);
var sort = filter.PagingInfo.SortBy;
var sortField = "";
var sortType = "";
if (!String.IsNullOrEmpty(sort))
{
var input = Regex.Replace(filter.PagingInfo.SortBy.Trim(), "\\s+", " ");
var pageArry = input.Split(' ');
if (pageArry.Length == 2)
{
sortField = pageArry[0];
sortType = pageArry[1];
}
}
command.SetParameterValue("@SortField", sortField);
command.SetParameterValue("@SortType", sortType);
command.SetParameterValue("@PageSize", filter.PagingInfo.PageSize);
command.SetParameterValue("@PageCurrent", filter.PagingInfo.PageIndex);
var columnConfig = new EnumColumnList
{
{ "Status", typeof(ProductStatus) }
};
var table = command.ExecuteDataTable(columnConfig);
totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(table);
}
/// <summary>
/// 查询属性
/// </summary>
/// <param name="queryCriteria"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryPropertyList(PropertyQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryPropertyList");
if (string.IsNullOrEmpty(queryCriteria.PropertyName))
{
dc.SetParameterValue("@PropertyDescription", "");
}
else
{
dc.SetParameterValue("@PropertyDescription", "%" + queryCriteria.PropertyName.Trim() + "%");
}
dc.SetParameterValue("@IsActive", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable();
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(source);
}
/// <summary>
/// 根据用户编号获取用户
/// </summary>
/// <param name="customerID">用户编号</param>
/// <returns></returns>
public static ArrayList GetCustomerByCustomerID(int customerID)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetCustomerByCustomerID");
cmd.SetParameterValue("@CustomerID", customerID);
return(DbHelper.DatatableConvertArrayList(cmd.ExecuteDataTable()));
}
public object GetApplyForLoan()
{
DataTable dt;
using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertApplyForLoan"))
{
cmd.CommandText = "select * from ApplyForLoan";
dt = cmd.ExecuteDataTable();
}
var resultObj = new JQGridDataResult
{
// 总页数
PageCount = 1,
// 当前页
PageIndex = 1,
// 总记录数
Total = dt.Rows.Count,
// 数据
Data = dt
};
return(resultObj);
}
protected void Page_Load(object sender, EventArgs e)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("TestSqlite"))
{
DataTable dt = cmd.ExecuteDataTable();
}
}
public DataTable QueryWHArea()
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryWarehouse");
cmd.SetParameterValue("@CompanyCode", "8601");
return(cmd.ExecuteDataTable());
}
/// <summary>
/// 根据query得到CPSUser信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetCpsUser(CpsUserQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetCpsUser");
cmd.SetParameterValue("@Status", query.AuditStatus);
cmd.SetParameterValue("@UserType", query.UserType);
cmd.SetParameterValue("@WebSiteType", query.WebSiteType);
cmd.SetParameterValue("@IsAvailable", query.IsActive);
cmd.SetParameterValue("@CustomerID", query.CustomerID);
cmd.SetParameterValue("@ReceivablesName", query.ReceivablesName);
cmd.SetParameterValue("@Email", query.Email);
cmd.SetParameterValue("@Phone", query.Phone);
cmd.SetParameterValue("@ImMessenger", query.ImMessenger);
cmd.SetParameterValue("@RegisterDateFrom", query.RegisterDateFrom);
cmd.SetParameterValue("@RegisterDateTo", query.RegisterDateTo);
cmd.SetParameterValue("@PageIndex", query.PageInfo.PageIndex);
cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize);
cmd.SetParameterValue("@SortFiled", query.PageInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(AuditStatus) },
{ "UserType", typeof(UserType) },
{ "IsAvailable", typeof(IsActive) },
{ "BankLock", typeof(IsLock) },
{ "BankAccountType", typeof(UserType) }
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
public DataTable GetPurchaseOrderAccessories(int poSysNo)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("GetProductAccessoriesByPOSysno");
dataCommand.SetParameterValue("@POSysNo", poSysNo);
return(dataCommand.ExecuteDataTable());
}
public virtual DataTable QueryProductCardInventoryByProductSysNo(int productSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryProductCardInventory");
cmd.SetParameterValue("@ProductSysNo", productSysNo);
return(cmd.ExecuteDataTable());
}
public DataTable GetNeedSendMailPOForAutoCloseJob(int poSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetNeedSendEmailPO");
cmd.SetParameterValue("@PoSysNo", poSysNo);
return(cmd.ExecuteDataTable());
}
/// <summary>
/// 获取厂商关于咨询的回复列表
/// </summary>
/// <param name="consultSysNo"></param>
/// <returns></returns>
public List <ProductConsultReply> GetProductConsultFactoryReplyList(int consultSysNo)
{
DataCommand dc = DataCommandManager.GetDataCommand("ProductConsult_GetProductConsultFactoryReplyList");
dc.SetParameterValue("@ConsultSysNo", consultSysNo);
//EnumColumnList enumList = new EnumColumnList();
//enumList.Add("Status", typeof(ECCentral.BizEntity.MKT.ReplyStatus));//前台展示状态
//enumList.Add("Type", typeof(ECCentral.BizEntity.MKT.NYNStatus));//是否存在回复
CodeNamePairColumnList pairList = new CodeNamePairColumnList();
pairList.Add("Type", "MKT", "ConsultCategory");
pairList.Add("Status", "MKT", "FactoryReplyStatus");
DataTable dt = dc.ExecuteDataTable(pairList);
List <ProductConsultReply> list = new List <ProductConsultReply>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(DataMapper.GetEntity <ProductConsultReply>(dr));
}
}
return(list);
}
/// <summary>
/// 查询PM
/// </summary>
/// <param name="queryCriteria"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryProductManagerInfo(ProductManagerQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryProductManagerInfo");
if (string.IsNullOrEmpty(queryCriteria.UserName))
{
dc.SetParameterValue("@PMUserName", "");
}
else
{
dc.SetParameterValue("@PMUserName", "%" + queryCriteria.UserName.Trim() + "%");
}
dc.SetParameterValue("@PMID", string.IsNullOrEmpty(queryCriteria.UserID) ? "" : queryCriteria.UserID);
dc.SetParameterValue("@Status", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable();
totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
return(source);
}
public DataTable QueryVendorStoreList(int vendorSysNo)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("GetVendorStoreInfoList");
dataCommand.SetParameterValue("@VendorSysNo", vendorSysNo);
return(dataCommand.ExecuteDataTable());
}
/// <summary>
/// 得到某类下所有的属性
/// </summary>
/// <param name="GetPropertyByCategory3SysNo"></param>
/// <returns>DataTable</returns>
public DataTable GetPropertyByCategory3SysNo(int Category3SysNo)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetPropertyByCategory3SysNo");
dc.SetParameterValue("@Category3SysNo", Category3SysNo);
return(dc.ExecuteDataTable());
}
/// <summary>
/// 获取所有需要审核的类别信息
/// </summary>
/// <param name="query"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public DataTable GetCategoryRequestApprovalList(CategoryRequestApprovalQueryFilter query, out int TotalCount)
{
DataCommand dc = null;
switch (query.Category)
{
case CategoryType.CategoryType1:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest1List");
break;
case CategoryType.CategoryType2:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest2List");
break;
case CategoryType.CategoryType3:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest3List");
break;
default:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest1List");
break;
}
dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
dc.SetParameterValue("@CreateUserSysNo", 0);
dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable();
TotalCount = (int)dc.GetParameterValue("@TotalCount");
return(dt);
}
public DataTable GetProductExtByQuery(ProductExtQueryFilter query, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetItemExtList");
dc.SetParameterValue("@ProductID", query.ProductID);
dc.SetParameterValue("@ProductStatus", query.ProductStatus);
if (query.ProductType != null)
{
dc.SetParameterValue("@ProductType", LegacyEnumMapper.ConvertProductType(query.ProductType.Value));
}
else
{
dc.SetParameterValue("@ProductType", null);
}
dc.SetParameterValue("@Manufacturer", query.Manufacturer);
dc.SetParameterValue("@ProductPrice", query.ProductPrice);
dc.SetParameterValue("@IsPermitRefund", query.IsPermitRefund);
dc.SetParameterValue("@Category1", query.Category1);
dc.SetParameterValue("@Category2", query.Category2);
dc.SetParameterValue("@Category3", query.Category3);
dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(ProductStatus) },
{ "IsPermitRefund", typeof(IsDefault) }
};
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
return(dt);
}
public DataTable QueryVendorPayBalanceByVendorSysNo(int vendorSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetVendorPayBalanceByVendorSysNo");
command.SetParameterValue("@VendorSysNo", vendorSysNo);
return(command.ExecuteDataTable());
}
public DataTable GetRmaPolicyLog(RmaPolicyLogQueryFilter filter, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetRmaPolicyLog");
cmd.SetParameterValue("@RmaPolicySysNo", filter.RmaPolicySysNO);
cmd.SetParameterValue("@RmaPolicy", filter.RmaPolicy);
cmd.SetParameterValue("@UpdateDateTo", filter.UpdateDateTo);
cmd.SetParameterValue("@UpdateDateFrom", filter.UpdateDateFrom);
cmd.SetParameterValue("@EditUserName", filter.EidtUserName);
cmd.SetParameterValue("@pageIndex", filter.PagingInfo.PageIndex);
cmd.SetParameterValue("@pageSize", filter.PagingInfo.PageSize);
cmd.SetParameterValue("@sortField", filter.PagingInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(RmaPolicyStatus) },
{ "Type", typeof(RmaPolicyType) },
{ "IsOnlineRequst", typeof(IsOnlineRequst) },
{ "OperationType", typeof(RmaLogActionType) },
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@totalCount");
return(dt);
}
/// <summary>
/// 查询生产商
/// </summary>
/// <returns></returns>
public virtual DataTable QueryManufacturer(ManufacturerQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryManufacturer");
if (string.IsNullOrEmpty(queryCriteria.ManufacturerNameLocal))
{
dc.SetParameterValue("@ManufacturerName", "");
}
else
{
dc.SetParameterValue("@ManufacturerName", "%" + queryCriteria.ManufacturerNameLocal.Trim() + "%");
}
dc.SetParameterValue("@Status", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable(5, typeof(ManufacturerStatus));;
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(source);
}
public virtual DataTable GetUpdateUser(string CompanyCode)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetUpdateUser");
cmd.SetParameterValue("@CompanyCode", CompanyCode);
return(cmd.ExecuteDataTable());
}
/// <summary>
/// 获取详细的礼品卡操作日志
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public List <GiftCardRedeemLog> GetGiftCardRedeemLogJoinSOMaster(string code)
{
DataCommand dc = DataCommandManager.GetDataCommand("GiftCard_GetGiftCardRedeemLogJoinSOMaster");
dc.SetParameterValue("@Code", code);
EnumColumnList enumList = new EnumColumnList();
enumList.Add("OrderStatus", typeof(ECCentral.BizEntity.SO.SOStatus));
enumList.Add("RedeemStatus", typeof(ValidStatus));
var dt = dc.ExecuteDataTable(enumList);
if (dt != null && dt.Rows.Count > 0)
{
List <GiftCardRedeemLog> list = new List <GiftCardRedeemLog>();
foreach (DataRow dr in dt.Rows)
{
list.Add(DataMapper.GetEntity <GiftCardRedeemLog>(dr));
}
return(list);
}
else
{
return(null);
}
//using (IDataReader reader = dc.ExecuteDataReader())
//{
// return DataMapper.GetEntityList<GiftCardOperateLog, List<GiftCardOperateLog>>(reader);
//}
}
/// <summary>
///
/// </summary>
/// <param name="sysNo"></param>
/// <param name="exchangeRate"></param>
/// <param name="iPayPeriodType"></param>
/// <returns></returns>
public List <GiftCardFabrication> GetGiftCardFabricationItem(int sysNo, decimal exchangeRate, int iPayPeriodType)
{
//DataCommand dc = DataCommandManager.GetDataCommand("GiftCard_GetGiftCardFabricationItem");
DataCommand dc = DataCommandManager.GetDataCommand("GiftVoucherProduct_GetFabricationItem");
dc.SetParameterValue("@GiftCardFabricationSysNo", sysNo);
//dc.SetParameterValue("@C3SysNo", AppSettingManager.GetSetting("MKT", "C3SysNoForGiftCardFabrication"));
//dc.SetParameterValue("@ManufacturerSysNo", AppSettingManager.GetSetting("MKT", "ManufacturerSysNoForGiftCardFabrication"));
//dc.SetParameterValue("@ExchangeRate", exchangeRate);
//dc.SetParameterValue("@PayPeriodType", iPayPeriodType);
//dc.SetParameterValue("@CompanyCode", "8601");
var dt = dc.ExecuteDataTable();
if (dt != null && dt.Rows.Count > 0)
{
List <GiftCardFabrication> list = new List <GiftCardFabrication>();
foreach (DataRow dr in dt.Rows)
{
list.Add(DataMapper.GetEntity <GiftCardFabrication>(dr));
}
return(list);
}
return(null);
}
public DataTable GetUserInfo(int userId)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("GetUserInfo"))
{
cmd.SetParameterValue("@UserId", userId);
return(cmd.ExecuteDataTable());
}
}