/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "peixunban1"; * parameters[1].Value = "id"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 更新一条备注 /// </summary> public bool Update_beizhu(Maticsoft.Model.peixunban1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update peixunban1 set "); strSql.Append("beizhu=@beizhu "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.beizhu; parameters[1].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int id) { Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1(); Maticsoft.Model.peixunban1 model = bll.GetModel(id); id_load = model.id.ToString(); this.txtstart_time.Text = model.start_time.ToString(); this.txtend_time.Text = model.end_time.ToString(); this.txtname.Text = model.name; this.txtcontact.Text = model.contact; this.txtbeizhu.Text = model.beizhu; this.txtphone.Text = model.phone; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.peixunban1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update peixunban1 set "); strSql.Append("start_time=@start_time,"); strSql.Append("end_time=@end_time,"); strSql.Append("name=@name,"); strSql.Append("contact=@contact,"); strSql.Append("sinal=@sinal,"); strSql.Append("beizhu=@beizhu,"); strSql.Append("phone=@phone"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@start_time", SqlDbType.Date, 3), new SqlParameter("@end_time", SqlDbType.Date, 3), new SqlParameter("@name", SqlDbType.NChar, 50), new SqlParameter("@contact", SqlDbType.NChar, 10), new SqlParameter("@sinal", SqlDbType.Int, 4), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@phone", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.start_time; parameters[1].Value = model.end_time; parameters[2].Value = model.name; parameters[3].Value = model.contact; parameters[4].Value = model.sinal; parameters[5].Value = model.beizhu; parameters[6].Value = model.phone; parameters[7].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.peixunban1 DataRowToModel(DataRow row) { Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["start_time"] != null && row["start_time"].ToString() != "") { model.start_time = DateTime.Parse(row["start_time"].ToString()); } if (row["end_time"] != null && row["end_time"].ToString() != "") { model.end_time = DateTime.Parse(row["end_time"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["contact"] != null) { model.contact = row["contact"].ToString(); } if (row["sinal"] != null && row["sinal"].ToString() != "") { model.sinal = int.Parse(row["sinal"].ToString()); } if (row["beizhu"] != null) { model.beizhu = row["beizhu"].ToString(); } if (row["phone"] != null) { model.phone = row["phone"].ToString(); } } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtstart_time.Text)) { strErr += "start_time格式错误!\\n"; } if (!PageValidate.IsDateTime(txtend_time.Text)) { strErr += "end_time格式错误!\\n"; } if (this.txtname.Text.Trim().Length == 0) { strErr += "name不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } DateTime start_time = DateTime.Parse(this.txtstart_time.Text); DateTime end_time = DateTime.Parse(this.txtend_time.Text); string name = this.txtname.Text; Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1(); model.start_time = start_time; model.end_time = end_time; model.name = name; model.beizhu = beizhu.Text; model.contact = contact.Text; model.phone = phone.Text; model.sinal = Convert.ToInt16(sinal.SelectedValue); Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.peixunban1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into peixunban1("); strSql.Append("start_time,end_time,name,contact,sinal,beizhu,phone)"); strSql.Append(" values ("); strSql.Append("@start_time,@end_time,@name,@contact,@sinal,@beizhu,@phone)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@start_time", SqlDbType.Date, 3), new SqlParameter("@end_time", SqlDbType.Date, 3), new SqlParameter("@name", SqlDbType.NChar, 50), new SqlParameter("@contact", SqlDbType.NChar, 10), new SqlParameter("@sinal", SqlDbType.Int, 4), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@phone", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.start_time; parameters[1].Value = model.end_time; parameters[2].Value = model.name; parameters[3].Value = model.contact; parameters[4].Value = model.sinal; parameters[5].Value = model.beizhu; parameters[6].Value = model.phone; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public void loaddata() { if (Session["peixunban"] == null) { Response.Redirect("branch_add.aspx"); } else { if (Convert.ToInt16(Session["screen"]) == 1) { Literal_css.Text = "<link href='css/form_css.css' rel='stylesheet' type='text/css' />"; } else { Literal_css.Text = "<link href='css/form_moblie.css' rel='stylesheet' type='text/css' />"; } pxb = (Maticsoft.Model.peixunban1)Session["peixunban"]; num = Convert.ToInt16(pxb.beizhu); peixunbanid = pxb.id; Literal1.Text = pxb.name; cleaning_fee.Text = clean_fee(Convert.ToInt16(pxb.beizhu)).ToString(); fantang.Text = dingcan(Convert.ToDateTime(pxb.start_time), Convert.ToDateTime(pxb.end_time), Convert.ToInt16(pxb.beizhu)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.peixunban1 GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,start_time,end_time,name,contact,sinal,beizhu,phone from peixunban1 "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void ShowInfo(int id) { Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1(); Maticsoft.Model.peixunban1 model = bll.GetModel(id); this.lblstart_time.Text = Convert.ToDateTime(model.start_time.ToString()).ToShortDateString(); this.lblend_time.Text = Convert.ToDateTime(model.end_time.ToString()).ToShortDateString(); this.lblname.Text = model.name; contact.Text = model.contact; phone.Text = model.phone; beizhu.Text = model.beizhu; Maticsoft.BLL.branch_company bhc_bll = new BLL.branch_company(); Maticsoft.Model.branch_company bhc_mod = bhc_bll.GetModel_bypeixunban(id); start_detail.Text = bhc_mod.start_detail.ToString(); end_detail.Text = bhc_mod.end_detail.ToString(); num.Text = bhc_mod.num.ToString() + "人"; num_detail.Text = bhc_mod.num_detail.ToString(); cleaning_fee.Text = bhc_mod.cleaning_fee.ToString() + "元"; fapiao_taitou.Text = bhc_mod.fapiao_taitou.ToString(); basketball_time.Text = bhc_mod.basketball_time.ToString(); fantang.Text = bhc_mod.fantang.ToString(); fangka_print.Text = (bhc_mod.fangka_print == 1 ? "不打印名字" : "打印名字"); xishu_yongpin.Text = (bhc_mod.xishu_yongpin == 1 ? "简易洗漱用品" : "旅行套装"); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtstart_time.Text)) { strErr += "开始时间格式错误!\\n"; } if (!PageValidate.IsDateTime(txtend_time.Text)) { strErr += "结束时间格式错误!\\n"; } if (this.txtname.Text.Trim().Length == 0) { strErr += "培训班名称不能为空!\\n"; } if (this.txtcontact.Text.Trim().Length == 0) { strErr += "联系人不能为空!\\n"; } if (this.txtphone.Text.Trim().Length == 0) { strErr += "联系电话不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int id = int.Parse(id_load); DateTime start_time = DateTime.Parse(this.txtstart_time.Text); DateTime end_time = DateTime.Parse(this.txtend_time.Text); string name = this.txtname.Text; string contact = this.txtcontact.Text; int sinal = 2; string beizhu = this.txtbeizhu.Text; string phone = this.txtphone.Text; Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1(); model.id = id; model.start_time = start_time; model.end_time = end_time; model.name = name; model.contact = contact; model.sinal = sinal; model.beizhu = beizhu; model.phone = phone; Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1(); bll.Update(model); #region 开始branch_company表的数据更新 Maticsoft.BLL.branch_company bnc_bll = new BLL.branch_company(); Maticsoft.Model.branch_company bnc_mod = bnc_bll.GetModel_bypeixunban(id); if (this.txtstart_detail.Text.Trim().Length == 0) { strErr += "入住具体时间不能为空!\\n"; } if (this.txtend_detail.Text.Trim().Length == 0) { strErr += "退房具体时间不能为空!\\n"; } if (!PageValidate.IsNumber(txtnum.Text)) { strErr += "人数格式错误!\\n"; } if (!PageValidate.IsDecimal(txtcleaning_fee.Text)) { strErr += "清洁费用格式错误!\\n"; } if (this.txtfapiao_taitou.Text.Trim().Length == 0) { strErr += "发票抬头不能为空!\\n"; } if (this.txtfantang.Text.Trim().Length == 0) { strErr += "饭堂订餐不能为空!\\n"; } //if (!PageValidate.IsNumber(txtfangka_print.Text)) //{ // strErr += "fangka_print格式错误!\\n"; //} if (strErr != "") { MessageBox.Show(this, strErr); return; } string start_detail = this.txtstart_detail.Text; string end_detail = this.txtend_detail.Text; int num = int.Parse(this.txtnum.Text); string num_detail = this.txtnum_detail.Text; decimal cleaning_fee = decimal.Parse(this.txtcleaning_fee.Text); string fapiao_taitou = this.txtfapiao_taitou.Text; string basketball_time = this.txtbasketball_time.Text; string fantang = this.txtfantang.Text; //int fangka_print1 = int.Parse(this.txtfangka_print.Text); Maticsoft.Model.branch_company model_branch = new Maticsoft.Model.branch_company(); model_branch.id = bnc_mod.id; model_branch.peixunban_id = id; model_branch.start_detail = start_detail; model_branch.end_detail = end_detail; model_branch.num = num; model_branch.num_detail = num_detail; model_branch.cleaning_fee = cleaning_fee; model_branch.fapiao_taitou = fapiao_taitou; model_branch.basketball_time = basketball_time; model_branch.fantang = fantang; model_branch.fangka_print = Convert.ToInt16(fangka_print.SelectedValue); model_branch.fengongsi = bnc_mod.fengongsi; model_branch.date = DateTime.Today; model_branch.xishu_yongpin = Convert.ToInt16(xishu.SelectedValue); Maticsoft.BLL.branch_company bll_branch = new Maticsoft.BLL.branch_company(); bll_branch.Update(model_branch); #endregion Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }