/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
SalesorderBasicInfoModel salesorderbasicinfo = new SalesorderBasicInfoModel();
ret = DbUtil.Current.DeleteMultiple(salesorderbasicinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="salesorderbasicinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(SalesorderBasicInfoModel salesorderbasicinfo, ParameterCollection pc)
{
int ret = 0;
salesorderbasicinfo.ModifiedBy = SessionUtil.Current.UserId;
salesorderbasicinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(salesorderbasicinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="salesorderbasicinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(SalesorderBasicInfoModel salesorderbasicinfo)
{
int ret = 0;
salesorderbasicinfo.ModifiedBy = SessionUtil.Current.UserId;
salesorderbasicinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(salesorderbasicinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="salesorderid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string salesorderid)
{
int ret = 0;
SalesorderBasicInfoModel salesorderbasicinfo = new SalesorderBasicInfoModel();
salesorderbasicinfo.SalesorderId = salesorderid;
ret = DbUtil.Current.Delete(salesorderbasicinfo);
return(ret);
}
/// <summary>
/// 从数据库中获取销售订单领域模型。
/// </summary>
/// <param name="salesOrderId"></param>
/// <returns></returns>
public SalesOrderDomainModel GetSalesorderDomainModelByIdFromDatabse(string salesOrderId)
{
SalesOrderDomainModel model = null;
SalesorderBasicInfoModel SalesorderBasicInfo = SalesorderBasicInfoService.Instance.Retrieve(salesOrderId);
if (SalesorderBasicInfo == null)
{
return(null);
}
model = new SalesOrderDomainModel();
model.BasicInfo = SalesorderBasicInfo;
model.ProductList = new Dictionary <string, SalesorderProductInfoModel>();
model.CommuniationPackageList = new Dictionary <string, SalesorderCommuniationpackageInfoModel>();
model.ProcessLogs = new Dictionary <string, SalesorderProcessLogModel>();
ParameterCollection pc = new ParameterCollection();
pc.Add("salesorder_id", SalesorderBasicInfo.SalesorderId);
List <SalesorderProductInfoModel> list = SalesorderProductInfoService.Instance.RetrieveMultiple(pc, OrderByCollection.Create("created_on", "desc"));
if (list != null)
{
foreach (SalesorderProductInfoModel item in list)
{
model.ProductList[item.ProductName] = item;
}
}
List <SalesorderCommuniationpackageInfoModel> CommuniationList = SalesorderCommuniationpackageInfoService.Instance.RetrieveMultiple(pc, OrderByCollection.Create("created_on", "desc"));
if (CommuniationList != null)
{
foreach (SalesorderCommuniationpackageInfoModel CommuniationPackageList in CommuniationList)
{
model.CommuniationPackageList[CommuniationPackageList.BindCommuniationpackageId] = CommuniationPackageList;
}
}
List <SalesorderProcessLogModel> ProcessLogModel = SalesorderProcessLogService.Instance.RetrieveMultiple(pc, OrderByCollection.Create("created_on", "desc"));
if (ProcessLogModel != null)
{
foreach (SalesorderProcessLogModel ProcessLogsList in ProcessLogModel)
{
model.ProcessLogs[ProcessLogsList.SalesorderProcessId] = ProcessLogsList;
}
}
return(model);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <SalesorderBasicInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <SalesorderBasicInfoModel> salesorderbasicinfos = new List <SalesorderBasicInfoModel>();
SalesorderBasicInfoModel salesorderbasicinfo = new SalesorderBasicInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(salesorderbasicinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
salesorderbasicinfo = new SalesorderBasicInfoModel();
salesorderbasicinfo.ConvertFrom(dt, i);
salesorderbasicinfos.Add(salesorderbasicinfo);
}
return(salesorderbasicinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="salesorderid"></param>
/// <returns>实体</returns>
public SalesorderBasicInfoModel Retrieve(string salesorderid)
{
SalesorderBasicInfoModel salesorderbasicinfo = new SalesorderBasicInfoModel();
salesorderbasicinfo.SalesorderId = salesorderid;
DataTable dt = DbUtil.Current.Retrieve(salesorderbasicinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
salesorderbasicinfo.ConvertFrom(dt);
return(salesorderbasicinfo);
}
/// <summary>
/// 修改订单状态。
/// </summary>
/// <param name="statusInfo"></param>
/// <returns></returns>
public bool UpdateSalesorderOrderstatus(SalesorderBasicInfoModel model, out string message)
{
message = "操作失败，请与管理员联系";
bool result = false;
string UpdateSalesorderOrderstatus = "UPDATE salesorder_basic_info SET now_order_status_id = $now_order_status_id$ WHERE salesorder_id = $salesorder_id$";
ParameterCollection pc = new ParameterCollection();
pc.Add("now_order_status_id", model.NowOrderStatusId);
pc.Add("salesorder_id", model.SalesorderId);
if (ExecuteNonQuery(UpdateSalesorderOrderstatus, pc) != 1)
{
message = "操作失败，请与管理员联系";
return(false);
}
else
{
result = true;
message = "修改成功";
GetSalesorderDomainModelById(model.NowOrderStatusId, true);
}
return(result);
}
