/// <summary>
/// 获取全部单据信息
/// </summary>
/// <returns>返回下线返修扭矩防错信息</returns>
public List <View_ZPX_OfflineFailsafe> GetAllBill()
{
string strSql = "select * from View_ZPX_OfflineFailsafe order by 产品型号,返修类型,分装总成,阶段,防错顺序";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
return(dataContxt.ExecuteQuery <View_ZPX_OfflineFailsafe>(strSql, new object[] { }).ToList());
}
/// <summary>
/// 通过id获得参与的人员
/// </summary>
/// <param name="id">id</param>
/// <returns>成功返回人员列表</returns>
public List <HR_CultivateStatisticsPerson> GetPersonByID(int id)
{
string strSql = "select * from HR_CultivateStatisticsPerson";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
return(dataContxt.ExecuteQuery <HR_CultivateStatisticsPerson>(strSql, new object[] { }).ToList());
}
/// <summary>
/// 获取全部阶段信息
/// </summary>
/// <returns>返回阶段信息</returns>
public List <ZPX_OfflinePhaseSet> GetAllPhase()
{
string strSql = "select * from dbo.ZPX_OfflinePhaseSet";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
return(dataContxt.ExecuteQuery <ZPX_OfflinePhaseSet>(strSql, new object[] { }).ToList());
}
/// <summary>
/// 获取时间段的单据信息
/// </summary>
/// <returns>返回培训统计数据集</returns>
public List <View_HR_CultivateStatistics> GetBillByDate(DateTime startTime, DateTime endTime)
{
string strSql = "select * from View_HR_CultivateStatistics where " +
" 培训开始时间 >='" + startTime + "' and 培训终止时间 <='" + endTime + "' order by 培训开始时间";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
return(dataContxt.ExecuteQuery <View_HR_CultivateStatistics>(strSql, new object[] { }).ToList());
}
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="startTime">起始时间</param>
/// <param name="endTime">终止时间</param>
/// <param name="status">单据状态</param>
/// <returns>返回数据集</returns>
public List <View_销售清单零件单价查询> GetExcelData(DateTime startTime, DateTime endTime, string status)
{
string sql = "select * from View_销售清单零件单价查询 where 销售时间 >= '" + startTime + "' " +
" and 销售时间<='" + endTime + "' and 单据状态='" + status + "'";
sql += " order by 单据号";
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
return(ctx.ExecuteQuery <View_销售清单零件单价查询>(sql, new object[] { }).ToList());
}
/// <summary>
/// 通过产品型号获取单据信息
/// </summary>
/// <param name="productType">产品型号</param>
/// <returns>返回下线返修扭矩防错信息</returns>
public List <View_ZPX_OfflineFailsafe> GetBillByProductType(string productType)
{
string strSql = "select * from View_ZPX_OfflineFailsafe ";
if (productType != "全部")
{
strSql += " where 产品型号='" + productType + "'";
}
strSql += " order by 产品型号,返修类型,分装总成,阶段,防错顺序";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
return(dataContxt.ExecuteQuery <View_ZPX_OfflineFailsafe>(strSql, new object[] { }).ToList());
}
/// <summary>
/// 获取全部单据信息
/// </summary>
/// <param name="strSelect">选择信息</param>
/// <returns>返回隔离单单据信息</returns>
public List <View_S_IsolationManageBill> GetAllBill(string strSelect)
{
if (strSelect == null || strSelect == "")
{
strSelect = "";
}
else
{
strSelect = " and " + strSelect;
}
string strSql = "select * from View_S_IsolationManageBill where 1 = 1 " + strSelect + " order by 单据号 desc";
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
return(ctx.ExecuteQuery <View_S_IsolationManageBill>(strSql, new object[] { }).ToList());
}