public Base_Sale_Manager Detail(Guid Sale_ID)
{
ProcDataAndTotal <Base_Sale_Manager> saleList = _Salebll.ProcSale("", 1, 1000);
Base_Sale_Manager base_Sale = saleList.ProcData.Where(s => s.Sale_ID == Sale_ID).FirstOrDefault();
return(base_Sale);
}
public ProcDataAndTotal <Base_Assete_Files> SelectProcData(SelectFilesClass selectmodel)
{
//页码
int pageIndex = selectmodel.PageIndex;
//查询的条件语句
string wheresql = "";
Type t = selectmodel.GetType();
PropertyInfo[] properties = t.GetProperties();
foreach (var item in properties)
{
//模糊查询
if (item.Name == "Assets_Name")
{
wheresql += $" and {item.Name} like '%'" + item.GetValue(selectmodel) + "'%'";
}
if (item.GetValue(selectmodel).ToString() != null && item.Name != "PageIndex" && item.Name != "Assets_Name")
{
wheresql += $" and {item.Name} = '{item.GetValue(selectmodel)}'";
}
}
ProcDataAndTotal <Base_Assete_Files> proc = _filesbll.ProcPageData(wheresql, pageIndex, 5);
return(proc);
}
/// <summary>
/// 显示分页存储过程
/// </summary>
/// <param name="whereStr"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ProcDataAndTotal <Base_Emp_Information> ProcPageData(string whereStr, int pageIndex, int pageSize)
{
if (whereStr != null)
{
whereStr = $" and Emp_Name like '%{whereStr}%'";
}
ProcDataAndTotal <Base_Emp_Information> list = dapper.GetProcData <Base_Emp_Information>("Base_Emp_Information", whereStr, "Entry_Time", pageIndex, pageSize);
return(list);
}
public string GetSaleManagers(int Page, int limit, string dateTimestr, string baiFang_Name, string keHu_Name, string baiFang_Type, string state)
{
//查询条件
string whereStr = "";
//按拜访名称查询
if (!string.IsNullOrEmpty(baiFang_Name))
{
whereStr += $" and Customer_Name like '%{baiFang_Name}%'";
}
//按客户名称查询
if (!string.IsNullOrEmpty(keHu_Name))
{
whereStr += $" and Customer_Name like '%{keHu_Name}%'";
}
//按拜访类型查询
if (!string.IsNullOrEmpty(baiFang_Type))
{
whereStr += $" and Visit_Type='{baiFang_Type}'";
}
//按状态查询
if (!string.IsNullOrEmpty(state))
{
whereStr += $" and Visit_State='{state}'";
}
//按时间范围查询
if (dateTimestr != null)
{
DateTime start = Convert.ToDateTime(dateTimestr.Substring(0, 10));
DateTime end = Convert.ToDateTime(dateTimestr.Substring(13, 10));
whereStr += $" and Plan_Time between '{start}' and '{end}'";
}
//获取销售管理的列表和条数
ProcDataAndTotal <Base_Sale_Manager> saleList = _Salebll.ProcSale(whereStr, Page, limit);
//循环List
foreach (var item in saleList.ProcData)
{
//计算两个时间差的值
TimeSpan timeSpan = Convert.ToDateTime(item.End_Date).Subtract(Convert.ToDateTime(item.Plan_Time));
//计算时长
item.TimeLenght = (timeSpan.Hours + (timeSpan.Days * 24)) + "小时" + timeSpan.Minutes + "分钟";
//拼接拜访名称
item.Visit_Name = item.Customer_Name + "-" + Convert.ToDateTime(item.Plan_Time).ToString("yyyyMMdd");
//转换计划时间的格式
item.Plan_Time = Convert.ToDateTime(item.Plan_Time).ToString("yyyy-MM-dd");
//转换结束时间的格式
item.End_Date = Convert.ToDateTime(item.End_Date).ToString("yyyy-MM-dd HH:mm:ss");
}
//返回Layui的字符串格式
string str = "{\"code\": " + 0 + ",\"msg\": \"\",\"count\":" + saleList.Total + ",\"data\":" + JsonConvert.SerializeObject(saleList.ProcData) + "}";
return(str);
}
public string order(int page, int limit, string emp_Name)
{
ProcDataAndTotal <Base_Emp_Information> proc = bll.ProcPageData(emp_Name, page, limit);
//string order = "Emp_ID,Entry_Time,Emp_Dept,Emp_Post,Emp_Sex,Nominal_Family,Emp_Code,Native_Place,Registered_Residence,[Political _Outlook],Born_Time,Family_Telephone,Specialty,Remarks,Now_Address,Phone,Health,Hobby,Emp_Picture,Emp_Name";
string sJson = "{\"code\": " + 0 + ",\"msg\": \"\",\"count\":" + proc.Total + ",\"data\":" + JsonConvert.SerializeObject(proc.ProcData) + "}";
/*
* int total = 0;
* string order = "ID,Order_Depart,Order_PlaceOfDeparture,Order_Destination,Order_CarriageDriver,Order_CustomerName,Order_VehicleModel,Order_TypeOfGoods,CreateDate,Order_Aging,Order_State";
* List<Base_Emp_Information> models = bll.GetOrderList<Base_Emp_Information>("proc_Order_List", "[dbo].[tb_ OrderForm]", order, "", "ID", limit, page, ref total);
* string sJson = "{\"code\": " + 0 + ",\"msg\": \"\",\"count\":" + total + ",\"data\":" + JsonConvert.SerializeObject(models) + "}";
* return sJson;
*/
return(sJson);
}
public string GetVisit(int Page, int limit, string keHu_Name, string fuZeRen)
{
string whereStr = "";
if (!string.IsNullOrEmpty(keHu_Name))
{
whereStr += $" and Customer_Name like '%{keHu_Name}%'";
}
if (!string.IsNullOrEmpty(fuZeRen))
{
whereStr += $" and Responsible_Name like '%{fuZeRen}%'";
}
ProcDataAndTotal <VisitViewModel> vList = _Salebll.GetVisit(whereStr, Page, limit);
string str = "{\"code\": " + 0 + ",\"msg\": \"\",\"count\":" + vList.Total + ",\"data\":" + JsonConvert.SerializeObject(vList.ProcData) + "}";
return(str);
}
public string GetWaiQin(int Page, int limit, string dateTimestr, string emp_Name, string emp_Dept)
{
string whereStr = "";
if (!string.IsNullOrEmpty(emp_Name))
{
whereStr += $" and Emp_Name='{emp_Name}'";
}
if (!string.IsNullOrEmpty(emp_Dept))
{
whereStr += $" and Emp_Dept='{emp_Dept}'";
}
if (dateTimestr != null)
{
DateTime start = Convert.ToDateTime(dateTimestr.Substring(0, 10));
DateTime end = Convert.ToDateTime(dateTimestr.Substring(13, 10));
whereStr += $" and QianDate between '{start}' and '{end}'";
}
ProcDataAndTotal <WaiQinViewModel> WaiQinList = _Salebll.GetWaiQin(whereStr, Page, limit);
string str = "{\"code\": " + 0 + ",\"msg\": \"\",\"count\":" + WaiQinList.Total + ",\"data\":" + JsonConvert.SerializeObject(WaiQinList.ProcData) + "}";
return(str);
}
public ProcDataAndTotal <Base_Assete_Files> ProcGetFilesdata(int pageIndex, int pageSize)
{
ProcDataAndTotal <Base_Assete_Files> proc = _filesbll.ProcPageData("", pageIndex, pageSize);
return(proc);
}
