/// <summary>
/// 获取条码库存信息
/// </summary>
/// <param name="CK">仓库</param>
/// <param name="HW">货位</param>
/// <param name="WGDH">完工单号</param>
/// <param name="PH">批号</param>
/// <param name="GZ">钢种</param>
/// <returns>条码库存信息</returns>
public DataSet GetList(string CK, string HW, string WGDH, string PH, string GZ)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,CKCXH,ProduceData,PCInfo,Filed1,ErrSeason,Filed2,vfree0,vfree1,vfree2,vfree3,vfree4 ");
strSql.Append(" FROM WMS_Bms_Inv_Info where 1=1 ");
if (CK.Trim() != "")
{
strSql.Append(" and CK='" + CK + "' ");
}
if (HW.Trim() != "")
{
strSql.Append(" and HW='" + HW + "' ");
}
if (WGDH.Trim() != "")
{
strSql.Append(" and WGDH='" + WGDH + "' ");
}
if (PH.Trim() != "")
{
strSql.Append(" and PCH='" + PH + "' ");
}
if (GZ.Trim() != "")
{
strSql.Append(" and PH='" + GZ + "' ");
}
strSql.Append(" order by Barcode ");
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Tra_ZKD_Detail GetModel(string ZKDH, string CPH, string Barcode, string PCH, string SX)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ZKDH,CPH,Barcode,WLH,WLMC,PH,GG,PCH,SX,CK,HW,ZL,CKOperator,CKTime,YKOperator,YKTime,YRKDH,YRKTime,YRKOperator,YRKType,vfree0,vfree1,vfree2,vfree3,vfree4 from WMS_Bms_Tra_ZKD_Detail ");
strSql.Append(" where ZKDH=:ZKDH and CPH=:CPH and Barcode=:Barcode and PCH=:PCH and SX=:SX ");
SqlParameter[] parameters =
{
new SqlParameter(":ZKDH", SqlDbType.VarChar, 50),
new SqlParameter(":CPH", SqlDbType.VarChar, 30),
new SqlParameter(":Barcode", SqlDbType.VarChar, 20),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":SX", SqlDbType.VarChar, 30)
};
parameters[0].Value = ZKDH;
parameters[1].Value = CPH;
parameters[2].Value = Barcode;
parameters[3].Value = PCH;
parameters[4].Value = SX;
Mod_WMS_Bms_Tra_ZKD_Detail model = new Mod_WMS_Bms_Tra_ZKD_Detail();
DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Tra_ZKD_Total GetModel(string ZKDH, string PCH, string SX, string CPH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ZKDH,PCH,SX,CPH,CKNUM,RKNUM,CKOperator,CKTime,YKOperator,YKTime from WMS_Bms_Tra_ZKD_Total ");
strSql.Append(" where ZKDH=:ZKDH and PCH=:PCH and SX=:SX and CPH=:CPH ");
SqlParameter[] parameters =
{
new SqlParameter(":ZKDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":SX", SqlDbType.VarChar, 30),
new SqlParameter(":CPH", SqlDbType.VarChar, 30)
};
parameters[0].Value = ZKDH;
parameters[1].Value = PCH;
parameters[2].Value = SX;
parameters[3].Value = CPH;
Mod_WMS_Bms_Tra_ZKD_Total model = new Mod_WMS_Bms_Tra_ZKD_Total();
DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Tra_ZKD GetModel(string ZKDH, string SCK, string TCK, string WLH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ZKDH,SCK,TCK,WLH,WLMC,PH,GG,PCH,SX,ZLDJ,ZJLDW,FJLDW,JHSL,JHZL,OutNum,OutZL,InNum,InZL,YHW,MBHW,ZHXLB,OutStatus,Status,Flag,ZDR,ZDRQ,vfree0,vfree1,vfree2,vfree3,vfree4 from WMS_Bms_Tra_ZKD ");
strSql.Append(" where ZKDH=:ZKDH and SCK=:SCK and TCK=:TCK and WLH=:WLH ");
SqlParameter[] parameters =
{
new SqlParameter(":ZKDH", SqlDbType.VarChar, 50),
new SqlParameter(":SCK", SqlDbType.VarChar, 30),
new SqlParameter(":TCK", SqlDbType.VarChar, 30),
new SqlParameter(":WLH", SqlDbType.VarChar, 20)
};
parameters[0].Value = ZKDH;
parameters[1].Value = SCK;
parameters[2].Value = TCK;
parameters[3].Value = WLH;
Mod_WMS_Bms_Tra_ZKD model = new Mod_WMS_Bms_Tra_ZKD();
DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Rec_WGD GetModel(string WGDH, string PCH, string PH, string GG, string SCX, string WLH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WGDH,PCH,PH,GG,BB,SCX,NCWLBMID,WLH,WLMC,FZDW,ZXBZ,PCSX,PCLX,ZLDJ,ZPGP,PCXH,WCBZ,PGBZ,ZJBZ,ZPDJBZ,Rev_Time,End_Time,PEnd_Time,FEW_scx,SendEnd,IsTran,YWLH,YWLMC,YPH,YGG,YZXBZ,ZDR,ZDDATE,UPDATERY,UPDATEDATE,FLAG,Filed1,PCInfo,Filed2,SendBack,vfree0,vfree1,vfree2,vfree3,vfree4,yvfree0,yvfree1,yvfree2,yvfree3,yvfree4,GPZL from WMS_Bms_Rec_WGD ");
strSql.Append(" where WGDH=:WGDH and PCH=:PCH and PH=:PH and GG=:GG and SCX=:SCX and WLH=:WLH ");
SqlParameter[] parameters =
{
new SqlParameter(":WGDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":PH", SqlDbType.VarChar, 30),
new SqlParameter(":GG", SqlDbType.VarChar, 30),
new SqlParameter(":SCX", SqlDbType.VarChar, 50),
new SqlParameter(":WLH", SqlDbType.VarChar, 20)
};
parameters[0].Value = WGDH;
parameters[1].Value = PCH;
parameters[2].Value = PH;
parameters[3].Value = GG;
parameters[4].Value = SCX;
parameters[5].Value = WLH;
Mod_WMS_Bms_Rec_WGD model = new Mod_WMS_Bms_Rec_WGD();
DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ZKDH,CPH,Barcode,WLH,WLMC,PH,GG,PCH,SX,CK,HW,ZL,CKOperator,CKTime,YKOperator,YKTime,YRKDH,YRKTime,YRKOperator,YRKType,vfree0,vfree1,vfree2,vfree3,vfree4 ");
strSql.Append(" FROM WMS_Bms_Tra_ZKD_Detail ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ZKDH,PCH,SX,CPH,CKNUM,RKNUM,CKOperator,CKTime,YKOperator,YKTime ");
strSql.Append(" FROM WMS_Bms_Tra_ZKD_Total ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select wgdh,pch,ph,gg,wlh,wlmc,pcinfo,zyx1,zyx2,zyx3,zyx4,zyx5,pk_ZJB_WGD_Item,ZJBstatus,CAPPK ");
strSql.Append(" FROM ReZJB_WGD_Item ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select wgdh,pch,ph,gg,bb,wlh,wlmc,fzdw,zxbz,zldj,SCX,pcinfo,zyx1,zyx2,zyx3,zyx4,zyx5,gpmainmeasrate,pk_ZJB_WGD,ZJBstatus,CAPPK ");
strSql.Append(" FROM ReZJB_WGD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ysdh,BARCODE,PCH,SX,ZCSL,FZCZL,vfree0,vfree1,vfree2,vfree3,vfree4,ZJBstatus,CAPPK,pk_ZJB_PDD_Item ");
strSql.Append(" FROM ReZJB_PDD_Item ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select WGDH,PCH,PH,GG,BB,SCX,NCWLBMID,WLH,WLMC,FZDW,ZXBZ,PCSX,PCLX,ZLDJ,ZPGP,PCXH,WCBZ,PGBZ,ZJBZ,ZPDJBZ,Rev_Time,End_Time,PEnd_Time,FEW_scx,SendEnd,IsTran,YWLH,YWLMC,YPH,YGG,YZXBZ,ZDR,ZDDATE,UPDATERY,UPDATEDATE,FLAG,Filed1,PCInfo,Filed2,SendBack,vfree0,vfree1,vfree2,vfree3,vfree4,yvfree0,yvfree1,yvfree2,yvfree3,yvfree4,GPZL ");
strSql.Append(" FROM WMS_Bms_Rec_WGD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,CKCXH,ProduceData,Filed1,PCInfo,Filed2,ErrSeason,vfree0,vfree1,vfree2,vfree3,vfree4 ");
strSql.Append(" FROM WMS_Bms_Tra_ZKD_Item ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ZKDH,SCK,TCK,WLH,WLMC,PH,GG,PCH,SX,ZLDJ,ZJLDW,FJLDW,JHSL,JHZL,OutNum,OutZL,InNum,InZL,YHW,MBHW,ZHXLB,OutStatus,Status,Flag,ZDR,ZDRQ,vfree0,vfree1,vfree2,vfree3,vfree4 ");
strSql.Append(" FROM WMS_Bms_Tra_ZKD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ywdh,ck,shw,dhw,czry,czrq,ZJBstatus,ts,by1,by2,by3,by4,by5 ");
strSql.Append(" FROM SeZJB_Shift_Record ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,CKCXH,ProduceData,PCInfo,Filed1,ErrSeason,Filed2,vfree0,vfree1,vfree2,vfree3,vfree4,pk_ZJB_GPD,GPTYPE,ZJBStatus,CAPPK ");
strSql.Append(" FROM ReZJB_GPD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select fydh,ck,khbm,yslb,cph,wlh,wlmc,sx,zldj,jhsl,jhzl,zjldw,fjldw,varrivestation,zdr,zdrq,PH,GG,PCInfo,zyx1,zyx2,zyx3,zyx4,zyx5,pk_ZJB_FYD,ZJBstatus,CAPPK,ywbm,ywry ");
strSql.Append(" FROM ReZJB_FYD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ysdh,ck,pdrq,djzt,shuser,shdate,finished,ZJBstatus,ts,by1,by2,by3,by4,by5 ");
strSql.Append(" FROM SeZJB_PDD_FINISHED ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select pk_ZJB_PDD,ZJBstatus,CAPPK,ck,pdrq,ysdh ");
strSql.Append(" FROM ReZJB_PDD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select wgdh,pch,finished,ZJBstatus,ts,by1,by2,by3,by4,by5 ");
strSql.Append(" FROM SeZJB_WGD_Finished ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select zkdh,sck,tck,wlh,wlmc,pch,sx,zldj,jhsl,jhzl,zjldw,fjldw,ph,gg,vfree0,vfree1,vfree2,vfree3,vfree4,pk_ZJB_ZKD,ZJBstatus,CAPPK ");
strSql.Append(" FROM ReZJB_ZKD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Inv_Info GetModel(string Barcode, string WGDH, string CK, string HW, string PCH, string WLH, string SX, string PH, string ProduceData, string vfree1, string vfree2, string vfree3)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,CKCXH,ProduceData,PCInfo,Filed1,ErrSeason,Filed2,vfree0,vfree1,vfree2,vfree3,vfree4 from WMS_Bms_Inv_Info ");
strSql.Append(" where Barcode=:Barcode and WGDH=:WGDH and CK=:CK and HW=:HW and PCH=:PCH and WLH=:WLH and SX=:SX and PH=:PH and ProduceData=:ProduceData and vfree1=:vfree1 and vfree2=:vfree2 and vfree3=:vfree3 ");
SqlParameter[] parameters =
{
new SqlParameter(":Barcode", SqlDbType.VarChar, 20),
new SqlParameter(":WGDH", SqlDbType.VarChar, 50),
new SqlParameter(":CK", SqlDbType.VarChar, 30),
new SqlParameter(":HW", SqlDbType.VarChar, 20),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":WLH", SqlDbType.VarChar, 20),
new SqlParameter(":SX", SqlDbType.VarChar, 30),
new SqlParameter(":PH", SqlDbType.VarChar, 30),
new SqlParameter(":ProduceData", SqlDbType.VarChar, 20),
new SqlParameter(":vfree1", SqlDbType.VarChar, 50),
new SqlParameter(":vfree2", SqlDbType.VarChar, 50),
new SqlParameter(":vfree3", SqlDbType.VarChar, 50)
};
parameters[0].Value = Barcode;
parameters[1].Value = WGDH;
parameters[2].Value = CK;
parameters[3].Value = HW;
parameters[4].Value = PCH;
parameters[5].Value = WLH;
parameters[6].Value = SX;
parameters[7].Value = PH;
parameters[8].Value = ProduceData;
parameters[9].Value = vfree1;
parameters[10].Value = vfree2;
parameters[11].Value = vfree3;
Mod_WMS_Bms_Inv_Info model = new Mod_WMS_Bms_Inv_Info();
DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ywdh,ck,shw,dhw,czry,czrq,ZJBstatus,ts,by1,by2,by3,by4,by5 ");
strSql.Append(" FROM SeZJB_Shift_Record ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ysdh,BARCODE,PCH,SX,ZCSL,FZCZL,vfree0,vfree1,vfree2,vfree3,vfree4,ZJBstatus,CAPPK,pk_ZJB_PDD_Item ");
strSql.Append(" FROM ReZJB_PDD_Item ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" Barcode,RKDH,FYDH,CKDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,Flag,CKRY,CXH,KHBM,WeightRQ,CKCXH,ProduceData,Filed1,PCInfo,Filed2,ErrSeason,vfree0,vfree1,vfree2,vfree3,vfree4,ysmz ");
strSql.Append(" FROM WMS_Bms_Inv_OutInfo ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" wgdh,pch,ph,gg,wlh,wlmc,pcinfo,zyx1,zyx2,zyx3,zyx4,zyx5,pk_ZJB_WGD_Item,ZJBstatus,CAPPK ");
strSql.Append(" FROM ReZJB_WGD_Item ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" pk_ZJB_PDD,ZJBstatus,CAPPK,ck,pdrq,ysdh ");
strSql.Append(" FROM ReZJB_PDD ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ZKDH,PCH,SX,CPH,CKNUM,RKNUM,CKOperator,CKTime,YKOperator,YKTime ");
strSql.Append(" FROM WMS_Bms_Tra_ZKD_Total ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ysdh,ck,pdrq,djzt,shuser,shdate,finished,ZJBstatus,ts,by1,by2,by3,by4,by5 ");
strSql.Append(" FROM SeZJB_PDD_FINISHED ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" wgdh,pch,finished,ZJBstatus,ts,by1,by2,by3,by4,by5 ");
strSql.Append(" FROM SeZJB_WGD_Finished ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelper_SQL.Query(strSql.ToString()));
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby);
}
else
{
strSql.Append("order by T.pk_ZJB_ZKD desc");
}
strSql.Append(")AS Row, T.* from SeZJB_Shift_Record T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return(DbHelper_SQL.Query(strSql.ToString()));
}
