110,566
社区成员
发帖
与我相关
我的任务
分享
namespace QSBN.DAL
{
public class DZZCLXJLFQuery
{
// public DZZCLXJLFQuery()
//这个构造函数是我调试的时候加上去的,程序就到这里就跳出去了
//{
///}
#region 周转材料修旧利废查询
/// <summary>
/// 周转材料修旧利废查询
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="Flag">标识</param>
/// <param name="dbuser">煤矿数据库用户名称</param>
/// <returns>DataSet</returns>
public DataSet GetSelectList(string strWhere, int Flag, string dbuser)
{
StringBuilder strSql = new StringBuilder();
switch (Flag)
{
case 1://明细
strSql.Append("SELECT A.CL_NO,A.CL_NAME,A.SCALE,A.SELF_ID,A.ONUMBER,A.ORIGPRICE,A.REMAIN,A.XHPRICE,A.REPAIR_MONEY,ROUND((A.ORIGPRICE-A.XHPRICE-A.REPPRICE)*A.ONUMBER,2) XFJZ,");
strSql.Append("A.DEPT_NAME,A.CONNECT_PERSON,A.STATES_NAME,A.WXTYPE_NAME");
strSql.Append(" FROM " + dbuser + ".ZZCL_REPAIR_ASSISTANT_VIEW A");
if (strWhere.Trim() != "")
{
strSql.Append(" WHERE " + strWhere);
}
break;
case 2://自身编号
strSql.Append("SELECT A.SELF_ID,A.CL_NO,A.CL_NAME,SUM(A.ONUMBER) ONUMBER,SUM(A.REMAIN) REMAIN,SUM(A.REPAIR_MONEY) REPAIR_MONEY,SUM((A.ORIGPRICE-A.XHPRICE-A.REPPRICE)*A.ONUMBER) XFJZ");
strSql.Append(" FROM " + dbuser + ".ZZCL_REPAIR_ASSISTANT_VIEW A");
if (strWhere.Trim() != "")
{
strSql.Append(" WHERE " + strWhere + " GROUP BY A.SELF_ID,A.CL_NO,A.CL_NAME");
}
else
{
strSql.Append(" GROUP BY A.SELF_ID,A.CL_NO,A.CL_NAME");
}
break;
case 3://材料编号
strSql.Append("SELECT A.CL_NO,A.CL_NAME,SUM(A.ONUMBER) ONUMBER,SUM(A.REMAIN) REMAIN,SUM(A.REPAIR_MONEY) REPAIR_MONEY,SUM((A.ORIGPRICE-A.XHPRICE-A.REPPRICE)*A.ONUMBER) XFJZ");
strSql.Append(" FROM " + dbuser + ".ZZCL_REPAIR_ASSISTANT_VIEW A");
if (strWhere.Trim() != "")
{
strSql.Append(" WHERE " + strWhere + " GROUP BY A.CL_NO,A.CL_NAME");
}
else
{
strSql.Append(" GROUP BY A.CL_NO,A.CL_NAME");
}
break;
case 4://维修部门
strSql.Append("SELECT A.DEPT_NAME,SUM(A.REPAIR_MONEY) REPAIR_MONEY,SUM((A.ORIGPRICE-A.XHPRICE-A.REPPRICE)*A.ONUMBER) XFJZ");
strSql.Append(" FROM " + dbuser + ".ZZCL_REPAIR_ASSISTANT_VIEW A");
if (strWhere.Trim() != "")
{
strSql.Append(" WHERE " + strWhere + " GROUP BY A.DEPT_NAME");
}
else
{
strSql.Append(" GROUP BY A.DEPT_NAME");
}
break;
case 5://维修类型
strSql.Append("SELECT A.WXTYPE_NAME,SUM(A.REPAIR_MONEY) REPAIR_MONEY,SUM((A.ORIGPRICE-A.XHPRICE-A.REPPRICE)*A.ONUMBER) XFJZ");
strSql.Append(" FROM " + dbuser + ".ZZCL_REPAIR_ASSISTANT_VIEW");
if (strWhere.Trim() != "")
{
strSql.Append(" WHERE " + strWhere + " GROUP BY A.WXTYPE_NAME");
}
else
{
strSql.Append(" GROUP BY A.WXTYPE_NAME");
}
break;
}
DataSet ds = LFDBHelper.ExecuteDataset(strSql.ToString());
return ds;
}
#endregion
}
}
[Quote=引用 9 楼 qq19808916 的回复:]