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