private string VerifyBoxNum(object boxNum)
{
if (boxNum == null || Convert.ToString(boxNum).Length != 11)
{
return("箱号必须为11位；");
}
DbHelperSQL da = new DbHelperSQL();
SqlParameter para = new SqlParameter("@CONTAINERNO", Convert.ToString(boxNum));
//string connectionString = "Data Source=10.2.2.31;Initial Catalog=EDB-DW;user id=mengtuo;pwd=mengtuo4321";
string sql = "KF_CONTAINER_INFO";
//BaseComponent.GetLookupNameBuValue("CSP_CONNECTIONS", "CONTAINER_INFO")
var result = da.ExecuteDataSet(ContainerInfoConnection, CommandType.StoredProcedure, sql, para);
if (result != null && result.Tables.Count > 0)
{
if (result.Tables[0].Rows.Count > 0)
{
if (string.IsNullOrWhiteSpace(Convert.ToString(result.Tables[0].Rows[0][0])))
{
return(Convert.ToString(boxNum) + "号集装箱不是阳明箱或已出场；");
}
else
{
return("");
}
}
return("");
}
return(Convert.ToString(boxNum) + "号集装箱不是阳明箱或已出场；");
}
public static DataTable GetTableColumn_SqlServer(string tablename)
{
SqlParameter[] paras =
{
new SqlParameter("@tbname", tablename)
};
return(DbHelperSQL.ExecuteDataSet("gettableinfo", paras).Tables[0]);
}
public DataSet GetList(string tablename, string fieldkey, string showString, int pageSize, int pageIndex, string strWhere, string orderString, out int recordCount, out int pageCount)
{
pageCount = 1;
if (pageIndex < 1)
{
pageIndex = 1;
}
if (pageSize < 1)
{
pageSize = 10;
}
if (string.IsNullOrEmpty(showString))
{
showString = "*";
}
if (string.IsNullOrEmpty(orderString))
{
orderString = "ID desc";
}
SqlParameter[] parameters =
{
new SqlParameter("@Sql", SqlDbType.VarChar), //0
new SqlParameter("@Order", SqlDbType.VarChar), //1
new SqlParameter("@CurrentPage", SqlDbType.Int), //2
new SqlParameter("@PageSize", SqlDbType.Int), //3
new SqlParameter("@TotalCount", SqlDbType.Int) //8
};
string sql = "select " + showString + " from " + tablename;
if (!string.IsNullOrEmpty(strWhere))
{
sql += " where " + strWhere;
}
sql = StringHelper.ReplaceBadSQL(sql);
parameters[0].Value = sql;
parameters[1].Value = orderString;
parameters[2].Value = pageIndex;
parameters[3].Value = pageSize;
parameters[4].Direction = ParameterDirection.Output;
DataSet dr = DbHelperSQL.ExecuteDataSet("MyPageList", parameters);
recordCount = Convert.ToInt32(parameters[4].Value.ToString());
if ((recordCount % pageSize) > 0)
{
pageCount = recordCount / pageSize + 1;
}
else
{
pageCount = recordCount / pageSize;
}
return(dr);
}
