public JqGrid ForGrid(JqGrid grid)
{
var query = new ContractTemplateQuery();
grid = QueryTableHelper.QueryGrid <CasContractTemplateEntity>(query, grid);
return(grid);
}
public JqGrid DownloadContractTep(JqGrid grid)
{
var query = new ContractTemplateDownloadQuery();
grid = QueryTableHelper.QueryGrid <CasContractTemplateEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
var query = new ContractTypeManagementQuery();
grid = QueryTableHelper.QueryGrid <CasContractTypeEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
var query = new DepUserCommonQuery();
grid = QueryTableHelper.QueryGrid <CasDepartmentEntity>(query, grid);
return(grid);
}
public JqGrid GetContractAttachment(JqGrid grid)
{
var query = new ContractAttachmentQuery();
query.keyWord = grid.keyWord;
grid = QueryTableHelper.QueryGrid <CasAttachmentEntity>(query, grid);
return(grid);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="grid">列表</param>
/// <returns></returns>
public JqGrid ForGrid(JqGrid grid)
{
CasRegionQuery query = new CasRegionQuery();
query.keyWord = grid.keyWord;
grid = QueryTableHelper.QueryGrid <CasRegionEntity>(query, grid);
return(grid);
}
public JqGrid ForPOGrid(JqGrid grid)
{
var query = new POQuery();
query.keyword = grid.keyWord;
grid = QueryTableHelper.QueryGrid <CasContractFilingEntity>(query, grid);
return(grid);
}
public JqGrid GetContractAttachmentList(JqGrid grid)
{
var query = new ContractTemplateAttachmentQuery();
//query.id = grid.QueryField["id"].ToString(); //做什么用的？
grid = QueryTableHelper.QueryGrid <CasAttachmentEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
var query = new POApprovalSetQuery();
query.keyWord = grid.keyWord;
grid = QueryTableHelper.QueryGrid <CasPoApprovalSettingsEntity>(query, grid);
return(grid);
}
public JqGrid GetContractApprolvalRes(JqGrid grid)
{
var query = new GetContractApprolvalResQuery();
query.keyWord = grid.keyWord;
grid = QueryTableHelper.QueryGrid <CasContractApprovalResultEntity>(query, grid);
return(grid);
}
public LigerGrid RoleAddGrid(string systemName, LigerGrid grid)
{
SecRoleQuery query = new SecRoleQuery();
query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryTable <SecRoleEntity>(query.RoleAddSQL(), grid);
return(grid);
}
/// <summary>
/// 获取用户角色
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
public LigerGrid UserRoleGrid(string systemName, LigerGrid grid)
{
QueryUser query = new QueryUser();
query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryTable <CasUserEntity>(query.GetUserRoleSQL(), grid);
return(grid);
}
public JqGrid ForGrid(string systemName, JqGrid grid)
{
QueryLogError query = new QueryLogError();
//query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryGrid <SecLogErrorEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
QueryUser query = new QueryUser();
query.name = grid.QueryField.ContainsKey("CHINESE_NAME") ? grid.QueryField["CHINESE_NAME"] : "";
grid.QueryField.Remove("CHINESE_NAME");
grid = QueryTableHelper.QueryGrid <CasUserEntity>(query, grid);
return(grid);
}
public JqGrid ForPOIndexGrid(JqGrid grid)
{
var query = new POIndexQuery();
query.CONTRACT_TYPE_NAME = grid.QueryField.ContainsKey("CONTRACT_TYPE_NAME") ? grid.QueryField["CONTRACT_TYPE_NAME"] : "";
grid.QueryField.Remove("CONTRACT_TYPE_NAME");
grid = QueryTableHelper.QueryGrid <CasContractEntity>(query, grid);
return(grid);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="grid">列表</param>
/// <returns></returns>
public JqGrid ForGrid(string systemName, JqGrid grid)
{
SecPageQuery query = new SecPageQuery();
//query.keyWord = grid.keyWord;
query.systemName = systemName;
grid = QueryTableHelper.QueryGrid <SecPageEntity>(query, grid);
return(grid);
}
/// <summary>
/// 合同审批设置查询审批用户
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
public JqGrid QueryApprovalUser(JqGrid grid)
{
var query = new ContractApprovalUserQuery();
//query.keyWord = grid.keyWord;
query.keyWord = grid.QueryField.ContainsKey("appSetid") ? grid.QueryField["appSetid"] : "";
grid.QueryField.Remove("appSetid");
grid = QueryTableHelper.QueryGrid <CasUserEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
var query = new ProxyApprovalQuery();
query.keyword = grid.keyWord;
query.startdate = grid.QueryField.ContainsKey("BEGIN_TIME") ? grid.QueryField["BEGIN_TIME"] : "";
grid.QueryField.Remove("BEGIN_TIME");
grid = QueryTableHelper.QueryGrid <CasProxyApprovalEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
var query = new ContractApprovalSetQuery();
query.keyWord = grid.keyWord;
query.keyWord = grid.QueryField.ContainsKey("CONTRACT_TYPE_NAME") ? grid.QueryField["CONTRACT_TYPE_NAME"] : "";
grid.QueryField.Remove("CONTRACT_TYPE_NAME");
grid = QueryTableHelper.QueryGrid <CasContractApprovalStepEntity>(query, grid);
return(grid);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="grid">列表</param>
/// <returns></returns>
public JqGrid ForGrid(JqGrid grid)
{
CasDepartmentQuery query = new CasDepartmentQuery();
query.keyWord = grid.keyWord;
if (grid.QueryField.ContainsKey("DEPT_TYPE"))
{
query.depType = grid.QueryField["DEPT_TYPE"].ToString();
}
;
grid = QueryTableHelper.QueryGrid <CasDepartmentEntity>(query, grid);
return(grid);
}
/// <summary>
/// 全部合同（FTS）
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
public JqGrid AllContractFTS(JqGrid grid)
{
var query = new AllContractFTSQuery();
query.CounterParty = grid.QueryField.ContainsKey("COUNTERPARTY_CN") ? grid.QueryField["COUNTERPARTY_CN"] : "";
grid.QueryField.Remove("COUNTERPARTY_CN");
query.keyWord = grid.QueryField.ContainsKey("CONTRACT_NAME") ? grid.QueryField["CONTRACT_NAME"] : "";
grid.QueryField.Remove("CONTRACT_NAME");
query.StatusValue = grid.QueryField.ContainsKey("STATUS") ? grid.QueryField["STATUS"] : "";
grid.QueryField.Remove("STATUS");
grid = CommonCondition(grid);
grid = QueryTableHelper.QueryGrid <CasContractEntity>(query, grid);
return(grid);
}
public JqGrid ForGrid(JqGrid grid)
{
var query = new ContractManagementQuery();
query.CounterParty = grid.QueryField.ContainsKey("COUNTERPARTY_CN")? grid.QueryField["COUNTERPARTY_CN"]:"";
grid.QueryField.Remove("COUNTERPARTY_CN");
query.keyWord = grid.QueryField.ContainsKey("CONTRACT_NAME") ? grid.QueryField["CONTRACT_NAME"] : "";
grid.QueryField.Remove("CONTRACT_NAME");
query.homeQuery = grid.QueryField.ContainsKey("HomeQuery") ? grid.QueryField["HomeQuery"] : "";
grid.QueryField.Remove("HomeQuery");
query.StatusValue = grid.QueryField.ContainsKey("STATUS") ? grid.QueryField["STATUS"] : "";
grid.QueryField.Remove("STATUS");
grid = QueryTableHelper.QueryGrid <CasContractEntity>(query, grid);
return(grid);
}
/// <summary>
/// 我支持的合同
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
public JqGrid ISupportedContract(JqGrid grid)
{
var query = new ISupportedContractQuery();
query.CounterParty = grid.QueryField.ContainsKey("COUNTERPARTY_CN") ? grid.QueryField["COUNTERPARTY_CN"] : "";
grid.QueryField.Remove("COUNTERPARTY_CN");
query.CONTRACT_GROUP = grid.QueryField.ContainsKey("CONTRACT_GROUP") ? grid.QueryField["CONTRACT_GROUP"] : "";
grid.QueryField.Remove("CONTRACT_GROUP");
query.CONTRACT_SERIAL_NO = grid.QueryField.ContainsKey("CONTRACT_SERIAL_NO") ? grid.QueryField["CONTRACT_SERIAL_NO"] : "";
grid.QueryField.Remove("CONTRACT_SERIAL_NO");
query.keyWord = grid.QueryField.ContainsKey("CONTRACT_NAME") ? grid.QueryField["CONTRACT_NAME"] : "";
grid.QueryField.Remove("CONTRACT_NAME");
query.PO = grid.QueryField.ContainsKey("PO") ? grid.QueryField["PO"] : "";
grid.QueryField.Remove("PO");
query.PR = grid.QueryField.ContainsKey("PR") ? grid.QueryField["PR"] : "";
grid.QueryField.Remove("PR");
query.StatusValue = grid.QueryField.ContainsKey("STATUS") ? grid.QueryField["STATUS"] : "";
grid.QueryField.Remove("STATUS");
grid = CommonCondition(grid);
grid = QueryTableHelper.QueryGrid <CasContractEntity>(query, grid);
return(grid);
}
/// <summary>
/// 我审批的合同
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
public JqGrid ContractApprovalByMe(JqGrid grid)
{
var query = new ContractApprovalByMeQuery();
query.CounterParty = grid.QueryField.ContainsKey("COUNTERPARTY_CN") ? grid.QueryField["COUNTERPARTY_CN"] : "";
grid.QueryField.Remove("COUNTERPARTY_CN");
query.FERRERO_ENTITY = grid.QueryField.ContainsKey("FERRERO_ENTITY") ? grid.QueryField["FERRERO_ENTITY"] : "";
grid.QueryField.Remove("FERRERO_ENTITY");
query.CONTRACT_NO = grid.QueryField.ContainsKey("CONTRACT_NO") ? grid.QueryField["CONTRACT_NO"] : "";
grid.QueryField.Remove("CONTRACT_NO");
query.CONTRACT_GROUP = grid.QueryField.ContainsKey("CONTRACT_GROUP") ? grid.QueryField["CONTRACT_GROUP"] : "";
grid.QueryField.Remove("CONTRACT_GROUP");
query.CONTRACT_SERIAL_NO = grid.QueryField.ContainsKey("CONTRACT_SERIAL_NO") ? grid.QueryField["CONTRACT_SERIAL_NO"] : "";
grid.QueryField.Remove("CONTRACT_SERIAL_NO");
query.keyWord = grid.QueryField.ContainsKey("CONTRACT_NAME") ? grid.QueryField["CONTRACT_NAME"] : "";
grid.QueryField.Remove("CONTRACT_NAME");
query.StatusValue = grid.QueryField.ContainsKey("STATUS") ? grid.QueryField["STATUS"] : "";
grid.QueryField.Remove("STATUS");
grid = CommonCondition(grid);
grid = QueryTableHelper.QueryGrid <CasContractEntity>(query, grid);
return(grid);
}
