public static List <GoodsDoc> GetGoodsDocByOrderID(string orderid, string taskid, EnumDocType type, string clientid)
{
DataSet ds = StockDAL.BaseProvider.GetGoodsDocByOrderID(orderid, taskid, (int)type, clientid);
List <GoodsDoc> list = new List <GoodsDoc>();
foreach (DataRow dr in ds.Tables["Doc"].Rows)
{
GoodsDoc model = new GoodsDoc();
model.FillData(dr);
if (!string.IsNullOrEmpty(model.ExpressID))
{
model.Express = ExpressCompanyBusiness.GetExpressCompanyDetail(model.ExpressID);
}
model.CreateUser = OrganizationBusiness.GetUserCacheByUserID(model.CreateUserID, clientid);
if (!string.IsNullOrEmpty(model.OwnerID))
{
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, clientid);
}
model.Details = new List <GoodsDocDetail>();
if (ds.Tables.Contains("Details"))
{
foreach (DataRow detail in ds.Tables["Details"].Select("DocID='" + model.DocID + "'"))
{
GoodsDocDetail goodsDetailModel = new GoodsDocDetail();
goodsDetailModel.FillData(detail);
model.Details.Add(goodsDetailModel);
}
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 获取日志
/// </summary>
/// <returns></returns>
public static List <LogEntity> GetLogs(string guid, EnumLogObjectType type, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientid)
{
string tablename = "";
switch (type)
{
case EnumLogObjectType.Customer:
tablename = "CustomerLog";
break;
case EnumLogObjectType.Orders:
tablename = "OrdersLog";
break;
case EnumLogObjectType.OrderTask:
tablename = "OrderTaskLog";
break;
}
DataTable dt = CommonBusiness.GetPagerData(tablename, "*", "LogGUID='" + guid + "'", "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <LogEntity> list = new List <LogEntity>();
foreach (DataRow dr in dt.Rows)
{
LogEntity model = new LogEntity();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserCacheByUserID(model.CreateUserID, clientid);
list.Add(model);
}
return(list);
}
public static GoodsDoc GetGoodsDocDetail(string docid, string clientid)
{
DataSet ds = StockDAL.GetGoodsDocDetail(docid, clientid);
GoodsDoc model = new GoodsDoc();
if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0)
{
model.FillData(ds.Tables["Doc"].Rows[0]);
model.CreateUser = OrganizationBusiness.GetUserCacheByUserID(model.CreateUserID, clientid);
model.DocTypeStr = CommonBusiness.GetEnumDesc <EnumGoodsDocType>((EnumGoodsDocType)model.DocType);
if (!string.IsNullOrEmpty(model.ExpressID))
{
model.Express = ExpressCompanyBusiness.GetExpressCompanyDetail(model.ExpressID);
}
model.Details = new List <GoodsDocDetail>();
foreach (DataRow item in ds.Tables["Details"].Rows)
{
GoodsDocDetail details = new GoodsDocDetail();
details.FillData(item);
model.Details.Add(details);
}
}
return(model);
}
public static List <ReplyEntity> GetTaskReplys(string guid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
List <ReplyEntity> list = new List <ReplyEntity>();
DataSet ds = ReplyDAL.BaseProvider.GetTaskReplys(guid, pageSize, pageIndex, ref totalCount, ref pageCount);
DataTable replys = ds.Tables["Replys"];
DataTable attachments = ds.Tables["Attachments"];
foreach (DataRow dr in replys.Rows)
{
ReplyEntity model = new ReplyEntity();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserCacheByUserID(model.CreateUserID, model.ClientID);
if (!string.IsNullOrEmpty(model.FromReplyID))
{
model.FromReplyUser = OrganizationBusiness.GetUserCacheByUserID(model.FromReplyUserID, model.FromReplyAgentID);
}
model.Attachments = new List <Attachment>();
if (attachments.Rows.Count > 0)
{
foreach (DataRow dr2 in attachments.Select(" Guid='" + model.ReplyID + "'"))
{
Attachment attachment = new Attachment();
attachment.FillData(dr2);
model.Attachments.Add(attachment);
}
}
list.Add(model);
}
return(list);
}
public static List <TaskEntity> GetTasksByEndTime(string startEndTime, string endEndTime,
int orderType, int filterType, int finishStatus, int preFinishStatus, int taskType,
string userID, string clientID, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
List <TaskEntity> list = new List <TaskEntity>();
DataSet ds = TaskDAL.BaseProvider.GetTasksByEndTime(startEndTime, endEndTime,
orderType, filterType, finishStatus, preFinishStatus, taskType,
userID, clientID, pageSize, pageIndex, ref totalCount, ref pageCount);
DataTable dt = ds.Tables["Tasks"];
DataTable orders = ds.Tables["Orders"];
foreach (DataRow dr in dt.Rows)
{
TaskEntity model = new TaskEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
if (orders.Rows.Count > 0)
{
foreach (DataRow dr2 in orders.Select(" OrderID='" + model.OrderID + "'"))
{
OrderEntity order = new OrderEntity();
order.FillData(dr2);
model.Order = order;
}
}
if (model.FinishStatus == 1)
{
if (model.EndTime <= DateTime.Now)
{
model.WarningStatus = 2;
model.WarningTime = "超期：" + (DateTime.Now - model.EndTime).Days.ToString("D2") + "天 " + (DateTime.Now - model.EndTime).Hours.ToString("D2") + "时 " + (DateTime.Now - model.EndTime).Minutes.ToString("D2") + "分";
model.WarningDays = (DateTime.Now - model.EndTime).Days;
model.UseDays = (model.EndTime - model.AcceptTime).Days;
}
else if ((model.EndTime - DateTime.Now).TotalHours * 3 < (model.EndTime - model.AcceptTime).TotalHours)
{
model.WarningStatus = 1;
model.WarningTime = "剩余：" + (model.EndTime - DateTime.Now).Days.ToString("D2") + "天 " + (model.EndTime - DateTime.Now).Hours.ToString("D2") + "时 " + (model.EndTime - DateTime.Now).Minutes.ToString("D2") + "分";
model.WarningDays = (model.EndTime - DateTime.Now).Days;
model.UseDays = (DateTime.Now - model.AcceptTime).Days;
}
else
{
model.WarningTime = "剩余：" + (model.EndTime - DateTime.Now).Days.ToString("D2") + "天 " + (model.EndTime - DateTime.Now).Hours.ToString("D2") + "时 " + (model.EndTime - DateTime.Now).Minutes.ToString("D2") + "分";
model.WarningDays = (model.EndTime - DateTime.Now).Days;
model.UseDays = (DateTime.Now - model.AcceptTime).Days;
}
}
else
{
model.WarningStatus = 3;
model.UseDays = (model.EndTime - model.AcceptTime).Days;
model.WarningDays = (DateTime.Now - model.CompleteTime).Days;
}
list.Add(model);
}
return(list);
}
public static TaskEntity GetPushTaskForFinishTask(string taskid)
{
TaskEntity model = new TaskEntity();
DataSet ds = TaskDAL.BaseProvider.GetPushTaskForFinishTask(taskid);
if (ds.Tables.Count > 0)
{
DataTable taskTB = ds.Tables["OrderTask"];
if (taskTB.Rows.Count == 1)
{
model = new TaskEntity();
model.FillData(taskTB.Rows[0]);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
}
DataTable orderTB = ds.Tables["Order"];
if (orderTB != null && orderTB.Rows.Count == 1)
{
OrderEntity order = new OrderEntity();
order.FillData(orderTB.Rows[0]);
model.Order = order;
}
}
return(model);
}
public static TaskEntity GetTaskByID(string taskid)
{
TaskEntity model = new TaskEntity();
DataTable dt = TaskDAL.BaseProvider.GetTaskByID(taskid);
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
}
return(model);
}
public List <UserWorkLoadRptEntity> GetUserLoadReport(string begintime, string endtime, string userid, string teamid, string clientid)
{
DataTable dt = UserRPTDAL.BaseProvider.GetUserLoadReport(begintime, endtime, userid, teamid, clientid);
List <UserWorkLoadRptEntity> list = new List <UserWorkLoadRptEntity>();
foreach (DataRow dr in dt.Rows)
{
UserWorkLoadRptEntity model = new UserWorkLoadRptEntity();
model.FillData(dr);
model.UserName = OrganizationBusiness.GetUserCacheByUserID(model.UserID, clientid).Name;
list.Add(model);
}
return(list);
}
public static List <TaskEntity> GetTasksByYXOrderID(string yxOrderID)
{
List <TaskEntity> list = new List <TaskEntity>();
DataTable dt = TaskDAL.BaseProvider.GetTasksByYXOrderID(yxOrderID);
foreach (DataRow dr in dt.Rows)
{
TaskEntity model = new TaskEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
list.Add(model);
}
return(list);
}
public static TaskEntity GetTaskDetail(string taskID)
{
TaskEntity model = null;
DataSet ds = TaskDAL.BaseProvider.GetTaskDetail(taskID);
DataTable taskTB = ds.Tables["OrderTask"];
if (taskTB.Rows.Count > 0)
{
model = new TaskEntity();
model.FillData(taskTB.Rows[0]);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
//成员
DataTable memberTB = ds.Tables["TaskMember"];
model.TaskMembers = new List <IntFactoryEntity.Task.TaskMember>();
if (memberTB.Rows.Count > 0)
{
foreach (DataRow m in memberTB.Rows)
{
TaskMember member = new TaskMember();
member.FillData(m);
member.Member = OrganizationBusiness.GetUserCacheByUserID(member.MemberID, model.ClientID);
model.TaskMembers.Add(member);
}
}
//订单基本信息
model.Order = new OrderEntity();
model.Order.FillData(ds.Tables["Order"].Rows[0]);
if (!string.IsNullOrEmpty(model.Order.BigCategoryID))
{
var category = SystemBusiness.BaseBusiness.GetProcessCategoryByID(model.Order.BigCategoryID);
model.Order.ProcessCategoryName = category == null ? "" : category.Name;
}
if (!string.IsNullOrEmpty(model.Order.CategoryID))
{
var category = ProductsBusiness.BaseBusiness.GetCategoryByID(model.Order.CategoryID);
var pcategory = ProductsBusiness.BaseBusiness.GetCategoryByID(category.PID);
model.Order.CategoryName = pcategory.CategoryName + " > " + category.CategoryName;
}
}
return(model);
}
public bool UpdateOrderProcessOwner(string processid, string ownerid, string userid, string ip, string clientid)
{
var model = GetOrderProcessByID(processid, clientid);
if (ownerid == model.OwnerID)
{
return(true);
}
bool bl = SystemDAL.BaseProvider.UpdateOrderProcessOwner(processid, ownerid);
if (bl)
{
model.OwnerID = ownerid;
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, clientid);
model.OwnerName = model.Owner.Name;
}
return(bl);
}
public static List <TaskEntity> GetPushTasksForNewOrder(string orderid)
{
List <TaskEntity> list = new List <TaskEntity>();
DataSet ds = TaskDAL.BaseProvider.GetPushTasksForNewOrder(orderid);
if (ds.Tables.Count > 0)
{
DataTable taskTB = ds.Tables["OrderTask"];
foreach (DataRow dr in taskTB.Rows)
{
TaskEntity model = new TaskEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
list.Add(model);
}
}
return(list);
}
public OrderProcessEntity GetOrderProcessByID(string processid, string clientid)
{
var list = GetOrderProcess(clientid);
if (list.Where(m => m.ProcessID == processid).Count() > 0)
{
return(list.Where(m => m.ProcessID == processid).FirstOrDefault());
}
OrderProcessEntity model = new OrderProcessEntity();
DataTable dt = SystemDAL.BaseProvider.GetOrderProcessByID(processid);
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, clientid);
model.OwnerName = model.Owner.Name;
model.CategoryName = GetProcessCategoryByID(model.CategoryID).Name;
list.Add(model);
}
return(model);
}
public List <OrderProcessEntity> GetOrderProcess(string clientid)
{
if (OrderProcess.ContainsKey(clientid))
{
return(OrderProcess[clientid]);
}
List <OrderProcessEntity> list = new List <OrderProcessEntity>();
DataSet ds = SystemDAL.BaseProvider.GetOrderProcess(clientid);
foreach (DataRow dr in ds.Tables["Stages"].Rows)
{
OrderProcessEntity model = new OrderProcessEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, clientid);
model.OwnerName = model.Owner.Name;
model.CategoryName = GetProcessCategoryByID(model.CategoryID).Name;
list.Add(model);
}
OrderProcess.Add(clientid, list);
return(list);
}