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