/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <TRANSMITTER_HEAD> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, 类型 = s.类型
, 变送器输入开始 = s.变送器输入开始
, 变送器输入开始单位 = s.变送器输入开始单位
, 变送器输入结束 = s.变送器输入结束
, 变送器输入结束单位 = s.变送器输入结束单位
, 通道 = s.通道
, Un = s.Un
, Un单位 = s.Un单位
, In = s.In
, In单位 = s.In单位
, PREPARE_SCHEMEID = s.PREPARE_SCHEMEID
, CREATETIME = s.CREATETIME
, CREATEPERSON = s.CREATEPERSON
, UPDATETIME = s.UPDATETIME
, UPDATEPERSON = s.UPDATEPERSON
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <FILE_UPLOADER> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, NAME = s.NAME
, PATH = s.PATH
, FULLPATH = s.FULLPATH
, SUFFIX = s.SUFFIX
, SIZE = s.SIZE
, REMARK = s.REMARK
, NAME2 = s.NAME2
, PATH2 = s.PATH2
, FULLPATH2 = s.FULLPATH2
, SUFFIX2 = s.SUFFIX2
, SIZE2 = s.SIZE2
, REMARK2 = s.REMARK2
, STATE2 = s.STATE2
, STATE = s.STATE
, CREATETIME = s.CREATETIME
, CREATEPERSON = s.CREATEPERSON
, CONCLUSION = s.CONCLUSION
, PREPARE_SCHEMEID = s.PREPARE_SCHEMEIDOld
, UPDATETIME = s.UPDATETIME
, UPDATEPERSON = s.UPDATEPERSON
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <CROSS_COS> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, COS = s.COS
, TEST_POINT = s.TEST_POINT
, TEST_POINT_UNIT = s.TEST_POINT_UNIT
, STANDARD_VALUE = s.STANDARD_VALUE
, STANDARD_VALUE_UNIT = s.STANDARD_VALUE_UNIT
, DISPLAY_VALUE = s.DISPLAY_VALUE
, DISPLAY_VALUE_UNIT = s.DISPLAY_VALUE_UNIT
, UNCERTAINTY_DEGREE = s.UNCERTAINTY_DEGREE
, PREPARE_SCHEMEID = s.PREPARE_SCHEMEID
, CROSS_HEADID = s.CROSS_HEADIDOld
, CREATETIME = s.CREATETIME
, CREATEPERSON = s.CREATEPERSON
, UPDATETIME = s.UPDATETIME
, UPDATEPERSON = s.UPDATEPERSON
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <PoliceMasterRelationship> queryData = m_BLL.GetByParam(getParam.id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, Name = s.Name
, InsuranceKindId = s.InsuranceKindIdOld
, Tag = s.Tag
, Style = s.Style
, IsMaster = s.IsMaster
, Remark = s.Remark
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
})
};
return(data);
}
public Common.ClientResult.DataResult GetCity(int costType)
{
#region 获取权限配置
//部门范围权限
int departmentScope = base.MenuDepartmentScopeAuthority(menuId);
string departments = "";
if (departmentScope == (int)DepartmentScopeAuthority.无限制)//无限制
{
//部门业务权限
departments = MenuDepartmentAuthority(menuId);
}
#endregion
var query = m_BLL.GetCityListByGroup(LoginInfo.UserID, costType);
var data = new Common.ClientResult.DataResult
{
rows = query.Select(s => new
{
ID = s.Id,
Name = s.Name
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <SysField> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, ParentId = s.ParentId
, MyTexts = s.MyTexts
, MyTables = s.MyTables
, MyColums = s.MyColums
, Remark = s.Remark
, Sort = s.Sort
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
, Version = s.Version
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData(string id, [FromBody] GetDataParam getParam)
{
int total = 0;
getParam.id = id;//刘腾飞
List <PRINTREPORT> queryData = m_BLL.GetByParam(id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
,
GETNUMBER = s.GETNUMBER
,
CREATETIME = s.CREATETIME
,
CREATEPERSON = s.CREATEPERSON
,
UPDATETIME = s.UPDATETIME
,
UPDATEPERSON = s.UPDATEPERSON
,
PREPARE_SCHEMEID = s.PREPARE_SCHEMEIDOld
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
int intBranchID = LoginInfo.BranchID;
string strCompanyName = "";
string strUserID_KF = "";
int? intUserID_KF = null;
string menuID = "";
if (!string.IsNullOrEmpty(getParam.search))
{
string[] search = getParam.search.Split('^');
strCompanyName = search[0];
strUserID_KF = search[1];
}
if (!string.IsNullOrEmpty(strUserID_KF))
{
intUserID_KF = Convert.ToInt32(strUserID_KF);
}
List <SupplierView> queryData = m_BLL.GetSupplierList(getParam.id, getParam.page, getParam.rows, strCompanyName, intUserID_KF, intBranchID, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int intBranchID = LoginInfo.BranchID;
string strSearch = "";
//strSearch += "BranchIDDDL_Int&" + intBranchID;
strSearch += "CRM_Company_IDDDL_Int&" + getParam.search;
List <CRM_CompanyFinance_Payment> queryData = m_BLL.GetByParam("", getParam.order, getParam.sort, strSearch);
var data = new Common.ClientResult.DataResult
{
total = queryData.Count,
rows = queryData.Select(s => new
{
ID = s.ID
,
CRM_Company_ID = s.CRM_Company_ID
,
PaymentName = s.PaymentName
,
CreateTime = s.CreateTime
,
CreateUserID = s.CreateUserID
,
CreateUserName = s.CreateUserName
,
Status = s.Status
,
BranchID = s.BranchID
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <DegreeSchool> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, ResumeId = s.ResumeIdOld
, BeginDate = s.BeginDate
, EndDate = s.EndDate
, IsNow = s.IsNow
, SchoolArea = s.SchoolArea
, SchoolName = s.SchoolName
, ProfessionalType1 = s.ProfessionalType1
, ProfessionalType2 = s.ProfessionalType2
, Education = s.Education
, Degree = s.Degree
, Sort = s.Sort
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
, Version = s.Version
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <SingleStopPaymentView> queryData = m_BLL.GetSingleStopPaymentInfo(LoginInfo.UserID, getParam.page, getParam.rows, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new SingleStopPaymentView()
{
CompanyID = s.CompanyID,
CompanyName = s.CompanyName,
EmployeeID = s.EmployeeID,
EmployeeName = s.EmployeeName,
CertificateNumber = s.CertificateNumber,
CanSotpInsuranceKindName = s.CanSotpInsuranceKindName,
EmployeeAddId = s.EmployeeAddId,
CompanyEmployeeRelationId = s.CompanyEmployeeRelationId,
CityName = s.CityName,
YearMonth = s.YearMonth,
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <PoliceOperationPoliceInsurancePoliceAccountNature2> queryData = m_BLL.GetByParam(getParam.id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, PoliceInsuranceId = s.PoliceInsuranceId
, PoliceOperationId = s.PoliceOperationId
, PoliceAccountNatureId = s.PoliceAccountNatureId
, IsCompany = s.IsCompany
, Expression = s.Expression
, Remark = s.Remark
, FeeCost = s.FeeCost
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody]GetDataParam getParam)
{
int total = 0;
List<TRANSMITTER_RANGE> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
,TEST_QUANTITY = s.TEST_QUANTITY
,INPUT_START = s.INPUT_START
,INPUT_START_UNIT = s.INPUT_START_UNIT
,INPUT_END = s.INPUT_END
,INPUT_END_UNIT = s.INPUT_END_UNIT
,OUTPUT_START = s.OUTPUT_START
,OUTPUT_START_UNIT = s.OUTPUT_START_UNIT
,OUTPUT_END = s.OUTPUT_END
,OUTPUT_END_UNIT = s.OUTPUT_END_UNIT
,SORT = s.SORT
,PREPARE_SCHEMEID = s.PREPARE_SCHEMEID
,CREATETIME = s.CREATETIME
,CREATEPERSON = s.CREATEPERSON
,UPDATETIME = s.UPDATETIME
,UPDATEPERSON = s.UPDATEPERSON
})
};
return data;
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
string createUser = string.Empty;
string beginTime = string.Empty;
string endTime = string.Empty;
if (!string.IsNullOrEmpty(getParam.search))
{
string[] search = getParam.search.Split('^');
createUser = search[0];
beginTime = search[1];
endTime = search[2];
}
List <EmployeeMiddleImportRecord> queryData = m_BLL.GetDataByParam(getParam.id, getParam.page, getParam.rows, createUser, beginTime, endTime, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, URL = s.URL
, ImportCount = s.ImportCount
, ImportPayment = s.ImportPayment
, CreateTime = s.CreateTime
, CreateUserID = s.CreateUserID
, CreateUserName = s.CreateUserName
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <VZHENGSHULEIBEITONGJIFENXI> queryData = m_BLL.GetByParam(getParam.id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, SUOSHUDANWEI = s.SUOSHUDANWEI
, ZHENGSHUDANWEI = s.ZHENGSHUDANWEI
, SHOULIDANWEI = s.SHOULIDANWEI
, PIZHUNJIELUN = s.PIZHUNJIELUN
, PIZHUNSHIJIAN = s.PIZHUNSHIJIAN
, SHOUQUANZIZHI = s.SHOUQUANZIZHI
,
ZHEGNSHUBAOGAOLEIBIE = s.ZHEGNSHUBAOGAOLEIBIE
,
BAOGAOSHULIANG = s.BAOGAOSHULIANG
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <VQIJULINGQU2> queryData = m_BLL.GetByParam(getParam.id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
,
APPLIANCE_NAME = s.APPLIANCE_NAME
,
VERSION = s.VERSION
,
FACTORY_NUM = s.FACTORY_NUM
,
NUM = s.NUM
,
ATTACHMENT = s.ATTACHMENT
,
UNDERTAKE_LABORATORYID = s.UNDERTAKE_LABORATORYID
,
APPLIANCE_RECIVE = s.APPLIANCE_RECIVE
,
REPORTNUMBER = s.REPORTNUMBER
,
REMARKS = s.REMARKS
,
ORDER_TASK_INFORMATIONID = s.ORDER_TASK_INFORMATIONID
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <TRANSMITTER_COS> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, TEST_QUANTITY = s.TEST_QUANTITY
, GRADE = s.GRADE
, TEST_POINT = s.TEST_POINT
, TEST_POINT_UNIT = s.TEST_POINT_UNIT
, COS = s.COS
, COS_UNIT = s.COS_UNIT
, TWO_INPUT_STANDARD_VALUES = s.TWO_INPUT_STANDARD_VALUES
, TWO_INPUT_STANDARD_VALUES_UNIT = s.TWO_INPUT_STANDARD_VALUES_UNIT
, STANDARD_OUTPUT_VALUE = s.STANDARD_OUTPUT_VALUE
, STANDARD_OUTPUT_VALUE_UNIT = s.STANDARD_OUTPUT_VALUE_UNIT
, ACTUAL_OUTPUT_VALUE = s.ACTUAL_OUTPUT_VALUE
, ACTUAL_OUTPUT_VALUE_UNIT = s.ACTUAL_OUTPUT_VALUE_UNIT
, REFERENCE_ERROR = s.REFERENCE_ERROR
, REFERENCE_ERROR_UNIT = s.REFERENCE_ERROR_UNIT
, TRANSMITTER_HEADID = s.TRANSMITTER_HEADIDOld
, PREPARE_SCHEMEID = s.PREPARE_SCHEMEID
, CREATETIME = s.CREATETIME
, CREATEPERSON = s.CREATEPERSON
, UPDATETIME = s.UPDATETIME
, UPDATEPERSON = s.UPDATEPERSON
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <FREQUENCY> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, DISPLAY_VALUE = s.DISPLAY_VALUE
, DISPLAY_VALUE_UNIT = s.DISPLAY_VALUE_UNIT
, STANDARD_VALUE = s.STANDARD_VALUE
, STANDARD_VALUE_UNIT = s.STANDARD_VALUE_UNIT
, RELATIVE_ERROR = s.RELATIVE_ERROR
, RELATIVE_ERROR_UNIT = s.RELATIVE_ERROR_UNIT
, UNCERTAINTY_DEGREE = s.UNCERTAINTY_DEGREE
, UNCERTAINTY_DEGREE_UNIT = s.UNCERTAINTY_DEGREE_UNIT
, PREPARE_SCHEMEID = s.PREPARE_SCHEMEID
, OVERALL_TABLEID = s.OVERALL_TABLEIDOld
, CREATETIME = s.CREATETIME
, CREATEPERSON = s.CREATEPERSON
, UPDATETIME = s.UPDATETIME
, UPDATEPERSON = s.UPDATEPERSON
})
};
return(data);
}
/// <summary>
/// 异步加载费用详情数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostCostDetailData(int id, string yearMonthStart, string yearMonthEnd, int costType)
{
int ymstart = Convert.ToInt32(yearMonthStart.Replace("-", ""));
int ymend = Convert.ToInt32(yearMonthEnd.Replace("-", ""));
List <CostPayDuibiDetails> list = m_BLL.GetDetails(id, ymstart, ymend, costType);
string costtype = ((Common.EmployeeAdd_InsuranceKindId)Enum.Parse(typeof(Common.EmployeeAdd_InsuranceKindId), costType.ToString())).ToString();
var data = new Common.ClientResult.DataResult
{
rows = list.Select(s => new
{
ID = s.CompanyId,
CompanyName = s.CompanyName,
CostTableType = costtype,
CompanyCost = s.CompanyCost,
PersonCost = s.PersonCost,
CompanyPay = s.CompanyPay,
PersonPay = s.PersonPay,
YearMonth = s.YearMonth,
CompanyCha = s.CompanyPay - s.CompanyCost,
PersonCha = s.PersonPay - s.PersonCost,
Cha = s.CompanyPay - s.CompanyCost + s.PersonPay - s.PersonCost
})
};
return(data);
}
/// <summary>
/// 获取社保客服列表(有权限控制)
/// </summary>
/// <returns></returns>
public Common.ClientResult.DataResult GetPerson()
{
#region 获取权限配置
//部门范围权限
int departmentScope = base.MenuDepartmentScopeAuthority(menuId);
string departments = "";
if (departmentScope == (int)DepartmentScopeAuthority.无限制)//无限制
{
//部门业务权限
departments = MenuDepartmentAuthority(menuId);
}
#endregion
// 获取上传客服列表数据源
var query = m_BLL.GetPersonListByGroupCode(gropUser_SBKF, departmentScope, departments, LoginInfo.BranchID, LoginInfo.DepartmentID, LoginInfo.UserID);
var data = new Common.ClientResult.DataResult
{
rows = query.Select(s => new
{
ID = s.ID,
Name = s.RName
})
};
return(data);
}
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
private dynamic InitData()
{
try
{
int total = 0;
//接收easyui的DataGrid控件传到后台的分页参数 post方式用Request.Form["page"]
int pageIndex = int.Parse(Request["page"]);
int pageSize = int.Parse(Request["rows"]);
string realName = Request["search"] ?? "";
List <dynamic> queryData = m_BLL.GetUserList(null, pageIndex, pageSize, realName, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData
};
return(data);
}
catch
{
return(null);
}
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <SysException> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, LeiXing = s.LeiXing
, Message = s.Message
, Result = s.Result
, Remark = s.Remark
, Sort = s.Sort
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
, Version = s.Version
})
};
return(data);
}
/// <summary>
/// 获取公司列表
/// </summary>
/// <returns></returns>
public Common.ClientResult.DataResult GetCompany()
{
#region 获取权限配置
//部门范围权限
int departmentScope = base.MenuDepartmentScopeAuthority(menuId);
string departments = "";
if (departmentScope == (int)DepartmentScopeAuthority.无限制)//无限制
{
//部门业务权限
departments = MenuDepartmentAuthority(menuId);
}
#endregion
var query = m_BLL.GetCompanyListByGroup(departmentScope, departments, LoginInfo.BranchID, LoginInfo.DepartmentID, LoginInfo.UserID); // 参数为该页面菜单ID
var data = new Common.ClientResult.DataResult
{
rows = query.Select(s => new
{
ID = s.ID,
Name = s.CompanyName
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <Attachment> queryData = m_BLL.GetByParam(getParam.id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, Name = s.Name
, Path = s.Path
, FullPath = s.FullPath
, Suffix = s.Suffix
, Size = s.Size
, InsuranceKindId = s.InsuranceKindIdOld
, Remark = s.Remark
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
})
};
return(data);
}
/// <summary>
/// 得到列表数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <SupplierLinkMan> queryData = m_BLL.GetByParam("", getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id,
SupplierId = s.SupplierId,
Name = s.Name,
Position = s.Position,
Address = s.Address,
Mobile = s.Mobile,
Telephone = s.Telephone,
Email = s.Email,
Remark = s.Remark,
IsDefault = s.IsDefault == "N" ? "否" : "是",
CreateTime = s.CreateTime,
CreateUserID = s.CreateUserID,
CreateUserName = s.CreateUserName,
Status = s.Status
})
};
return(data);
}
/// <summary>
/// 获取企业阶梯报价信息列表
/// </summary>
/// <param name="companyID">企业ID</param>
/// <param name="branchID">分支机构ID</param>
/// <returns></returns>
public Common.ClientResult.DataResult GetCompanyLadderPirceList(int companyID, int branchID)
{
using (SysEntities db = new SysEntities())
{
var queryData = from c in db.CRM_CompanyLadderPrice
join p in db.PRD_Product on c.PRD_Product_ID equals p.ID
where //c.BranchID == branchID &&
(companyID == null || c.CRM_Company_ID == companyID)
select new
{
c.ID,
c.CRM_Company_ID,
c.PRD_Product_ID,
c.SinglePrice,
c.BeginLadder,
c.EndLadder,
c.Status,
c.BranchID,
p.ProductName
};
int total = queryData.Count();
var queryList = queryData.ToList();
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryList
};
return(data);
}
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <FileUploader> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, ResumeId = s.ResumeIdOld
, PictureUrl = s.PictureUrl
, ResumeUrl = s.ResumeUrl
, Sort = s.Sort
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
, Version = s.Version
})
};
return(data);
}
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
private dynamic InitData()
{
try
{
int total = 0;
//接收easyui的DataGrid控件传到后台的分页参数 post方式用Request.Form["page"]
int pageIndex = int.Parse(Request["page"]);
int pageSize = int.Parse(Request["rows"]);
StringBuilder sqlWhere = new StringBuilder();
sqlWhere.Append("XYBZDDL_String&Y");
string roleName = Request["search"] ?? "";
if (!string.IsNullOrEmpty(roleName))
{
sqlWhere.Append("^GroupName&" + roleName);
}
List <ORG_Group> queryData = m_BLL.GetByParam(null, pageIndex, pageSize, "Desc", "ID", sqlWhere.ToString(), ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData
};
return(data);
}
catch
{
return(null);
}
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <UNCERTAINTYPARAMETERMANAGEMENT> queryData = m_BLL.GetByParam(null, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
ID = s.ID
, SOURCEOFERROR = s.SOURCEOFERROR
, LIMIT_VALUE = s.LIMIT_VALUE
, ERRORDISTRIBUTION = s.ERRORDISTRIBUTION
, k = s.k
, UNCERTAINTYDEGREE = s.UNCERTAINTYDEGREE
, UPDATETIME = s.UPDATETIME
, UPDATEPERSON = s.UPDATEPERSON
, CREATETIME = s.CREATETIME
, CREATEPERSON = s.CREATEPERSON
, RULEID = s.RULEIDOld
})
};
return(data);
}
/// <summary>
/// 异步加载数据
/// </summary>
/// <param name="getParam"></param>
/// <returns></returns>
public Common.ClientResult.DataResult PostData([FromBody] GetDataParam getParam)
{
int total = 0;
List <EmployeeGoonPayment3adsa> queryData = m_BLL.GetByParam(getParam.id, getParam.page, getParam.rows, getParam.order, getParam.sort, getParam.search, ref total);
var data = new Common.ClientResult.DataResult
{
total = total,
rows = queryData.Select(s => new
{
Id = s.Id
, InsuranceMonth = s.InsuranceMonth
, EmployeeAddId = s.EmployeeAddId
, EndTime = s.EndTime
, StartTime = s.StartTime
, Remark = s.Remark
, State = s.State
, CreateTime = s.CreateTime
, CreatePerson = s.CreatePerson
, UpdateTime = s.UpdateTime
, UpdatePerson = s.UpdatePerson
})
};
return(data);
}
