/// <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())); }