public static PurchaseOrderInfo CreatePO(PurchaseOrderInfo poInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("CreatePOMaster");
command.SetParameterValue("@SysNo", poInfo.SysNo.Value);
command.SetParameterValue("@POID", poInfo.PurchaseOrderBasicInfo.PurchaseOrderID);
command.SetParameterValue("@VendorSysNo", int.Parse(poInfo.VendorInfo.VendorID));
command.SetParameterValue("@ITStockSysNo", DBNull.Value);
command.SetParameterValue("@StockSysNo", poInfo.PurchaseOrderBasicInfo.StockInfo.SysNo);
command.SetParameterValue("@ShipTypeSysNo", 0);
command.SetParameterValue("@PayTypeSysNo", 0);
command.SetParameterValue("@CurrencySysNo", poInfo.PurchaseOrderBasicInfo.CurrencyCode);
command.SetParameterValue("@ExchangeRate", poInfo.PurchaseOrderBasicInfo.ExchangeRate);
command.SetParameterValue("@TotalAmt", poInfo.PurchaseOrderBasicInfo.TotalAmt);
command.SetParameterValue("@CreateTime", DateTime.Now);
command.SetParameterValue("@CreateUserSysNo", poInfo.InUserSysNo);
command.SetParameterValue("@AuditTime", DBNull.Value);
command.SetParameterValue("@AuditUserSysNo", DBNull.Value);
command.SetParameterValue("@InTime", DBNull.Value);
command.SetParameterValue("@InUserSysNo", DBNull.Value);
command.SetParameterValue("@IsApportion", poInfo.PurchaseOrderBasicInfo.IsApportion);
command.SetParameterValue("@ApportionTime", DBNull.Value);
command.SetParameterValue("@ApportionUserSysNo", DBNull.Value);
command.SetParameterValue("@Memo", poInfo.PurchaseOrderBasicInfo.MemoInfo.Memo);
command.SetParameterValue("@InStockMemo", poInfo.PurchaseOrderBasicInfo.MemoInfo.InStockMemo);
command.SetParameterValue("@Status", (int)poInfo.PurchaseOrderBasicInfo.PurchaseOrderStatus);
command.SetParameterValue("@ETP", poInfo.PurchaseOrderBasicInfo.ETP);
command.SetParameterValue("@IsConsign", (int)poInfo.PurchaseOrderBasicInfo.ConsignFlag);
command.SetParameterValue("@POType", (int)poInfo.PurchaseOrderBasicInfo.PurchaseOrderType);
command.SetParameterValue("@TaxRate", poInfo.PurchaseOrderBasicInfo.TaxRate);
command.SetParameterValue("@PurchaseStockSysno", DBNull.Value);
command.SetParameterValue("@PMSysNo", 1);
command.SetParameterValue("@ETATime", poInfo.PurchaseOrderBasicInfo.ETATimeInfo.ETATime.HasValue ? poInfo.PurchaseOrderBasicInfo.ETATimeInfo.ETATime.Value.ToString("yyyy-MM-dd 00:00:00") : null);
command.SetParameterValue("@ETAHalfDay", poInfo.PurchaseOrderBasicInfo.ETATimeInfo.HalfDay);
command.SetParameterValue("@AutoSendMail", poInfo.PurchaseOrderBasicInfo.AutoSendMailAddress == "-999" ? "" : poInfo.PurchaseOrderBasicInfo.AutoSendMailAddress);
command.SetParameterValue("@CompanyCode", poInfo.CompanyCode);
command.ExecuteScalar();
return(poInfo);
}
/// <summary>
/// 根据SysNo获得货币实体信息
/// </summary>
/// <returns></returns>
public static AutoClose.Model.CurrencyInfo QueryCurrencyInfoBySysNo(int SysNo)
{
CurrencyInfo result = new AutoClose.Model.CurrencyInfo();
DataCommand cmd = DataCommandManager.GetDataCommand("GetCurrencyBySysNo");
cmd.SetParameterValue("@SysNo", SysNo);
cmd.SetParameterValue("@CompanyCode", Settings.CompanyCode);
//DataCommand selectCommand = DataCommandManager.GetDataCommand("GetCurrencyBySysNo");
//ProviderHelper.SetCommonParams(selectCommand);
//selectCommand.SetParameterValue("@SysNo", SysNo);
List <CurrencyInfo> list = cmd.ExecuteEntityList <CurrencyInfo>();
if (list.Count > 0)
{
return(list[0]);
}
else
{
return(null);
}
}
public void SynSysUser(ControlPanelUser controlPanelUser, int userSysNo, int generateUserSysNo)
{
DataCommand cmd;
if (userSysNo == 0)
{
cmd = DataCommandManager.GetDataCommand("InsertNewUserInOldData");
cmd.SetParameterValue("@GenerateUserSysNo", generateUserSysNo);
cmd.SetParameterValue("@UserID", controlPanelUser.LoginName);
}
else
{
cmd = DataCommandManager.GetDataCommand("UpdateExistUserInOldData");
cmd.SetParameterValue("@SysNo", userSysNo);
}
cmd.SetParameterValue("@UserName", controlPanelUser.DisplayName);
cmd.SetParameterValue("@Email", controlPanelUser.EmailAddress);
cmd.SetParameterValue("@Phone", controlPanelUser.PhoneNumber);
cmd.SetParameterValue("@Status", MappingStatus(controlPanelUser.Status));
cmd.ExecuteNonQuery();
}
public List <int> GetBackUpPMList(int userSysNo, string companyCode)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("GetBackupUserListBySysNo");
dataCommand.SetParameterValue("@PMUserSysNo", userSysNo);
dataCommand.SetParameterValue("@CompanyCode", companyCode);
string userList = dataCommand.ExecuteScalar() as string;
List <int> result = new List <int>();
if (!string.IsNullOrEmpty(userList))
{
string[] pms = userList.Split(';');
int[] pmlist = Array.ConvertAll(pms, str =>
{
int p = 0;
int.TryParse(str, out p);
return(p);
});
result.AddRange(pmlist);
}
return(result);
}
public BizEntity.PO.CommissionRule CreateCommission(BizEntity.PO.CommissionRule newCommissionRule)
{
DataCommand command = DataCommandManager.GetDataCommand("InsertCommissionRule");
command.SetParameterValue("@BrandSysNo", newCommissionRule.BrandSysNo);
command.SetParameterValue("@ManufacturerSysNo", newCommissionRule.ManufacturerSysNo);
command.SetParameterValue("@CostValue", newCommissionRule.CostValue);
command.SetParameterValue("@RuleType", newCommissionRule.RuleType);
command.SetParameterValue("@IsDefaultRule", newCommissionRule.IsDefaultRule);
command.SetParameterValue("@Level", newCommissionRule.Level);
command.SetParameterValue("@InUser", newCommissionRule.InUser);
command.SetParameterValue("@EditUser", newCommissionRule.EditUser);
#region [根据佣金等级获取类别编号:]
int?categorySysNo = null;
switch (newCommissionRule.Level)
{
case "0":
categorySysNo = null;
break;
case "1":
categorySysNo = newCommissionRule.C1SysNo;
break;
case "2":
categorySysNo = newCommissionRule.C2SysNo;
break;
case "3":
categorySysNo = newCommissionRule.C3SysNo;
break;
}
#endregion
command.SetParameterValue("@CategorySysNo", categorySysNo);
command.ExecuteNonQuery();
return(newCommissionRule);
}
/// <summary>
/// 修改分仓库存
/// </summary>
/// <param name="list"></param>
public static void ModifyQty(List <ProductEntity> list)
{
CommonConst commonConst = new CommonConst();
foreach (ProductEntity entity in list)
{
if (entity.InventoryAlarmQty.HasValue)
{
DataCommand command = DataCommandManager.GetDataCommand("ModifyStockQty");
command.SetParameterValue("@ProductMappingSysNo", entity.ProductMappingSysNo);
command.SetParameterValue("@WarehouseNumber", entity.WarehouseNumber);
command.SetParameterValue("@InventoryQty", entity.ResultQty);
command.SetParameterValue("@CompanyCode", commonConst.CompanyCode);
command.ExecuteNonQuery();
}
else
{
InsertStockQty(entity);
}
}
}
public int?CreateMaster(SaleGiftInfo info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_CreateSaleGiftMaster");
cmd.SetParameterValue("@PromotionName", info.Title.Content);
cmd.SetParameterValue("@PromotionDesc", info.Description.Content);
cmd.SetParameterValue("@Type", info.Type);
cmd.SetParameterValue("@Status", SaleGiftStatus.Init);
cmd.SetParameterValue("@BeginDate", info.BeginDate);
cmd.SetParameterValue("@Enddate", info.EndDate);
cmd.SetParameterValue("@AmountLimit", info.OrderCondition.OrderMinAmount == null ? 0 : info.OrderCondition.OrderMinAmount.Value);
cmd.SetParameterValue("@PromotionLink", info.PromotionLink);
cmd.SetParameterValue("@Memo", info.Memo);
cmd.SetParameterValue("@InUser", info.InUser ?? "");
cmd.SetParameterValue("@DisCountType", info.DisCountType);
cmd.SetParameterValue("@IsGlobal", info.IsGlobalProduct.HasValue && info.IsGlobalProduct.Value ? "Y" : "N");
cmd.SetParameterValue("@CompanyCode", info.CompanyCode);
cmd.SetParameterValue("@VendorSysNo", info.VendorSysNo);
cmd.ExecuteNonQuery();
info.SysNo = (int)cmd.GetParameterValue("@SysNo");
return(info.SysNo);
}
public override object OnGet(OrderProducts_Alvin request)
{
DataCommand dataCommand = null;
List <OrderProductsEntity> list = null;
if (request.OrderListID != null)
{
dataCommand = DataCommandManager
.GetDataCommand("Alvin_GetOrderProductByID");
list = dataCommand.ExecuteEntityList <OrderProductsEntity>(
new
{
OrderListID = request.OrderListID
}
);
}
return(new ResultEntity <List <OrderProductsEntity> > {
Result = "成功",
ResultCode = 200,
ResultContent = list
});
}
public void UpdateProductCommonInfoBasicInfo(ProductCommonInfo productCommonInfo, UserInfo operationUser)
{
DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoBasicInfo");
dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
dc.SetParameterValue("@ProductTitle", productCommonInfo.ProductBasicInfo.ProductTitle.Content);
dc.SetParameterValue("@ProductBriefName", productCommonInfo.ProductBasicInfo.ProductBriefName);
dc.SetParameterValue("@Keywords", productCommonInfo.ProductBasicInfo.Keywords.Content);
dc.SetParameterValue("@ProductModel", productCommonInfo.ProductBasicInfo.ProductModel.Content);
dc.SetParameterValue("@ProductType", productCommonInfo.ProductBasicInfo.ProductType);
dc.SetParameterValue("@PMUserSysNo", productCommonInfo.ProductBasicInfo.ProductManager.SysNo);
dc.SetParameterValue("@ProductDescription", productCommonInfo.ProductBasicInfo.ShortDescription.Content);
dc.SetParameterValue("@PackageList", productCommonInfo.ProductBasicInfo.PackageList.Content);
dc.SetParameterValue("@ProductLink", productCommonInfo.ProductBasicInfo.ProductLink);
dc.SetParameterValue("@Attention", productCommonInfo.ProductBasicInfo.Attention.Content);
dc.SetParameterValue("@IsTakePicture", productCommonInfo.ProductBasicInfo.IsTakePicture);
dc.SetParameterValue("@UPCCode", productCommonInfo.ProductBasicInfo.UPCCode);
dc.SetParameterValue("@BMCode", productCommonInfo.ProductBasicInfo.BMCode);
dc.SetParameterValue("@EditUser", operationUser.UserDisplayName);
dc.SetParameterValue("@EditUserSysNo", operationUser.SysNo);
dc.ExecuteNonQuery();
}
/// <summary>
/// 创建厂商信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual ManufacturerInfo CreateManufacturer(ManufacturerInfo entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("CreateManufacturer");
cmd.SetParameterValue("@ManufacturerName", entity.ManufacturerNameLocal != null ? entity.ManufacturerNameLocal.Content : null);
cmd.SetParameterValue("@BriefName", entity.ManufacturerNameGlobal);
cmd.SetParameterValue("@Note", entity.ManufacturerDescription != null ? entity.ManufacturerDescription.Content : null);
cmd.SetParameterValue("@Status", entity.Status);
cmd.SetParameterValue("@ManufacturerWebSite", entity.SupportInfo.ManufacturerUrl);
cmd.SetParameterValue("@SupportEmail", entity.SupportInfo.ServiceEmail);
cmd.SetParameterValue("@SupportURL", entity.SupportInfo.ServiceUrl);
cmd.SetParameterValue("@Type", 0);
cmd.SetParameterValue("@CustomerServicePhone", entity.SupportInfo.ServicePhone);
cmd.SetParameterValue("@CompanyCode", entity.CompanyCode);
cmd.SetParameterValue("@LanguageCode", entity.LanguageCode);
cmd.ExecuteNonQuery();
if (entity.SysNo == 0 || entity.SysNo == null)
{
entity.SysNo = (int)cmd.GetParameterValue("@SysNo");
}
return(entity);
}
public void CreateRMAPolicyLog(RmaPolicyInfo info, RmaLogActionType actionType)
{
DataCommand cmd = DataCommandManager.GetDataCommand("CreateRMAPolicyLog");
cmd.SetParameterValue("@RMAPolicyName", info.RMAPolicyName);
cmd.SetParameterValue("@RMAPolicySysNo", info.SysNo);
cmd.SetParameterValue("@Priority", info.Priority);
cmd.SetParameterValue("@Type", info.RmaType);
cmd.SetParameterValue("@Status", info.Status);
cmd.SetParameterValue("@ECDisplayName", info.ECDisplayName);
cmd.SetParameterValue("@ECDisplayDesc", info.ECDisplayDesc);
cmd.SetParameterValue("@ECDisplayMoreDesc", info.ECDisplayMoreDesc);
cmd.SetParameterValue("@ReturnDate", info.ReturnDate);
cmd.SetParameterValue("@ChangeDate", info.ChangeDate);
cmd.SetParameterValue("@IsOnlineRequst", info.IsOnlineRequest);
cmd.SetParameterValue("@InUser", info.User.UserDisplayName);
cmd.SetParameterValue("@CompanyCode", info.CompanyCode);
cmd.SetParameterValue("@StoreCompanyCode", info.CompanyCode);
cmd.SetParameterValue("@LanguageCode", info.LanguageCode);
cmd.SetParameterValue("@OperationType", actionType);
cmd.ExecuteNonQuery();
}
public Result <MessageModel> SendSms(int userId, string content)
{
var result = new Result <MessageModel>();
using (var cmd = DataCommandManager.GetDataCommand("InsertMessage"))
{
cmd.SetParameterValue("@UserId", userId);
cmd.SetParameterValue("@MsgContent", content);
cmd.SetParameterValue("@CreateTime", DateTime.Now);
cmd.SetParameterValue("@Status", 0);
result.Status = new Status();
if (cmd.ExecuteNonQuery() > 0)
{
result.Status.Code = "1";
}
else
{
result.Status.Code = "0";
}
}
return(result);
}
public virtual DataTable QueryProductCardsByProductSysNo(int productSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryProductCards");
cmd.SetParameterValue("@ProductSysNo", productSysNo);
DataTable dt = cmd.ExecuteDataTable();
dt.Columns.Add("ThenQty", typeof(int));
if (dt != null && dt.Rows.Count > 0)
{
// 针对一个已按 RecordTime 降序排列的货卡 List
// 该货卡长度为 M 的话，第 N (0 < N <= M) 个货卡的 ThenQty 值就等于
// 第 N + 1 个货卡的 ThenQty 与第 N 个货卡的 AffectQty 之和
// 而第 M 个货卡的 ThenQty 则等于 0 与第 M 个货卡的 AffectQty 之和
for (int then = 0, i = dt.Rows.Count - 1; i > -1; --i)
{
then += Convert.ToInt32(dt.Rows[i]["AffectQty"]);
dt.Rows[i]["ThenQty"] = then;
}
}
return(dt);
}
public AdvertisingInfo Load(int sysNo)
{
AdvertisingInfo info = null;
DataCommand cmd = DataCommandManager.GetDataCommand("LoadAdInfo");
cmd.SetParameterValue("@SysNo", sysNo);
EnumColumnList enumList = new EnumColumnList();
enumList.Add("Type", typeof(AdvertisingType));
enumList.Add("Status", typeof(ValidStatus));
DataTable dtMaster = cmd.ExecuteDataTable(enumList);
if (dtMaster == null || dtMaster.Rows.Count == 0)
{
return(null);
}
info = DataMapper.GetEntity <AdvertisingInfo>(dtMaster.Rows[0], null);
return(info);
}
public static OnlineList Insert(OnlineList entity)
{
DataCommand command = DataCommandManager.GetDataCommand("InsertOnlineList");
command.SetParameterValue("@OnlineListlocationSysNo", entity.OnlineLocationSysNo);
command.SetParameterValue("@ProductID", entity.ProductID);
command.SetParameterValue("@Priority", entity.Priority);
command.SetParameterValue("@BeginDate", DateTime.Now);
command.SetParameterValue("@EndDate", DateTime.Now.AddDays(1));
command.SetParameterValue("@InDate", DateTime.Now);
command.SetParameterValue("@InUser", "System");
command.SetParameterValue("@EditDate", DateTime.Now);
command.SetParameterValue("@EditUser", "System");
command.SetParameterValue("@Status", "A");
command.SetParameterValue("@CompanyCode", CompanyCode);
command.SetParameterValue("@LanguageCode", LanguageCode);
command.SetParameterValue("@StoreCompanyCode", CompanyCode);
command.ExecuteNonQuery();
entity.SysNo = (int)command.GetParameterValue("@SysNo");
return(entity);
}
/// <summary>
/// 设置产品讨论回复的状态
/// </summary>
/// <param name="itemID"></param>
/// <param name="status"></param>
public void BatchSetProductDiscussReplyStatus(List <int> items, string status)
{
foreach (int sysNo in items)
{
DataCommand dc = DataCommandManager.GetDataCommand("ProductDiscuss_UpdateProductDiscussStatusForUpdateReplyStatus");
dc.SetParameterValue("@SysNo", sysNo);
dc.SetParameterValue("@Status", status);
dc.SetParameterValueAsCurrentUserAcct("EditUser");
dc.ExecuteNonQuery();
}
//StringBuilder message = new StringBuilder();
//foreach (var i in items)
//{
// message.Append(i.ToString() + ",");
//}
//DataCommand dc = DataCommandManager.GetDataCommand("ProductDiscuss_BatchUpdateProductDiscussReplyStatus");
//dc.SetParameterValue("@SysNoString", message.ToString().TrimEnd(','));
//dc.SetParameterValue("@Status", status);
//dc.SetParameterValueAsCurrentUserAcct("EditUser");
//dc.ExecuteNonQuery();
}
public SOInstallmentInfo UpdateSOInstallmentWithoutCreditCardInfo(SOInstallmentInfo entity)
{
DataCommand dc = DataCommandManager.GetDataCommand("UpdateSOInstallmentWithoutCreditCardInfo");
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SOSysNo", entity.SOSysNo);
dc.SetParameterValue("@BankSysNo", entity.BankSysNo);
dc.SetParameterValue("@PhaseCount", entity.PhaseCount);
dc.SetParameterValue("@Status", entity.Status);
dc.SetParameterValue("@ContractNumber", entity.ContractNumber);
dc.SetParameterValue("@RealName", entity.RealName);
dc.SetParameterValue("@CreditCardNumber", entity.CreditCardNumber);
dc.SetParameterValue("@CreditCardNumberEnc", entity.CreditCardNumberEnc);
dc.SetParameterValue("@IDNumber", entity.IDNumber);
dc.SetParameterValue("@ExpireDate", entity.ExpireDate);
dc.SetParameterValue("@InUser", entity.InUser);
dc.SetParameterValue("@EditUser", entity.EditUser);
dc.ExecuteNonQuery();
return(entity);
}
/// <summary>
/// 更新 订单更近日志
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public void UpdateSOInternalMemoInfo(SOInternalMemoInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateSO_InternalMemo");
command.SetParameterValue("@SysNo", info.SysNo);
command.SetParameterValue("@SOSysNo", info.SOSysNo);
command.SetParameterValue("@Content", info.Content);
command.SetParameterValue("@UpdateUserSysNo", info.OperatorSysNo);//处理人
command.SetParameterValue("@Status", info.Status);
command.SetParameterValue("@UpdateTime", DateTime.Now);
command.SetParameterValue("@RemindTime", info.RemindTime);
if (info.Status == SOInternalMemoStatus.Complete)
{
command.SetParameterValue("@RemindTime", DBNull.Value);
command.SetParameterValue("@UpdateTime", DBNull.Value);
}
command.SetParameterValue("@Note", info.Note);
command.SetParameterValue("@CallType", info.CallType);
command.SetParameterValue("@ResponsibleDepCode", info.DepartmentCode);
command.SetParameterValue("@Importance", info.Importance);
command.ExecuteNonQuery();
}
/// <summary>
/// 创建佣金兑现申请
/// </summary>
/// <param name="data"></param>
public static int CreateRequestToCashRecord(CommissionToCashRecordEntity recordEntity)
{
//1.创建兑现申请单
//2.修改对应的佣金结算单信息【CommissionToCashRecordSysNo，Status】
//设置命令对象信息
DataCommand command = DataCommandManager.GetDataCommand("Settled.CreateRequestToCash");
command.SetParameterValue("@UserSysNo", recordEntity.UserSysNo);
command.SetParameterValue("@Status", recordEntity.Status);
command.SetParameterValue("@ToCashAmt", recordEntity.ToCashAmt);
command.SetParameterValue("@AfterTaxAmt", recordEntity.AfterTaxAmt);
command.SetParameterValue("@BankCode", recordEntity.BankCode);
command.SetParameterValue("@BankName", recordEntity.BankName);
command.SetParameterValue("@BranchBank", recordEntity.BranchBank);
command.SetParameterValue("@BankCardNumber", recordEntity.BankCardNumber);
command.SetParameterValue("@ReceivableName", recordEntity.ReceivableName);
command.SetParameterValue("@IsHasInvoice", recordEntity.IsHasInvoice);
command.SetParameterValue("@InUser", recordEntity.InUser);
return(command.ExecuteScalar <int>());
}
/// <summary>
/// 获取热门关键字的最大长度,根据已经存在的关键字
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool GetHotKeywordsMaxLenthBySysNo(HotSearchKeyWords item)
{
DataCommand dc = DataCommandManager.GetDataCommand("Keywords_CheckKeywordMaxLenthBySysNo");
dc.SetParameterValue <HotSearchKeyWords>(item);
DataTable dt = dc.ExecuteDataTable();
StringBuilder maxKeywords = new StringBuilder();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
maxKeywords.Append(dr[0].ToString());
}
}
maxKeywords.Append(item.Keywords.Content);
if (maxKeywords.ToString().Length > 41)
{
return(false);
}
return(true);
}
public VendorPresetContent GetVendorPresetContent()
{
var command = DataCommandManager.GetDataCommand("GetVendorPresetContent");
string configString = Convert.ToString(command.ExecuteScalar());
if (string.IsNullOrWhiteSpace(configString))
{
return(null);
}
var data = SerializationUtility.XmlDeserialize <VendorPresetContent>(configString);
data.StorePageInfos.ForEach(page =>
{
var pageTemplate = GetStorePageTemplate(page.TemplateKey, page.PageTypeKey);
if (pageTemplate != null)
{
page.DataValue = pageTemplate.DataValue;
}
});
return(data);
}
public PagedList <UserModel> GetSourceUsers(int pageIndex, int pageSize)
{
var userList = new List <UserModel>();
var count = 0;
using (var cmd = DataCommandManager.GetDataCommand("GetSourceUserByPageList"))
{
cmd.SetParameterValue("@PageIndex", pageIndex);
cmd.SetParameterValue("@PageSize", pageSize);
using (var ds = cmd.ExecuteDataSet())
{
if (ds.Tables.Count >= 2)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
var user = new UserModel();
user.UserId = !Convert.IsDBNull(dr["ID"]) ? int.Parse(dr["ID"].ToString()) : 0;
user.Mobile = !Convert.IsDBNull(dr["Mobile"]) ? dr["Mobile"].ToString() : string.Empty;
user.WxOpenId = !Convert.IsDBNull(dr["WxOpenId"]) ? dr["WxOpenId"].ToString() : string.Empty;
user.WxNickName = !Convert.IsDBNull(dr["WxNickName"]) ? dr["WxNickName"].ToString() : string.Empty;
user.WxSex = !Convert.IsDBNull(dr["WxSex"]) ? int.Parse(dr["WxSex"].ToString()) : 0;
user.WxHeadUrl = !Convert.IsDBNull(dr["WxHeadUrl"]) ? dr["WxHeadUrl"].ToString() : string.Empty;
user.WxSubTime = !Convert.IsDBNull(dr["WxSubTime"]) ? Convert.ToDateTime(dr["WxSubTime"]) : DateTime.MinValue;
user.WxUnionId = !Convert.IsDBNull(dr["WxUnionId"]) ? dr["WxUnionId"].ToString() : string.Empty;
user.WxRemark = !Convert.IsDBNull(dr["WxRemark"]) ? dr["WxRemark"].ToString() : string.Empty;
user.WxGroupId = !Convert.IsDBNull(dr["WxGroupId"]) ? int.Parse(dr["WxGroupId"].ToString()) : 0;
user.Status = !Convert.IsDBNull(dr["Status"]) ? int.Parse(dr["Status"].ToString()) : 0;
user.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue;
user.SourceCount = !Convert.IsDBNull(dr["SourceCount"]) ? int.Parse(dr["SourceCount"].ToString()) : 0;
userList.Add(user);
}
var countDr = ds.Tables[1].Rows[0][0];
count = !Convert.IsDBNull(countDr) ? Convert.ToInt32(countDr) : 0;
}
}
var result = new PagedList <UserModel>(userList, pageIndex, pageSize, count);
return(result);
}
}
public int Update(ProductInfo model)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductById"))
{
cmd.SetParameterValue("@id", model.Id);
cmd.SetParameterValue("@title", model.Title);
cmd.SetParameterValue("@cid", model.CategoryId);
cmd.SetParameterValue("@price", model.Price);
cmd.SetParameterValue("@desc", model.Desc);
cmd.SetParameterValue("@content", model.Content);
cmd.SetParameterValue("@isonline", model.IsOnline);
cmd.SetParameterValue("@bigpicture", model.BigPicture);
cmd.SetParameterValue("@smallpicture", model.SmallPicture);
cmd.SetParameterValue("@mediumpicture", model.MediumPicture);
cmd.SetParameterValue("@specifications", model.Specifications);
cmd.SetParameterValue("@afterservice", model.AfterService);
cmd.SetParameterValue("@FileUrl", model.FileUrl);
cmd.SetParameterValue("@Keywords", model.Keywords);
cmd.SetParameterValue("@MetaDesc", model.MetaDesc);
return(cmd.ExecuteNonQuery());
}
}
public PayItemStatus?GetPOPrePayItemStatus(int poSysNo)
{
PayItemStatus status;
var cmd = DataCommandManager.GetDataCommand("GetPOPrepay");
cmd.SetParameterValue("@PoSysNO", poSysNo);
DataTable dt = cmd.ExecuteDataTable();
if (null != dt && dt.Rows.Count > 0)
{
if (!Enum.TryParse <PayItemStatus>(dt.Rows[0]["Status"].ToString(), out status))
{
return(null);
}
return(status);
}
else
{
return(null);
}
}
/// <summary>
/// 根据讨论论编号，加载相应的讨论回复
/// </summary>
/// <param name="sysNo">The system no.</param>
/// <returns></returns>
public static List <ProductReviewReplyInfo> GetProductReviewReplyList(int sysNo)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("ProductReview_GetProductReviewReplyList");
dataCommand.SetParameterValue("@ReviewSysNo", sysNo);
CodeNamePairColumnList pairList = new CodeNamePairColumnList();
pairList.Add("Status", "MKT", "ReplyStatus"); //评论状态
pairList.Add("Type", "MKT", "ReplySource"); //回复类型
DataTable dataTable = dataCommand.ExecuteDataTable(pairList);
List <ProductReviewReplyInfo> list = new List <ProductReviewReplyInfo>();
foreach (DataRow row in dataTable.Rows)
{
list.Add(DataMapper.GetEntity <ProductReviewReplyInfo>(row));
}
return(list);
}
public static PurchaseOrderItemInfo UpdatePOItem(PurchaseOrderItemInfo entity)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdatePOItem");
command.SetParameterValue("@SysNo", entity.ItemSysNo.Value);
command.SetParameterValue("@POSysNo", entity.POSysNo);
command.SetParameterValue("@ProductSysNo", entity.ProductSysNo);
command.SetParameterValue("@BriefName", entity.BriefName);
command.SetParameterValue("@Quantity", entity.Quantity);
command.SetParameterValue("@Weight", entity.Weight);
command.SetParameterValue("@OrderPrice", entity.OrderPrice);
command.SetParameterValue("@ApportionAddOn", entity.ApportionAddOn);
command.SetParameterValue("@UnitCost", entity.UnitCost);
command.SetParameterValue("@ReturnCost", entity.ReturnCost);
command.SetParameterValue("@PurchaseQty", entity.PurchaseQty.Value);
command.SetParameterValue("@CurrencySysNo", entity.CurrencyCode);
command.SetParameterValue("@ExecptStatus", entity.ExecptStatus);
command.SetParameterValue("@UnitCostWithoutTax", entity.UnitCostWithoutTax);
command.SetParameterValue("@AvailableQty", entity.AvailableQty);
command.SetParameterValue("@m1", entity.M1);
command.SetParameterValue("@CurrentUnitCost", entity.UnitCost);
command.SetParameterValue("@CurrentPrice", entity.OrderPrice);
command.SetParameterValue("@LastAdjustPriceDate", entity.LastAdjustPriceDate);
command.SetParameterValue("@LastInTime", entity.LastInTime);
command.SetParameterValue("@lastOrderPrice", entity.LastOrderPrice);
if (command.ExecuteNonQuery() <= 0)
{
return(null);
}
return(entity);
}
public int Insert(User user)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertUser"))
{
cmd.SetParameterValue("@UserId", user.UserId);
cmd.SetParameterValue("@NickName", user.NickName);
cmd.SetParameterValue("@Name", user.Name);
cmd.SetParameterValue("@Password", user.Password);
cmd.SetParameterValue("@Sex", user.Sex);
cmd.SetParameterValue("@Cellphone", user.Cellphone);
cmd.SetParameterValue("@Telephone", user.Telephone);
cmd.SetParameterValue("@Email", user.Email);
cmd.SetParameterValue("@Activity", user.Activity);
cmd.SetParameterValue("@Address", user.Address);
cmd.SetParameterValue("@QQ", user.QQ);
cmd.SetParameterValue("@Fax", user.Fax);
cmd.SetParameterValue("@Postcode", user.Postcode);
cmd.SetParameterValue("@InUserId", user.InUserId);
cmd.SetParameterValue("@InDate", user.InDate);
cmd.SetParameterValue("@EditUserId", user.EditUserId);
cmd.SetParameterValue("@EditDate", user.EditDate);
cmd.SetParameterValue("@Enabled", user.Enabled);
cmd.SetParameterValue("@FirstVisit", user.FirstVisit);
cmd.SetParameterValue("@PreviousVisit", user.PreviousVisit);
cmd.SetParameterValue("@LastVisit", user.LastVisit);
cmd.SetParameterValue("@Question", user.Question);
cmd.SetParameterValue("@Answer", user.Answer);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return(user.UserId);
}
return(result);
// if (result != null)
// return Convert.ToInt32(result);
//return -1;
}
}
public DataTable QueryRmaPolicy(RmaPolicyQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryRmaPolicy");
cmd.SetParameterValue("@RmaStatus", query.Status);
cmd.SetParameterValue("@RmaType", query.Type);
cmd.SetParameterValue("@CreateUserName", query.CreateUserName);
cmd.SetParameterValue("@SysNo", query.SysNo);
cmd.SetParameterValue("@pageIndex", query.PagingInfo.PageIndex);
cmd.SetParameterValue("@pageSize", query.PagingInfo.PageSize);
cmd.SetParameterValue("@sortField", query.PagingInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(RmaPolicyStatus) },
{ "Type", typeof(RmaPolicyType) },
{ "IsOnlineRequst", typeof(IsOnlineRequst) },
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@totalCount");
return(dt);
}
public CostChangeInfo CreateCostChange(CostChangeInfo costChangeInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("CreateCostChange");
command.SetParameterValue("@VendorSysNo", costChangeInfo.CostChangeBasicInfo.VendorSysNo);
command.SetParameterValue("@PMSysNo", costChangeInfo.CostChangeBasicInfo.PMSysNo);
command.SetParameterValue("@Status", (int)costChangeInfo.CostChangeBasicInfo.Status);
command.SetParameterValue("@Memo", costChangeInfo.CostChangeBasicInfo.Memo);
command.SetParameterValue("@InUser", costChangeInfo.CostChangeBasicInfo.InUser);
command.SetParameterValue("@TotalDiffAmt", costChangeInfo.CostChangeBasicInfo.TotalDiffAmt);
command.SetParameterValue("@CompanyCode", "8601");
costChangeInfo.SysNo = Convert.ToInt32(command.ExecuteScalar());
if (costChangeInfo.CostChangeItems != null && costChangeInfo.CostChangeItems.Count > 0)
{
foreach (CostChangeItemsInfo item in costChangeInfo.CostChangeItems)
{
CreateCostChangeItemInfo(item, costChangeInfo.SysNo.Value);
}
}
return(costChangeInfo);
}
public static void CreateRefundBankInfo(SOIncomeRefundInfo refundInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("CreateRMARefundBankInfo");
command.SetParameterValue("@OrderType", refundInfo.OrderType);
command.SetParameterValue("@OrderSysNo", refundInfo.OrderSysNo);
command.SetParameterValue("@SOSysNo", refundInfo.SOSysNo);
command.SetParameterValue("@BankName", refundInfo.BankName);
command.SetParameterValue("@CardNumber", refundInfo.CardNumber);
command.SetParameterValue("@CardOwnerName", refundInfo.CardOwnerName);
command.SetParameterValue("@RefundPayType", refundInfo.RefundPayType);
command.SetParameterValue("@CreateUserSysNo", refundInfo.CreateUserSysNo);
command.SetParameterValue("@CreateUserName", refundInfo.CreateUserName);
command.SetParameterValue("@Status", refundInfo.Status);
command.SetParameterValue("@HaveAutoRMA", refundInfo.HaveAutoRMA == true ? 1 : 0);
command.SetParameterValue("@RefundCashAmt", refundInfo.RefundCashAmt);
command.SetParameterValue("@RefundPoint", refundInfo.RefundPoint);
command.SetParameterValue("@RefundGiftCard", refundInfo.RefundGiftCard);
command.SetParameterValue("@CompanyCode", refundInfo.CompanyCode);
command.SetParameterValue("@LanguageCode", refundInfo.LanguageCode);
command.SetParameterValue("@StoreCompanyCode", refundInfo.CompanyCode);
command.ExecuteNonQuery();
}
