/// <summary>
/// 从一个SqlDataReader里读数据
/// </summary>
/// <param name="Reader">SqlDataReader</param>
/// <returns>basic_order_planExample</returns>
public static basic_order_plan GetByReader(SqlDataReader Reader)
{
basic_order_plan basic_order_planExample = new basic_order_plan();
basic_order_planExample.opid = Reader["opid"] == DBNull.Value ? 0 : (int)Reader["opid"];
basic_order_planExample.opday1 = Reader["opday1"] == DBNull.Value ? 0 : (int)Reader["opday1"];
basic_order_planExample.opday2 = Reader["opday2"] == DBNull.Value ? 0 : (int)Reader["opday2"];
basic_order_planExample.opday3 = Reader["opday3"] == DBNull.Value ? 0 : (int)Reader["opday3"];
basic_order_planExample.opday4 = Reader["opday4"] == DBNull.Value ? 0 : (int)Reader["opday4"];
basic_order_planExample.opday5 = Reader["opday5"] == DBNull.Value ? 0 : (int)Reader["opday5"];
basic_order_planExample.opday6 = Reader["opday6"] == DBNull.Value ? 0 : (int)Reader["opday6"];
basic_order_planExample.opday7 = Reader["opday7"] == DBNull.Value ? 0 : (int)Reader["opday7"];
basic_order_planExample.opday8 = Reader["opday8"] == DBNull.Value ? 0 : (int)Reader["opday8"];
basic_order_planExample.opday9 = Reader["opday9"] == DBNull.Value ? 0 : (int)Reader["opday9"];
basic_order_planExample.opday10 = Reader["opday10"] == DBNull.Value ? 0 : (int)Reader["opday10"];
basic_order_planExample.opday11 = Reader["opday11"] == DBNull.Value ? 0 : (int)Reader["opday11"];
basic_order_planExample.opday12 = Reader["opday12"] == DBNull.Value ? 0 : (int)Reader["opday12"];
basic_order_planExample.opday13 = Reader["opday13"] == DBNull.Value ? 0 : (int)Reader["opday13"];
basic_order_planExample.opday14 = Reader["opday14"] == DBNull.Value ? 0 : (int)Reader["opday14"];
basic_order_planExample.opnum = Reader["opnum"] == DBNull.Value ? 0 : (int)Reader["opnum"];
basic_order_planExample.optype = Reader["optype"] == DBNull.Value ? null : Reader["optype"].ToString();
basic_order_planExample.opremark = Reader["opremark"] == DBNull.Value ? null : Reader["opremark"].ToString();
basic_order_planExample.opname = Reader["opname"] == DBNull.Value ? null : Reader["opname"].ToString();
return(basic_order_planExample);
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
basic_order_plan dp = basic_order_planManager.SearchByID(temp);
if (dp != null)
{
try
{
ddl_optype.SelectedValue = dp.optype;
txt_1.Text = dp.opday1.ToString();
txt_2.Text = dp.opday2.ToString();
txt_3.Text = dp.opday3.ToString();
txt_4.Text = dp.opday4.ToString();
txt_5.Text = dp.opday5.ToString();
txt_6.Text = dp.opday6.ToString();
txt_7.Text = dp.opday7.ToString();
txt_8.Text = dp.opday8.ToString();
txt_9.Text = dp.opday9.ToString();
txt_10.Text = dp.opday10.ToString();
txt_11.Text = dp.opday11.ToString();
txt_12.Text = dp.opday12.ToString();
txt_13.Text = dp.opday13.ToString();
txt_14.Text = dp.opday14.ToString();
txt_name.Text = dp.opname;
txt_remark.Text = dp.opremark;
}
catch { }
}
}
}
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <basic_order_plan> SearchAll()
{
DBHelper.sqlstr = "select * from basic_order_plan ";
List <basic_order_plan> list = new List <basic_order_plan>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_order_plan Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 根据编号获取补单方案
/// </summary>
/// <param name="opid"></param>
/// <returns></returns>
public static basic_order_plan GetInList(string opid)
{
basic_order_plan op = null;
IList <basic_order_plan> list = GetList();
foreach (basic_order_plan dp in list)
{
if (dp.opid.ToString() == opid)
{
op = dp;
break;
}
}
return(op);
}
/// <summary>
/// 根据opid,查询一条数据
/// </summary>
/// <param name="opid">编号</param>
/// <returns></returns>
/*查看是否为视图*/
public basic_order_plan SearchByID(int opid)
{
DBHelper.sqlstr = "select * from basic_order_plan where opid = @opid";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@opid", opid)
};
SqlDataReader reader = DBHelper.ExecuteReader(param);
basic_order_plan Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
/// <summary>
/// 搜索条件
/// </summary>
/// <param name="s">开始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="state">状态</param>
/// <param name="orderby">排序方式,直接输入order by后面的语句</param>
/// <returns>IList<basic_order_plan></returns>
public IList <basic_order_plan> Search(int s, int e, string key, string state, string orderby)
{
string sql1 = "select top " + (e - s + 1).ToString() + " * from basic_order_plan where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( opremark like '%" + key + "%' or opname like '%" + key + "%' ) ";
string sql3 = string.IsNullOrEmpty(state) ? "" : " and optype= '" + state + "' ";
string sql4 = string.IsNullOrEmpty(orderby) ? " order by opid desc " : " order by " + orderby;
string sql5 = s == 1 ? "" : " and opid not in ( select top " + (s - 1).ToString() + " opid from basic_order_plan where " + sql2 + sql3 + sql4 + " ) ";
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql5 + sql4;
List <basic_order_plan> list = new List <basic_order_plan>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_order_plan Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 搜索条件
/// </summary>
/// <param name="s">开始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="state">状态</param>
/// <param name="orderby">排序方式,直接输入order by后面的语句</param>
/// <returns>IList<basic_order_plan></returns>
public IList <basic_order_plan> Search(int s, int e, string key, string state, string orderby)
{
string sql1 = "select * from basic_order_plan where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( opremark like '%" + key + "%' or opname like '%" + key + "%' ) ";
string sql3 = string.IsNullOrEmpty(state) ? "" : " and optype= '" + state + "' ";
string sql4 = string.IsNullOrEmpty(orderby) ? " order by opid desc " : " order by " + orderby;
string sql10 = e == 0 ? " " : " limit " + s + "," + e;
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql10;
List <basic_order_plan> list = new List <basic_order_plan>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_order_plan Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string _type = ddl_optype.SelectedValue;
int op1 = 0;
if (!int.TryParse(txt_1.Text.Trim(), out op1))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_1);
return;
}
int op2 = 0;
if (!int.TryParse(txt_2.Text.Trim(), out op2))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_1);
return;
}
int op3 = 0;
if (!int.TryParse(txt_3.Text.Trim(), out op3))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_3);
return;
}
int op4 = 0;
if (!int.TryParse(txt_4.Text.Trim(), out op4))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_4);
return;
}
int op5 = 0;
if (!int.TryParse(txt_5.Text.Trim(), out op5))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_5);
return;
}
int op6 = 0;
if (!int.TryParse(txt_6.Text.Trim(), out op6))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_6);
return;
}
int op7 = 0;
if (!int.TryParse(txt_7.Text.Trim(), out op7))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_7);
return;
}
int op8 = 0;
if (!int.TryParse(txt_8.Text.Trim(), out op8))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_8);
return;
}
int op9 = 0;
if (!int.TryParse(txt_9.Text.Trim(), out op9))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_9);
return;
}
int op10 = 0;
if (!int.TryParse(txt_10.Text.Trim(), out op10))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_10);
return;
}
int op11 = 0;
if (!int.TryParse(txt_11.Text.Trim(), out op11))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_11);
return;
}
int op12 = 0;
if (!int.TryParse(txt_12.Text.Trim(), out op12))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_12);
return;
}
int op13 = 0;
if (!int.TryParse(txt_13.Text.Trim(), out op13))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_13);
return;
}
int op14 = 0;
if (!int.TryParse(txt_14.Text.Trim(), out op14))
{
Manager.Alert("请输入正确的数量", Page);
Manager.TextBox_Select(txt_14);
return;
}
string name = txt_name.Text.Trim();
string remark = txt_remark.Text.Trim();
basic_order_plan dp = new basic_order_plan();
if (!string.IsNullOrEmpty(id))
{
dp = BLL.basic_order_planManager.SearchByID(Convert.ToInt32(id));
}
dp.optype = _type;
dp.opremark = remark;
dp.opday1 = op1;
dp.opday2 = op2;
dp.opday3 = op3;
dp.opday4 = op4;
dp.opday5 = op5;
dp.opday6 = op6;
dp.opday7 = op7;
dp.opday8 = op8;
dp.opday9 = op9;
dp.opday10 = op10;
dp.opday11 = op11;
dp.opday12 = op12;
dp.opday13 = op13;
dp.opday14 = op14;
dp.opname = name;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.basic_order_planManager.Insert(dp);
}
else
{
res = BLL.basic_order_planManager.Update(dp);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="basic_order_plan">basic_order_plan表实例</param>
/// <returns>int</returns>
public static int Update(basic_order_plan basic_order_planExample)
{
return(Service.Update(basic_order_planExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="basic_order_plan">basic_order_plan表实例</param>
/// <returns>int</returns>
public static int Insert(basic_order_plan basic_order_planExample)
{
return(Service.Insert(basic_order_planExample));
}
/// <summary>
/// 根据上架时间获取补单计划中需要补单数量
/// </summary>
/// <param name="dt">上架时间</param>
/// <param name="id">补单方案编号</param>
/// <returns>补单数量</returns>
public static int GetNumInPlan(DateTime dt, int id)
{
int res = 0;
basic_order_plan bg = GetInList(id.ToString());
if (bg != null)
{
//int temp_day = Manager.DateDiff_GetInt(DateTime.Now, dt);
DateTime dt1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd"));
DateTime dt2 = Convert.ToDateTime(dt.ToString("yyyy/MM/dd"));
TimeSpan ts = dt1 - dt2;
int temp_day = ts.Days;
if (temp_day == 0)
{
res = bg.opday1;
}
if (temp_day == 1)
{
res = bg.opday2;
}
if (temp_day == 2)
{
res = bg.opday3;
}
if (temp_day == 3)
{
res = bg.opday4;
}
if (temp_day == 4)
{
res = bg.opday5;
}
if (temp_day == 5)
{
res = bg.opday6;
}
if (temp_day == 6)
{
res = bg.opday7;
}
if (temp_day == 7)
{
res = bg.opday8;
}
if (temp_day == 8)
{
res = bg.opday9;
}
if (temp_day == 9)
{
res = bg.opday10;
}
if (temp_day == 10)
{
res = bg.opday11;
}
if (temp_day == 11)
{
res = bg.opday12;
}
if (temp_day == 12)
{
res = bg.opday13;
}
if (temp_day == 13)
{
res = bg.opday14;
}
}
return(res);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="basic_order_plan">basic_order_plan表实例</param>
/// <returns>int</returns>
public int Update(basic_order_plan basic_order_planExample)
{
DBHelper.sqlstr = "update basic_order_plan set opday1=@opday1,opday2=@opday2,opday3=@opday3,opday4=@opday4,opday5=@opday5,opday6=@opday6,opday7=@opday7,opday8=@opday8,opday9=@opday9,opday10=@opday10,opday11=@opday11,opday12=@opday12,opday13=@opday13,opday14=@opday14,opnum=@opnum,optype=@optype,opremark=@opremark,opname=@opname where opid=" + basic_order_planExample.opid;
return(DBHelper.ExecuteNonQuery(GetSqlParameters(basic_order_planExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="basic_order_plan">basic_order_plan表实例</param>
/// <returns>int</returns>
public int Insert(basic_order_plan basic_order_planExample)
{
DBHelper.sqlstr = "insert into basic_order_plan (opday1,opday2,opday3,opday4,opday5,opday6,opday7,opday8,opday9,opday10,opday11,opday12,opday13,opday14,opnum,optype,opremark,opname)values(@opday1,@opday2,@opday3,@opday4,@opday5,@opday6,@opday7,@opday8,@opday9,@opday10,@opday11,@opday12,@opday13,@opday14,@opnum,@optype,@opremark,@opname)";
return(DBHelper.ExecuteNonQuery(GetSqlParameters(basic_order_planExample)));
}
/// <summary>
/// 根据表,获取一个SqlParameter数组
/// </summary>
/// <returns>SqlParameter[]</returns>
public static SqlParameter[] GetSqlParameters(basic_order_plan basic_order_planExample)
{
List <SqlParameter> list_param = new List <SqlParameter>();
if (basic_order_planExample.opday1 != 0)
{
list_param.Add(new SqlParameter("@opday1", basic_order_planExample.opday1));
}
else
{
list_param.Add(new SqlParameter("@opday1", DBNull.Value));
}
if (basic_order_planExample.opday2 != 0)
{
list_param.Add(new SqlParameter("@opday2", basic_order_planExample.opday2));
}
else
{
list_param.Add(new SqlParameter("@opday2", DBNull.Value));
}
if (basic_order_planExample.opday3 != 0)
{
list_param.Add(new SqlParameter("@opday3", basic_order_planExample.opday3));
}
else
{
list_param.Add(new SqlParameter("@opday3", DBNull.Value));
}
if (basic_order_planExample.opday4 != 0)
{
list_param.Add(new SqlParameter("@opday4", basic_order_planExample.opday4));
}
else
{
list_param.Add(new SqlParameter("@opday4", DBNull.Value));
}
if (basic_order_planExample.opday5 != 0)
{
list_param.Add(new SqlParameter("@opday5", basic_order_planExample.opday5));
}
else
{
list_param.Add(new SqlParameter("@opday5", DBNull.Value));
}
if (basic_order_planExample.opday6 != 0)
{
list_param.Add(new SqlParameter("@opday6", basic_order_planExample.opday6));
}
else
{
list_param.Add(new SqlParameter("@opday6", DBNull.Value));
}
if (basic_order_planExample.opday7 != 0)
{
list_param.Add(new SqlParameter("@opday7", basic_order_planExample.opday7));
}
else
{
list_param.Add(new SqlParameter("@opday7", DBNull.Value));
}
if (basic_order_planExample.opday8 != 0)
{
list_param.Add(new SqlParameter("@opday8", basic_order_planExample.opday8));
}
else
{
list_param.Add(new SqlParameter("@opday8", DBNull.Value));
}
if (basic_order_planExample.opday9 != 0)
{
list_param.Add(new SqlParameter("@opday9", basic_order_planExample.opday9));
}
else
{
list_param.Add(new SqlParameter("@opday9", DBNull.Value));
}
if (basic_order_planExample.opday10 != 0)
{
list_param.Add(new SqlParameter("@opday10", basic_order_planExample.opday10));
}
else
{
list_param.Add(new SqlParameter("@opday10", DBNull.Value));
}
if (basic_order_planExample.opday11 != 0)
{
list_param.Add(new SqlParameter("@opday11", basic_order_planExample.opday11));
}
else
{
list_param.Add(new SqlParameter("@opday11", DBNull.Value));
}
if (basic_order_planExample.opday12 != 0)
{
list_param.Add(new SqlParameter("@opday12", basic_order_planExample.opday12));
}
else
{
list_param.Add(new SqlParameter("@opday12", DBNull.Value));
}
if (basic_order_planExample.opday13 != 0)
{
list_param.Add(new SqlParameter("@opday13", basic_order_planExample.opday13));
}
else
{
list_param.Add(new SqlParameter("@opday13", DBNull.Value));
}
if (basic_order_planExample.opday14 != 0)
{
list_param.Add(new SqlParameter("@opday14", basic_order_planExample.opday14));
}
else
{
list_param.Add(new SqlParameter("@opday14", DBNull.Value));
}
if (basic_order_planExample.opnum != 0)
{
list_param.Add(new SqlParameter("@opnum", basic_order_planExample.opnum));
}
else
{
list_param.Add(new SqlParameter("@opnum", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_order_planExample.optype))
{
list_param.Add(new SqlParameter("@optype", basic_order_planExample.optype));
}
else
{
list_param.Add(new SqlParameter("@optype", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_order_planExample.opremark))
{
list_param.Add(new SqlParameter("@opremark", basic_order_planExample.opremark));
}
else
{
list_param.Add(new SqlParameter("@opremark", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_order_planExample.opname))
{
list_param.Add(new SqlParameter("@opname", basic_order_planExample.opname));
}
else
{
list_param.Add(new SqlParameter("@opname", DBNull.Value));
}
SqlParameter[] param = new SqlParameter[list_param.Count];
int index = 0;
foreach (SqlParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
