//自定义方法 private List <RegisterTB> GetAllRegisterTBBySql(string strsql) { //实例化范集合 List <RegisterTB> allRegisterTB = new List <RegisterTB>(); //填充数据集 DataTable dt = DBHelper.GetTable(strsql); //遍历集合 foreach (DataRow row in dt.Rows) { //实例化类 RegisterTB reg = new RegisterTB(); reg.Rid = Convert.ToInt32(row["Rid"]); reg.Cid = Convert.ToInt32(row["Cid"]); reg.BeginNo = (long)row["BeginNo"]; reg.EndNo = (long)row["EndNo"]; reg.Buydate = Convert.ToDateTime(row["BuyDate"]); reg.Remark = (row["Remark"] == DBNull.Value) ? "" : row["Remark"].ToString(); reg.CCompany = CCom.GetCompanyByid(Convert.ToInt32(row["Cid"])); allRegisterTB.Add(reg); } return(allRegisterTB); }
protected void TmgBtnExit_Click(object sender, ImageClickEventArgs e) { if (Page.IsValid) { string cid = ddlCarrieCompany.SelectedValue.ToString(); string b = txtBeginNo.Text.Trim(); string end = txtEndNo.Text.Trim(); int cntt = regMan.number(cid, b, end); if (cntt > 0) { lblok.Visible = true; lblok.Text = "该公司的面单号已将购买!!!"; return; } //实例化实体类 string time = DateTime.Now.ToString(); RegisterTB reg = new RegisterTB(); reg.Cid = Convert.ToInt32(ddlCarrieCompany.SelectedValue); reg.BeginNo = Convert.ToInt64(txtBeginNo.Text.Trim()); reg.EndNo = Convert.ToInt64(txtEndNo.Text.Trim()); reg.Buydate = Convert.ToDateTime(time); reg.Remark = txtRemark.Text; //添加房间信息添加成功清空控件 if (Request.QueryString["Rid"] == null) { if (Page.IsValid == true) { int cnt = regMan.InsertRegister(reg); if (cnt > 0) { lblmessage.Visible = true; lblmessage.Text = "添加成功!"; txtBeginNo.Text = ""; txtEndNo.Text = ""; txtDate.Text = ""; txtRemark.Text = ""; } } } //修改功能 else { string Rid = Request.QueryString["Rid"].ToString(); reg.Rid = Convert.ToInt32(Rid); int cnt = regMan.UpdateRegisterTB(reg); txtDate.Visible = true; string times = txtDate.Text.Trim(); reg.Buydate = Convert.ToDateTime(times); if (cnt > 0) { lblmessage.Visible = true; lblmessage.Text = "修改成功!"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Usermanager"] == null) { Response.Redirect("~/Login.aspx"); } else { if (!IsPostBack) { //填充DropDownlist控件 this.ddlCarrieCompany.DataSource = ComMan.GetAllCarrieCompany(); this.ddlCarrieCompany.DataTextField = "CoName"; this.ddlCarrieCompany.DataValueField = "Cid"; ddlCarrieCompany.DataBind(); //传过来的id不为空执行删除功能 if (Request.QueryString["Rid"] != null) { txtDate.Visible = true; string Rid = Request.QueryString["Rid"].ToString(); RegisterTB Regg = new RegisterTB(); Regg = regMan.GetAllTBByRid(Rid); ddlCarrieCompany.SelectedValue = Regg.Cid.ToString(); txtBeginNo.Text = Regg.BeginNo.ToString(); txtEndNo.Text = Regg.EndNo.ToString(); txtDate.Text = Regg.Buydate.ToString(); txtRemark.Text = Regg.Remark; } //清空控件 else { txtDate.Visible = false; txtBeginNo.Text = ""; txtEndNo.Text = ""; txtDate.Text = ""; txtRemark.Text = ""; } lblmessage.Visible = false; lblok.Visible = false; } } }
//插入面单购买的面单 public int InsertRegister(RegisterTB reg) { //拼写连接串 string strsql = "insert into RegisterTB values(@Cid,@BeginNo,@EndNo,@Buydate,@Remark)"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Cid", reg.Cid), new SqlParameter("@BeginNo", reg.BeginNo), new SqlParameter("@EndNo", reg.EndNo), new SqlParameter("@Buydate", reg.Buydate), new SqlParameter("@Remark", reg.Remark) }; return(DBHelper.ExecuteCommand(strsql, para)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
//修改面单购买信息 public int UpdateRegisterTB(RegisterTB reg) { //拼写连接串 string strsql = "update RegisterTB set Cid=@Cid,BeginNo=@BeginNo,EndNo=@EndNo,Buydate=@Buydate,Remark=@Remark where Rid=@Rid"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Rid", reg.Rid), new SqlParameter("@Cid", reg.Cid), new SqlParameter("@BeginNo", reg.BeginNo), new SqlParameter("@EndNo", reg.EndNo), new SqlParameter("@Buydate", reg.Buydate), new SqlParameter("@Remark", reg.Remark) }; return(DBHelper.ExecuteCommand(strsql, para)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Usermanager"] == null) { Response.Redirect("~/Login.aspx"); } else { if (!IsPostBack) { //填充DropDownlist控件客户 this.ddlCustomer.DataSource = CusMan.GetAllCustomers(); this.ddlCustomer.DataTextField = "CusName"; this.ddlCustomer.DataValueField = "CusID"; ddlCustomer.DataBind(); //填充DropDownlist控件承运公司 this.ddlCompany.DataSource = ComMan.GetAllCarrieCompany(); this.ddlCompany.DataTextField = "CoName"; this.ddlCompany.DataValueField = "Cid"; ddlCompany.DataBind(); //控件窗体加载不显示 lblmessage.Visible = false; lblerror.Visible = false; //判断页面跳转传过来是否有Nid if (Request.QueryString["Nid"] == null) { if (Request.QueryString["rid"] != null) { txtBeginNo.Text = Request.QueryString["rid"]; txtEndNo.Text = Request.QueryString["rid"]; RegisterTB rt = new RegisterTB(); rt = regMan.GetAllRegisterTBByRid(Convert.ToInt64(Request.QueryString["rid"])); ddlCompany.SelectedValue = rt.Cid.ToString(); CarrieCompanyTB cct = new CarrieCompanyTB(); cct = ccm.GetCompanyByid(Convert.ToInt32(ddlCompany.SelectedValue)); txtmoney.Text = cct.Cmoney.ToString(); } else { txtDate.Visible = false; //清空所有的控件 txtBeginNo.Text = ""; txtEndNo.Text = ""; txtmoney.Text = ""; txtDate.Text = ""; txtRemark.Text = ""; } } else { //接受页面穿的值 int Nid = Convert.ToInt32(Request.QueryString["Nid"].ToString()); //实例化实体类 DisNoteTB disno = new DisNoteTB(); //调用方法查询记录 disno = DIsNtMan.GetByNidDisNoteTB(Nid); ddlCustomer.SelectedValue = disno.CusID.ToString(); ddlCompany.SelectedValue = disno.Cid.ToString(); txtBeginNo.Text = disno.BeginNo.ToString(); txtEndNo.Text = disno.EndNo.ToString(); txtDate.Text = disno.Dtime.ToString(); txtmoney.Text = disno.Sum.ToString(); if (disno.IsSet == "是") { rdoNo.Checked = true; } if (disno.IsSet == "否") { rdoNo.Checked = true; } txtRemark.Text = disno.Remark; } } } }
//修改面单购买信息 public int UpdateRegisterTB(RegisterTB reg) { return(registerTBService.UpdateRegisterTB(reg)); }
//插入面单购买信息 public int InsertRegister(RegisterTB reg) { return(registerTBService.InsertRegister(reg)); }