/// <summary>
/// 订单条件查询
/// </summary>
/// <param name="skip"></param>
/// <param name="take"></param>
/// <param name="strCondition"></param>
/// <param name="pageCount"></param>
/// <param name="exx"></param>
/// <returns></returns>
public DataTable GetProductOrder(int skip, int take, string[] strCondition, out Exception exx)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=121.196.134.67,443\\pbx;database=TopAppData;uid=sa;pwd=123;timeOut=500";
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "pro_SelectProductOrder";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@skip", skip + 1),
new SqlParameter("@take", skip + take),
new SqlParameter("@beginTime", strCondition[0]),
new SqlParameter("@endTime", strCondition[1]),
new SqlParameter("@yhm", strCondition[2]),
new SqlParameter("@Scode", strCondition[8]),
new SqlParameter("@sql", ""),
new SqlParameter("@sqlbody", ""),
new SqlParameter("@pricemin", strCondition[6]),
new SqlParameter("@pricemax", strCondition[7]),
new SqlParameter("@Type", strCondition[4]),
new SqlParameter("@Brand", strCondition[3]),
new SqlParameter("@OrderState", strCondition[5]),
new SqlParameter("@orderId", strCondition[9])
};
com.Parameters.AddRange(param);
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
com.Dispose();
exx = null;
BrandDAL bd = new BrandDAL();
List <BrandModel> listbrand = bd.SelectAllBrand();
ProductTypeDAL ptd = new ProductTypeDAL();
List <ProductTypeModel> listType = ptd.GetProductTypeReplace();
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < listbrand.Count; j++)
{
if (dt.Rows[i]["CAT"].ToString().Trim() == listbrand[j].BrandAbridge)
{
dt.Rows[i]["CAT"] = listbrand[j].BrandName;
}
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < listType.Count; j++)
{
if (dt.Rows[i]["CAT2"].ToString() == listType[j].TypeNo)
{
dt.Rows[i]["CAT2"] = listType[j].TypeName;
}
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["PRICED"].ToString() != "")
{
dt.Rows[i]["PRICED"] = Decimal.Parse(Math.Round(decimal.Parse(dt.Rows[i]["PRICED"].ToString()), 2).ToString());
}
if (dt.Rows[i]["PRICEE"].ToString() != "")
{
dt.Rows[i]["PRICEE"] = Decimal.Parse(Math.Round(decimal.Parse(dt.Rows[i]["PRICEE"].ToString()), 2).ToString());
}
}
return(dt);
}
catch (Exception ex)
{
exx = ex;
return(null);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
