public static SqlParameter[] Param(Model.H_Order model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ispaystudent", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_stu_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@pay_stu_time", SqlDbType.DateTime),
new SqlParameter("@ispayclerk", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_cle_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@pay_cle_time", SqlDbType.DateTime),
new SqlParameter("@ispayservice", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_ser_time", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.ispaystudent;
parameters[1].Value = model.pay_stu_handler;
parameters[2].Value = model.pay_stu_time;
parameters[3].Value = model.ispayclerk;
parameters[4].Value = model.pay_cle_handler;
parameters[5].Value = model.pay_cle_time;
parameters[6].Value = model.ispayservice;
parameters[7].Value = model.pay_ser_time;
parameters[8].Value = model.id;
return(parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Model.H_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update H_Order set ");
strSql.Append("order_number=@order_number,");
strSql.Append("username=@username,");
strSql.Append("course_id=@course_id,");
strSql.Append("create_time=@create_time,");
strSql.Append("isexam=@isexam,");
strSql.Append("exam_handler=@exam_handler,");
strSql.Append("exam_time=@exam_time,");
strSql.Append("ispaystudent=@ispaystudent,");
strSql.Append("pay_stu_handler=@pay_stu_handler,");
strSql.Append("pay_stu_time=@pay_stu_time,");
strSql.Append("ispayclerk=@ispayclerk,");
strSql.Append("pay_cle_handler=@pay_cle_handler,");
strSql.Append("pay_cle_time=@pay_cle_time,");
strSql.Append("ispayservice=@ispayservice,");
strSql.Append("pay_ser_time=@pay_ser_time");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@order_number", SqlDbType.NVarChar, 50),
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@course_id", SqlDbType.Int, 4),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@isexam", SqlDbType.TinyInt, 1),
new SqlParameter("@exam_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@exam_time", SqlDbType.DateTime),
new SqlParameter("@ispaystudent", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_stu_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@pay_stu_time", SqlDbType.DateTime),
new SqlParameter("@ispayclerk", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_cle_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@pay_cle_time", SqlDbType.DateTime),
new SqlParameter("@ispayservice", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_ser_time", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.order_number;
parameters[1].Value = model.username;
parameters[2].Value = model.course_id;
parameters[3].Value = model.create_time;
parameters[4].Value = model.isexam;
parameters[5].Value = model.exam_handler;
parameters[6].Value = model.exam_time;
parameters[7].Value = model.ispaystudent;
parameters[8].Value = model.pay_stu_handler;
parameters[9].Value = model.pay_stu_time;
parameters[10].Value = model.ispayclerk;
parameters[11].Value = model.pay_cle_handler;
parameters[12].Value = model.pay_cle_time;
parameters[13].Value = model.ispayservice;
parameters[14].Value = model.pay_ser_time;
parameters[15].Value = model.id;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0);
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["qx"];
if (cookie != null)
{
qx = cookie.Values["qxid"].ToString();
username = HttpUtility.UrlDecode(cookie.Values["user"].ToString(), Encoding.UTF8);
if (qx == "3" || qx == "4")
{
Response.Redirect("Error.aspx");
}
}
if (Request.Form["idArray"] != null)
{
string idArray = Request.Form["idArray"].ToString();
string[] split = idArray.Split(new char[] { '|' });
Dictionary <string, SqlParameter[]> dic = new Dictionary <string, SqlParameter[]>();
foreach (string pid in split)
{
if (pid != "")
{
Model.H_Order order = H_OrderClass.GetModel(pid);
order.id = int.Parse(pid);
order.ispaystudent = 1;
order.pay_stu_handler = username;
order.pay_stu_time = System.DateTime.Now;
dic.Add(pid, H_OrderClass.Param(order));
}
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update H_Order set ");
strSql.Append("ispaystudent=@ispaystudent,");
strSql.Append("pay_stu_handler=@pay_stu_handler,");
strSql.Append("pay_stu_time=@pay_stu_time");
strSql.Append(" where id=@id");
if (DbHelperSQL.ExecuteSqlTran(strSql.ToString(), dic))
{
Response.Write(Tool.CreateJson("操作成功！", "1"));
}
else
{
Response.Write(Tool.CreateJson("操作失败！", "2"));
}
}
else
{
Response.Write(Tool.CreateJson("缺少参数", "3"));
}
Response.End();
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(Model.H_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into H_Order(");
strSql.Append("order_number,username,course_id,create_time,isexam,exam_handler,exam_time,ispaystudent,pay_stu_handler,pay_stu_time,ispayclerk,pay_cle_handler,pay_cle_time,ispayservice,pay_ser_time)");
strSql.Append(" values (");
strSql.Append("@order_number,@username,@course_id,@create_time,@isexam,@exam_handler,@exam_time,@ispaystudent,@pay_stu_handler,@pay_stu_time,@ispayclerk,@pay_cle_handler,@pay_cle_time,@ispayservice,@pay_ser_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@order_number", SqlDbType.NVarChar, 50),
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@course_id", SqlDbType.Int, 4),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@isexam", SqlDbType.TinyInt, 1),
new SqlParameter("@exam_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@exam_time", SqlDbType.DateTime),
new SqlParameter("@ispaystudent", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_stu_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@pay_stu_time", SqlDbType.DateTime),
new SqlParameter("@ispayclerk", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_cle_handler", SqlDbType.NVarChar, 50),
new SqlParameter("@pay_cle_time", SqlDbType.DateTime),
new SqlParameter("@ispayservice", SqlDbType.TinyInt, 1),
new SqlParameter("@pay_ser_time", SqlDbType.DateTime)
};
parameters[0].Value = model.order_number;
parameters[1].Value = model.username;
parameters[2].Value = model.course_id;
parameters[3].Value = model.create_time;
parameters[4].Value = model.isexam;
parameters[5].Value = model.exam_handler;
parameters[6].Value = model.exam_time;
parameters[7].Value = model.ispaystudent;
parameters[8].Value = model.pay_stu_handler;
parameters[9].Value = model.pay_stu_time;
parameters[10].Value = model.ispayclerk;
parameters[11].Value = model.pay_cle_handler;
parameters[12].Value = model.pay_cle_time;
parameters[13].Value = model.ispayservice;
parameters[14].Value = model.pay_ser_time;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0);
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.H_Order order = new Model.H_Order();
order.course_id = int.Parse(this.HiddenCourse.Value);
order.order_number = this.TextOrder_num.Value.Trim();
order.username = username;
order.isexam = 0;
order.ispaystudent = 0;
order.ispayservice = 0;
order.ispayclerk = 0;
order.create_time = System.DateTime.Now;
if (H_OrderClass.Add(order))
{
JScript.AlertAndRedirect("操作成功！", "OrderList.aspx", this);
}
else
{
JScript.Alert("操作失败！", "a2", this);
}
}
public void InitData()
{
if (Request.QueryString["pid"] != null)
{
pid = Request.QueryString["pid"].ToString();
Model.H_Order order = H_OrderClass.GetModel(pid);
this.TextOrder_num.Value = order.order_number;
sub_courseID = order.course_id.ToString();
detail_courseID = order.course_id.ToString();
string subBasicID = "select subordinate_course_id from H_Detail_Course where id=" + sub_courseID;
sub_courseID = DbHelperSQL.GetSingle(subBasicID).ToString();
string getBasicID = "select father from H_Subordinate_Course where id=" + sub_courseID;
basic_courseID = DbHelperSQL.GetSingle(getBasicID).ToString();
// this.TextOrder_num.Value = H_OrderClass.GetModel(Request.QueryString["pid"].ToString()).order_number;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static Model.H_Order GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,order_number,username,course_id,create_time,isexam,exam_handler,exam_time,ispaystudent,pay_stu_handler,pay_stu_time,ispayclerk,pay_cle_handler,pay_cle_time,ispayservice,pay_ser_time from H_Order ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.H_Order model = new Model.H_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.order_number = ds.Tables[0].Rows[0]["order_number"].ToString();
model.username = ds.Tables[0].Rows[0]["username"].ToString();
if (ds.Tables[0].Rows[0]["course_id"].ToString() != "")
{
model.course_id = int.Parse(ds.Tables[0].Rows[0]["course_id"].ToString());
}
if (ds.Tables[0].Rows[0]["create_time"].ToString() != "")
{
model.create_time = DateTime.Parse(ds.Tables[0].Rows[0]["create_time"].ToString());
}
if (ds.Tables[0].Rows[0]["isexam"].ToString() != "")
{
model.isexam = int.Parse(ds.Tables[0].Rows[0]["isexam"].ToString());
}
model.exam_handler = ds.Tables[0].Rows[0]["exam_handler"].ToString();
if (ds.Tables[0].Rows[0]["exam_time"].ToString() != "")
{
model.exam_time = DateTime.Parse(ds.Tables[0].Rows[0]["exam_time"].ToString());
}
if (ds.Tables[0].Rows[0]["ispaystudent"].ToString() != "")
{
model.ispaystudent = int.Parse(ds.Tables[0].Rows[0]["ispaystudent"].ToString());
}
model.pay_stu_handler = ds.Tables[0].Rows[0]["pay_stu_handler"].ToString();
if (ds.Tables[0].Rows[0]["pay_stu_time"].ToString() != "")
{
model.pay_stu_time = DateTime.Parse(ds.Tables[0].Rows[0]["pay_stu_time"].ToString());
}
if (ds.Tables[0].Rows[0]["ispayclerk"].ToString() != "")
{
model.ispayclerk = int.Parse(ds.Tables[0].Rows[0]["ispayclerk"].ToString());
}
model.pay_cle_handler = ds.Tables[0].Rows[0]["pay_cle_handler"].ToString();
if (ds.Tables[0].Rows[0]["pay_cle_time"].ToString() != "")
{
model.pay_cle_time = DateTime.Parse(ds.Tables[0].Rows[0]["pay_cle_time"].ToString());
}
if (ds.Tables[0].Rows[0]["ispayservice"].ToString() != "")
{
model.ispayservice = int.Parse(ds.Tables[0].Rows[0]["ispayservice"].ToString());
}
if (ds.Tables[0].Rows[0]["pay_ser_time"].ToString() != "")
{
model.pay_ser_time = DateTime.Parse(ds.Tables[0].Rows[0]["pay_ser_time"].ToString());
}
return(model);
}
else
{
return(null);
}
}
