public static List <StorageDoc> GetStorageDocList(string userid, EnumDocType type, EnumDocStatus status, string keywords, string begintime, string endtime, string wareid, string providerid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
{
DataSet ds = StockDAL.GetStorageDocList(userid, (int)type, (int)status, keywords, begintime, endtime, wareid, providerid, pageSize, pageIndex, ref totalCount, ref pageCount, clientID);
List <StorageDoc> list = new List <StorageDoc>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
StorageDoc model = new StorageDoc();
model.FillData(dr);
model.UserName = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientID).Name;
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
model.Details = new List <StorageDetail>();
if (ds.Tables.Contains("Details"))
{
foreach (DataRow detail in ds.Tables["Details"].Select("DocID='" + model.DocID + "'"))
{
StorageDetail dModel = new StorageDetail();
dModel.FillData(detail);
if ((int)type == 3 || (int)type == 4)
{
if (!string.IsNullOrEmpty(dModel.DepotID) && !string.IsNullOrEmpty(dModel.WareID))
{
dModel.DepotCode = SystemBusiness.BaseBusiness.GetDepotByID(dModel.DepotID, dModel.WareID, clientID).DepotCode;
}
}
model.Details.Add(dModel);
}
}
list.Add(model);
}
return(list);
}
public static List <StorageDoc> GetStorageDocDetails(string docid, string clientid)
{
DataSet ds = StockDAL.BaseProvider.GetStorageDocDetails(docid);
List <StorageDoc> list = new List <StorageDoc>();
foreach (DataRow dr in ds.Tables["Doc"].Rows)
{
StorageDoc model = new StorageDoc();
model.FillData(dr);
List <StorageDetail> details = new List <StorageDetail>();
foreach (DataRow detailDR in ds.Tables["Details"].Select("DocID = '" + model.DocID + "'"))
{
StorageDetail detail = new StorageDetail();
detail.FillData(detailDR);
details.Add(detail);
}
model.Details = details;
var user = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid);
model.UserName = user != null ? user.Name : "";
list.Add(model);
}
return(list);
}
public List <StorageBilling> GetPayableBills(int paystatus, int invoicestatus, string begintime, string endtime, string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string clientid)
{
List <StorageBilling> list = new List <StorageBilling>();
DataSet ds = FinanceDAL.BaseProvider.GetPayableBills(paystatus, invoicestatus, begintime, endtime, keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, userid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
StorageBilling model = new StorageBilling();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid);
model.PayStatusStr = model.PayStatus == 0 ? "未付款"
: model.PayStatus == 1 ? "部分付款"
: model.PayStatus == 2 ? "已付款"
: model.PayStatus == 9 ? "已删除"
: "";
model.InvoiceStatusStr = model.InvoiceStatus == 0 ? "未开票"
: model.InvoiceStatus == 1 ? "部分开票"
: model.InvoiceStatus == 2 ? "已开票"
: model.InvoiceStatus == 9 ? "已删除"
: "";
list.Add(model);
}
return(list);
}
public OrderStageEntity GetOrderStageByID(string stageid, string processid, string clientid)
{
if (string.IsNullOrEmpty(stageid) || string.IsNullOrEmpty(processid))
{
return(null);
}
var list = GetOrderStages(processid, clientid);
if (list.Where(m => m.StageID == stageid).Count() > 0)
{
return(list.Where(m => m.StageID == stageid).FirstOrDefault());
}
OrderStageEntity model = new OrderStageEntity();
DataSet ds = SystemDAL.BaseProvider.GetOrderStageByID(stageid);
if (ds.Tables["Stages"].Rows.Count > 0)
{
model.FillData(ds.Tables["Stages"].Rows[0]);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, clientid);
model.StageItem = new List <StageItemEntity>();
foreach (DataRow itemdr in ds.Tables["Items"].Rows)
{
StageItemEntity item = new StageItemEntity();
item.FillData(itemdr);
model.StageItem.Add(item);
}
OrderStages[clientid].Add(model);
}
return(model);
}
public List <OrderStageEntity> GetOrderStages(string processid, string clientid)
{
if (OrderStages.ContainsKey(processid))
{
return(OrderStages[processid].OrderBy(m => m.Sort).ToList());
}
var model = GetOrderProcessByID(processid, clientid);
List <OrderStageEntity> list = new List <OrderStageEntity>();
DataSet ds = SystemDAL.BaseProvider.GetOrderStages(processid);
foreach (DataRow dr in ds.Tables["Stages"].Rows)
{
OrderStageEntity item = new OrderStageEntity();
item.FillData(dr);
item.MarkEntity = GetCategoryItemByMark(model.CategoryID, item.Mark, clientid);
item.Owner = OrganizationBusiness.GetUserByUserID(item.OwnerID, clientid);
list.Add(item);
}
OrderStages.Add(processid, list);
return(list);
}
public bool UpdateCustomerOwner(string customerid, string userid, string operateid, string ip, string clientid)
{
bool bl = CustomDAL.BaseProvider.UpdateCustomerOwner(customerid, userid, operateid, clientid);
if (bl)
{
var model = OrganizationBusiness.GetUserByUserID(userid, clientid);
string msg = "客户负责人更换为：" + model.Name;
LogBusiness.AddLog(customerid, EnumLogObjectType.Customer, msg, operateid, ip, userid, clientid);
}
return(bl);
}
/// <summary>
/// 修改任务负责人
/// </summary>
/// <param name="taskID"></param>
/// <param name="OwnerID"></param>
/// <returns></returns>
public static bool UpdateTaskOwner(string taskID, string ownerID, string operateid, string operateName, string ip, string clientid, out int result)
{
bool flag = TaskDAL.BaseProvider.UpdateTaskOwner(taskID, ownerID, out result);
if (flag)
{
var user = OrganizationBusiness.GetUserByUserID(ownerID, clientid);
string msg = "将任务负责人更改为:" + (user != null?user.Name:ownerID);
LogBusiness.AddLog(taskID, EnumLogObjectType.OrderTask, msg, operateid, ip, "", clientid);
//任务更换负责人推送通知
WeiXinMPPush.BasePush.SendChangeTaskOwnerPush(taskID, operateName);
}
return(flag);
}
/// <summary>
/// 移除任务成员
/// </summary>
/// <param name="taskID"></param>
/// <param name="memberID"></param>
/// <param name="operateid"></param>
/// <param name="ip"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public static bool RemoveTaskMember(string taskID, string memberID, string operateid, string ip, string clientid)
{
bool flag = TaskDAL.BaseProvider.RemoveTaskMember(taskID, memberID);
if (flag)
{
var userName = string.Empty;
var user = OrganizationBusiness.GetUserByUserID(memberID, clientid);
userName += user != null ? user.Name : "";
string msg = "删除任务成员" + userName.Trim(',');
LogBusiness.AddLog(taskID, EnumLogObjectType.OrderTask, msg, operateid, ip, "", clientid);
}
return(flag);
}
public List <ClientAccountsEntity> GetAccountBills(int mark, string begintime, string endtime, string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string clientid)
{
List <ClientAccountsEntity> list = new List <ClientAccountsEntity>();
DataSet ds = FinanceDAL.BaseProvider.GetAccountBills(mark, begintime, endtime, keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, userid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ClientAccountsEntity model = new ClientAccountsEntity();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
list.Add(model);
}
return(list);
}
public CustomerEntity GetCustomerByID(string customerid, string clientid)
{
DataSet ds = CustomDAL.BaseProvider.GetCustomerByID(customerid, clientid);
CustomerEntity model = new CustomerEntity();
if (ds.Tables["Customer"].Rows.Count > 0)
{
model.FillData(ds.Tables["Customer"].Rows[0]);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.ClientID);
model.City = CommonBusiness.Citys.Where(m => m.CityCode == model.CityCode).FirstOrDefault();
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
}
return(model);
}
public List <BillingPay> GetOrderPays(string orderid)
{
List <BillingPay> list = new List <BillingPay>();
DataTable dt = FinanceDAL.BaseProvider.GetOrderPays(orderid);
foreach (DataRow dr in dt.Rows)
{
BillingPay model = new BillingPay();
model.FillData(dr);
model.PayTypeStr = CommonBusiness.GetEnumDesc <EnumOrderPayType>((EnumOrderPayType)model.PayType);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
list.Add(model);
}
return(list);
}
/// <summary>
/// 更新任务成员权限
/// </summary>
public static bool UpdateMemberPermission(string taskID, string memberID, TaskMemberPermissionType taskMemberPermissionType, string operateid, string ip, string clientid)
{
bool flag = TaskDAL.BaseProvider.UpdateMemberPermission(taskID, memberID, (int)taskMemberPermissionType);
if (flag)
{
var userName = string.Empty;
var user = OrganizationBusiness.GetUserByUserID(memberID, clientid);
userName += user != null ? user.Name : "";
string msg = "将任务成员" + userName.Trim(',') + "的权限更新为:" + (taskMemberPermissionType == TaskMemberPermissionType.See?"查看":"编辑");
LogBusiness.AddLog(taskID, EnumLogObjectType.OrderTask, msg, operateid, ip, "", clientid);
}
return(flag);
}
public string CreateOrderStage(string name, int sort, int mark, int hours, string pid, string processid, string userid, string clientid, out int result)
{
string stageid = Guid.NewGuid().ToString();
bool bl = SystemDAL.BaseProvider.CreateOrderStage(stageid, name, sort, mark, hours, pid, processid, userid, clientid, out result);
if (bl)
{
if (!OrderStages.ContainsKey(processid))
{
GetOrderStages(processid, clientid);
}
else
{
var list = OrderStages[processid].Where(m => m.Sort >= sort && m.Status == 1).ToList();
foreach (var model in list)
{
model.Sort += 1;
}
var Process = GetOrderProcessByID(processid, clientid);
OrderStages[processid].Add(new OrderStageEntity()
{
StageID = stageid.ToLower(),
StageName = name,
Sort = sort,
PID = pid,
Mark = mark,
MaxHours = hours,
MarkEntity = GetCategoryItemByMark(Process.CategoryID, mark, clientid),
Status = 1,
CreateTime = DateTime.Now,
ProcessID = processid,
OwnerID = userid,
StageItem = new List <StageItemEntity>(),
Owner = OrganizationBusiness.GetUserByUserID(userid, clientid),
ClientID = clientid
});
}
return(stageid);
}
return("");
}
public List <ContactEntity> GetContactsByCustomerID(string customerid, string clientid)
{
List <ContactEntity> list = new List <ContactEntity>();
DataTable dt = CustomDAL.BaseProvider.GetContactsByCustomerID(customerid);
foreach (DataRow dr in dt.Rows)
{
ContactEntity model = new ContactEntity();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
model.City = CommonBusiness.Citys.Where(m => m.CityCode == model.CityCode).FirstOrDefault();
list.Add(model);
}
return(list);
}
public bool UpdateOrderStageOwner(string stageid, string processid, string ownerid, string userid, string ip, string clientid)
{
var model = GetOrderStageByID(stageid, processid, clientid);
if (ownerid == model.OwnerID)
{
return(true);
}
bool bl = SystemDAL.BaseProvider.UpdateOrderStageOwner(stageid, ownerid);
if (bl)
{
model.OwnerID = ownerid;
model.Owner = OrganizationBusiness.GetUserByUserID(ownerid, clientid);
}
return(bl);
}
public List <CustomerEntity> GetCustomers(EnumSearchType searchtype, int type, int sourcetype, string sourceid, string stageid, int status, int mark, string searchuserid, string searchteamid,
string begintime, string endtime, string firstname, string keyWords, string orderBy, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string clientid)
{
List <CustomerEntity> list = new List <CustomerEntity>();
DataSet ds = CustomDAL.BaseProvider.GetCustomers((int)searchtype, type, sourcetype, sourceid, stageid, status, mark, searchuserid, searchteamid, begintime, endtime, firstname, keyWords, orderBy, pageSize, pageIndex, ref totalCount, ref pageCount, userid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
CustomerEntity model = new CustomerEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.ClientID);
model.City = CommonBusiness.Citys.Where(m => m.CityCode == model.CityCode).FirstOrDefault();
list.Add(model);
}
return(list);
}
/// <summary>
/// 批量添加任务成员
/// </summary>
/// <param name="taskID"></param>
/// <param name="memberIDs"></param>
/// <param name="operateid"></param>
/// <param name="ip"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public static bool AddTaskMembers(string taskID, string memberIDs, string operateid, string ip, string clientid, out int result)
{
memberIDs = memberIDs.Trim(',');
bool flag = TaskDAL.BaseProvider.AddTaskMembers(taskID, memberIDs, operateid, out result);
if (flag)
{
var userName = string.Empty;
foreach (var m in memberIDs.Split(','))
{
var user = OrganizationBusiness.GetUserByUserID(m, clientid);
userName += (user != null ? user.Name : "") + ",";
}
string msg = "添加任务成员" + userName.Trim(',');
LogBusiness.AddLog(taskID, EnumLogObjectType.OrderTask, msg, operateid, ip, "", clientid);
}
return(flag);
}
public static bool UpdateAccountBindMobile(string mobile, string pwd, bool isFirst, string userid, string clientid)
{
string loginpwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, pwd);
bool flag = OrganizationDAL.BaseProvider.AccountBindMobile(userid, mobile, isFirst, loginpwd, clientid);
//清除缓存
if (flag)
{
Users u = OrganizationBusiness.GetUserByUserID(userid, clientid);
u.MobilePhone = mobile;
if (isFirst)
{
var client = Manage.ClientBusiness.GetClientDetail(clientid);
client.MobilePhone = mobile;
client.GuideStep = 0;
}
}
return(flag);
}
public static StorageDoc GetStorageDetail(string docid, string clientid)
{
DataSet ds = StockDAL.GetStorageDetail(docid, clientid);
StorageDoc model = new StorageDoc();
if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0)
{
model.FillData(ds.Tables["Doc"].Rows[0]);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
model.DocTypeStr = CommonBusiness.GetEnumDesc <EnumDocType>((EnumDocType)model.DocType);
if (!string.IsNullOrEmpty(model.ExpressID))
{
model.Express = ExpressCompanyBusiness.GetExpressCompanyDetail(model.ExpressID);
}
model.WareHouse = SystemBusiness.BaseBusiness.GetWareByID(model.WareID, model.ClientID);
model.Details = new List <StorageDetail>();
foreach (DataRow item in ds.Tables["Details"].Rows)
{
StorageDetail details = new StorageDetail();
details.FillData(item);
if (!string.IsNullOrEmpty(details.UnitID))
{
details.UnitName = new ProductsBusiness().GetUnitByID(details.UnitID).UnitName;
}
if (!string.IsNullOrEmpty(details.ProviderID))
{
details.Providers = new ProvidersBusiness().GetProviderByID(details.ProviderID);
}
model.Details.Add(details);
}
}
return(model);
}
public bool UpdateUserTeamID(string userid, string teamid, string operateid, string ip, string clientid)
{
bool bl = SystemDAL.BaseProvider.UpdateUserTeamID(userid, teamid, operateid);
if (bl)
{
var model = OrganizationBusiness.GetUserByUserID(userid, clientid);
if (string.IsNullOrEmpty(teamid))
{
var team = GetTeamByID(model.TeamID, clientid);
var user = team.Users.Where(m => m.UserID == userid).FirstOrDefault();
team.Users.Remove(user);
}
else
{
var team = GetTeamByID(teamid, clientid);
team.Users.Add(model);
}
model.TeamID = teamid;
}
return(bl);
}
public StorageBilling GetPayableBillByID(string billingid, string clientid)
{
StorageBilling model = new StorageBilling();
DataSet ds = FinanceDAL.BaseProvider.GetPayableBillByID(billingid, clientid);
if (ds.Tables["Billing"].Rows.Count > 0)
{
model.FillData(ds.Tables["Billing"].Rows[0]);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid);
model.PayStatusStr = model.PayStatus == 0 ? "未付款"
: model.PayStatus == 1 ? "部分付款"
: model.PayStatus == 2 ? "已付款"
: model.PayStatus == 9 ? "已删除"
: "";
model.InvoiceStatusStr = model.InvoiceStatus == 0 ? "未开票"
: model.InvoiceStatus == 1 ? "部分开票"
: model.InvoiceStatus == 2 ? "已开票"
: model.InvoiceStatus == 9 ? "已删除"
: "";
model.StorageBillingPays = new List <StorageBillingPay>();
foreach (DataRow dr in ds.Tables["Pays"].Rows)
{
StorageBillingPay pay = new StorageBillingPay();
pay.FillData(dr);
switch (pay.PayType)
{
case 1:
pay.PayTypeStr = "现金支付";
break;
case 2:
pay.PayTypeStr = "在线支付";
break;
case 3:
pay.PayTypeStr = "支付宝";
break;
case 4:
pay.PayTypeStr = "微信";
break;
case 5:
pay.PayTypeStr = "线下汇款";
break;
}
pay.CreateUser = OrganizationBusiness.GetUserByUserID(pay.CreateUserID, clientid);
model.StorageBillingPays.Add(pay);
}
model.StorageBillingInvoices = new List <StorageBillingInvoice>();
foreach (DataRow dr in ds.Tables["Invoices"].Rows)
{
StorageBillingInvoice invoice = new StorageBillingInvoice();
invoice.FillData(dr);
invoice.CreateUser = OrganizationBusiness.GetUserByUserID(invoice.CreateUserID, clientid);
model.StorageBillingInvoices.Add(invoice);
}
}
return(model);
}
