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