/// <summary> /// 获得生产线 /// </summary> public static DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * ,SCXBM+' | '+SCXName as SCXDESC from WMS_Pub_SCX "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by SCXNCID "); AdoHelper adoHelp = new SqlHelp(); DataSet ds = adoHelp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql.ToString()); return(ds); }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; string sql0 = SqlHelp.GetSql0(dbOperHandler.CountId("Flex_History").ToString() + " as totalcount,row_number() over (order by STime desc) as rowid,case when moneychange>0 then Convert(varchar(20),moneychange) else '---' end inmoney,case when moneychange<0 then Convert(varchar(20),moneychange) else '---' end outmoney,*", "Flex_History", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
/// <summary> /// 判断ICID是否已存在 /// </summary> /// <param name="icid"></param> /// <returns></returns> public static bool hasICID(string icid) { string sql = "select count(1) as hasicid from WMS_Pub_IC where ICID = '" + icid + "'"; AdoHelper adohlp = new SqlHelp(); string count = adohlp.ExecuteScalar(Common.GetConnectString(), CommandType.Text, sql).ToString(); if (string.IsNullOrEmpty(count) || count == "0") { return(false); } else { return(true); } }
//库龄分析 public static DataSet GetKLFX() { string strSql = "select klfxjg.ph,klfxjg.gg,klfxjg.sx,klfxjg.zjs,klfxjg.zzl,klfxjg.zzscrq,klfxjg.zdkl from " + "(select klfx.ph,klfx.gg,klfx.sx,sum(klfx.js) as zjs,sum(klfx.zl) as zzl,substring(convert(varchar,min(klfx.zzscrq), 120), 1, 10) as zzscrq,max(klfx.kuling) as zdkl from " + "(select ph,gg,sx,pch,count(*) as js,sum(zl) as zl,max(WeightRQ) as zzscrq,datediff(day, max(WeightRQ),getdate()) as kuling from WMS_Bms_Inv_Info group by ph,gg,sx,pch) klfx " + "group by klfx.ph, klfx.gg,klfx.sx) klfxjg order by klfxjg.zdkl desc"; AdoHelper dataHelp = new SqlHelp(); DataSet ds = dataHelp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds); } return(null); }
private void ajaxGetTotalList() { int PageIndex = this.Int_ThisPage(); int PageSize = this.Str2Int(this.q("pagesize"), 20); string whereStr = "userId =" + this.AdminId; string sql0 = SqlHelp.GetSql0("[sort],\r\n [Name],\r\n isnull(sum(Charge),0) as Charge,\r\n isnull(sum(getcash),0) as getcash, \r\n isnull(sum(bet),0) as bet ,\r\n isnull(sum(win),0) as win,\r\n isnull(sum(Point),0) as Point,\r\n isnull(sum(Give),0) as Give,\r\n isnull(sum(Change),0) as Change,\r\n isnull(sum(AgentFH),0) as AgentFH, \r\n isnull(sum(total),0) as total,\r\n isnull(sum(betno),0) as betno", "V_UserMoneyStatAllUserTotal", "sort", PageSize, PageIndex, "asc", whereStr, "Name,sort"); this.doh.Reset(); this.doh.SqlCmd = sql0; DataTable dataTable = this.doh.GetDataTable(); this._response = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}"; dataTable.Clear(); dataTable.Dispose(); }
/// <summary> /// 输出断网信息 /// </summary> public void showBreakRecord() { string cmdText = "select RoomName,OffLineBegin,OffLineTime from TT_Room where OnOff=0";//0未处理,1处理过的 DataTable DB_breakLineRecord = SqlHelp.ExecuteDataTable(CommandType.Text, cmdText, null); for (int i = 0; i < DB_breakLineRecord.Rows.Count; i++) { strSend = DB_breakLineRecord.Rows[i][0].ToString() + "在" + DB_breakLineRecord.Rows[i][1].ToString() + "断网,时间为" + DB_breakLineRecord.Rows[i][2].ToString() + "分钟"; send(strSend); label1.Text = strSend; sayword(strSend); //------设置每条输出信息时间间隔------- Thread.Sleep(10000); } }
public void GetListJSON(int page, int PSize, string whereStr, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = whereStr; string sql0 = SqlHelp.GetSql0(dbOperHandler.Count("Flex_User").ToString() + " as totalcount,row_number() over (order by Id asc) as rowid,*", "Flex_User", "Id", PSize, page, "asc", whereStr); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public void GetLoginListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; string sql0 = SqlHelp.GetSql0(dbOperHandler.Count("Log_UserLogin").ToString() + " as totalcount,row_number() over (order by Id desc) as rowid,dbo.f_GetUserName(UserId) as UserName,*", "Log_UserLogin", "loginTime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON2(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
/// <summary> /// 获得查询发运单界面的发运单信息数据集 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public static DataSet GetFYDInfo(string strWhere) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); strSql.Append("select FYDH,case status when 0 then '未执行' when 1 then '已进厂' when 2 then '装车完毕' when 3 then '已出厂' when 4 then '作废' when 5 then '正在装车' end as status,(select KHName from WMS_Pub_Customer where KHID = KHBM)KHName,(WLMC+PH+GG) AS WLMC,SX,CPH,CK,JHSL,SJSL,CAST(JHZL as numeric(20,3)) as JHZL,CAST(SJZL as numeric(20,3)) as SJZL,CZ_InTime,CZ_OtTime,(select UserName from WMS_Pub_Users where UserID=CZ_InUser)CZ_InUser,(select UserName from WMS_Pub_Users where UserID=CZ_OtUser)CZ_OtUser,NCZDRY from WMS_Bms_Pic_FYD "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by FYDH "); AdoHelper adohlp = new SqlHelp(); return(adohlp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql.ToString())); }
/// <summary> /// 判断是否属于无需验证时间间隔的车辆 /// </summary> /// <param name="CPH"></param> /// <returns></returns> public bool isAllowCPH(string CPH) { string sql = "select count(1) as allowCPH from WMS_pub_AllowCPH where CPH = '" + CPH + "'"; AdoHelper adohlp = new SqlHelp(); int result = Int32.Parse(adohlp.ExecuteScalar(Common.GetConnectString(), CommandType.Text, sql).ToString()); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// 判断车牌号是否已进厂 /// </summary> /// <param name="CPH"></param> /// <returns></returns> public bool IsInDoor(string CPH) { string sql = "select count(1) as fydcount from WMS_Bms_Pic_FYD where cph='" + CPH + " ' and (status in (1,2,5))"; AdoHelper adohlp = new SqlHelp(); int result = Int32.Parse(adohlp.ExecuteScalar(Common.GetConnectString(), CommandType.Text, sql).ToString()); if (result >= 1) { return(true); } else { return(false); } }
public static DataSet GetList() { StringBuilder strSql = new StringBuilder(); strSql.Append("select CKID,CKNCID,CKID+'|'+CKName AS CKCKName from WMS_Pub_Store "); strSql.Append(" order by CKID "); AdoHelper dataHelp = new SqlHelp(); DataSet ds = dataHelp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql.ToString()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds); } return(null); }
/// <summary> /// 删除一条数据 /// </summary> public void Delete() { StringBuilder strSql = new StringBuilder(); strSql.Append("delete WMS_Pub_IC "); strSql.Append(" where ICID=@ICID"); SqlParameter[] parameters = { new SqlParameter("@ICID", SqlDbType.VarChar) }; parameters[0].Value = this.ICID; AdoHelper adohlp = new SqlHelp(); adohlp.ExecuteNonQuery(Common.GetConnectString(), CommandType.Text, strSql.ToString(), parameters); }
public ActionResult ExImport(HttpPostedFileBase file) { //month1 导入数据表 var fileName = file.FileName; var filePath = Server.MapPath(string.Format("~/{0}", "FileExecel")); string path = Path.Combine(filePath, fileName); file.SaveAs(path); DataTable excelTable = new DataTable(); excelTable = imExpro.GetExcelDataTable(path); DataTable dtable = new DataTable(); dtable.Columns.Add("billdate"); dtable.Columns.Add("duedate"); dtable.Columns.Add("rate"); dtable.Columns.Add("remarks1"); dtable.Columns.Add("remarks2"); for (int i = 0; i < excelTable.Rows.Count; i++) { DataRow dr = excelTable.Rows[i]; DataRow dr_ = dtable.NewRow(); dr_["bildate"] = dr["bildate"]; dr_["duedate"] = dr["Duedate"]; dr_["rate"] = dr["Rate"]; dr_["remarks1"] = dr["Remarks1"]; dr_["remarks2"] = dr["Remarks2"]; dtable.Rows.Add(dr_); } string constr = System.Configuration.ConfigurationManager.AppSettings["EFeesEntities"]; using (TransactionScope tran = new TransactionScope()) { string sql = "delete from month1";//导入 新的mb1 SqlHelp.ExecuteNonQuery(constr, sql); DataTableSql.SqlBulkCopyByDatatable(constr, "month1", dtable); tran.Complete(); } return(Content(fileName.ToString())); }
private static DataSet GetDocLog(string docID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from [WMS_Com_Log] where DOCID='"); strSql.Append(docID); strSql.Append("' order by comTime desc"); AdoHelper adoHelp = new SqlHelp(); DataSet ds = adoHelp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql.ToString()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds); } return(null); }
/// <summary> /// 获得仓库ID获得用户列表 /// </summary> public static DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from WMS_Pub_Users a left join wms_pub_door b on a.doorno=b.doorno left join wms_pub_qzs c on a.qzs_no=c.qzs_no "); if (strWhere.Trim() != "") { strSql.Append(" where CK =" + strWhere); } strSql.Append(" order by UserID "); AdoHelper adoHelp = new SqlHelp(); DataSet ds = adoHelp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql.ToString()); return(ds); }
/// <summary> /// 获得用户列表 /// </summary> /// <param name="strWhere">查询条件,不需要加where</param> public static DataSet GetListByWhere(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select *,UserID+'|'+UserName as UserDesc from WMS_Pub_Users "); if (strWhere.Trim() != "") { strSql.Append(" WHERE " + strWhere); } strSql.Append(" order by UserName "); AdoHelper adoHelp = new SqlHelp(); DataSet ds = adoHelp.ExecuteDataset(Common.GetConnectString(), CommandType.Text, strSql.ToString()); return(ds); }
public void GetListJSONFlex(int _thispage, int _pagesize, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = " IsUsed=1"; int num = dbOperHandler.Count("Sys_News"); string sql = SqlHelp.GetSql0(num + " as totalcount,row_number() over (order by STime desc) as rowid,Convert(varchar(10),STime,120) as shortTime,substring(title,0,18)+'...' as shortTitle,*", "Sys_News", "STime", _pagesize, _thispage, "desc", " IsUsed=1"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON2(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Sys_News"); string sql0 = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid,Convert(varchar(10),STime,120) as shortTime,substring(title,0,18)+'...' as shortTitle,Substring(Convert(varchar(10),STime,120),6,2) as tmonth,Substring(Convert(varchar(10),STime,120),9,2) as tday,*", "Sys_News", "STime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
/// <summary> /// 得到总页数,和记录总条数 /// </summary> /// <param name="strWhere">查询条件,不带WHERE</param> /// <param name="pageSize">每页记录数</param> /// <param name="allCount">记录总条数</param> /// <returns>总页数</returns> public static int GetAllPCHPageCount(string pch, int pageSize, out int allCount) { string strSql = "select count(*) from (SELECT PCH FROM WMS_Bms_Inv_OutInfo where PCH like '%" + pch + "%' group by pch) a"; AdoHelper dataHelp = new SqlHelp(); Object result = dataHelp.ExecuteScalar(Common.GetConnectString(), CommandType.Text, strSql); if (result != null) { double temp = Convert.ToDouble(result); allCount = Convert.ToInt32(temp); double pageCount = Math.Ceiling(temp / pageSize); return(Convert.ToInt32(pageCount)); } allCount = 0; return(0); }
/// <summary> /// 得到总页数,和记录总条数 /// </summary> /// <param name="strWhere">查询条件,不带WHERE</param> /// <param name="pageSize">每页记录数</param> /// <param name="allCount">记录总条数</param> /// <returns>总页数</returns> public static int GetPageCount(string strSTime, string strETime, int pageSize, out int allCount) { string strSql = "SELECT count(*) FROM WMS_Pub_DataMoveLog where Beigin_Time>'" + strSTime + "' and Beigin_Time<'" + strETime + "'"; AdoHelper dataHelp = new SqlHelp(); Object result = dataHelp.ExecuteScalar(Common.GetConnectString(), CommandType.Text, strSql); if (result != null) { double temp = Convert.ToDouble(result); allCount = Convert.ToInt32(temp); double pageCount = Math.Ceiling(temp / pageSize); return(Convert.ToInt32(pageCount)); } allCount = 0; return(0); }
public void GetListJSON2(int _thispage, int _pagesize, string _wherestr1, string orderby, string order, string pid, string uid, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("V_User"); string sql0 = SqlHelp.GetSql0(pid + " as pid,*", "V_User", order, _pagesize, _thispage, orderby, _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"nav\" :\"" + this.GetUserNav(pid, uid) + "\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Log_UserLogin"); string sql0 = SqlHelp.GetSql0("*", "Log_UserLogin", "LoginTime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; dbOperHandler.Count("Flex_UserGetCash"); string sql = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,0.0000 as sxf,*", "Flex_UserGetCash", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public static string DeleteSxSetCZ(string pcsx, string mrdj, string dj) { string ret = ""; try { string sqlstr = "delete from WMS_PUB_CZSX where pcsx='" + pcsx + "' and DJSX='" + dj + "' and MRDJSX='" + mrdj + "'"; AdoHelper helper = new SqlHelp(); helper.ExecuteNonQuery(Common.GetConnectString(), CommandType.Text, sqlstr); } catch (Exception ex) { ret = "ERROR:" + ex.Message; } return(ret); }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("V_UserMoneyStatAllPoint"); string sql0 = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid,[UserId],dbo.f_GetUserName(UserId) as UserName,STime,Point", "V_UserMoneyStatAllPoint", "STime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON_ZHDetail(int _thispage, int _pagesize, string _wherestr1, string _wherestr2, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("V_UserBetZhDetail"); string sql0 = SqlHelp.GetSql0("row_number() over (order by IssueNum asc) as rowid,*,substring(Convert(varchar(20),STime2,120),6,11) as ShortTime", "V_UserBetZhDetail", "IssueNum", _pagesize, _thispage, "asc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxZhList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, string _wherestr2, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Flex_UserBet"); string sql0 = SqlHelp.GetSql0(_wherestr2 + "as isme,row_number() over (order by Id desc) as rowid,Id,SsId,UserId,UserName,UserMoney,PlayId,PlayName,PlayCode,LotteryId,LotteryName,IssueNum,SingleMoney,moshi,Times,Num,DX,DS,cast(Times*Total as decimal(15,4)) as Total,Point,PointMoney,Bonus,Bonus2,WinNum,WinBonus,RealGet,Pos,STime,STime2,substring(Convert(varchar(20),STime2,120),6,11) as ShortTime,IsOpen,State,IsWin,number,poslen", "Flex_UserBet", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
public void GetIphoneListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Flex_ChargeRecord"); string sql0 = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,UserName,*", "Flex_ChargeRecord", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
//获取发运单发货参考 public static DataSet GetQueryFYDFHCK(string fydh) { AdoHelper helper = new SqlHelp(); DataSet ds = null; string sqltmp = "SELECT * FROM v_delivery_ref V WHERE V.FYDH='" + fydh + "'"; ds = helper.ExecuteDataset(Common.GetConnectString(), CommandType.Text, sqltmp); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds); } else { return(null); } }