protected void Page_Load(object sender, EventArgs e) { if (Session["Usermanager"] == null) { Response.Redirect("~/Login.aspx"); } else { if (!IsPostBack) { //判断是否为编辑 if (Request.QueryString["Cid"] != null) { int Cid = Convert.ToInt32(Request.QueryString["Cid"]); //获取前页面所传Cid的公司信息 CarrieCompanyTB CarrCom = CarCom.GetCompanyByid(Cid); txtCoName.Text = CarrCom.CoName.ToString(); txtMan.Text = CarrCom.Clinkman.ToString(); txtTel.Text = CarrCom.LinkmanTel.ToString(); txtMoney.Text = CarrCom.Cmoney.ToString(); txtRemark.Text = CarrCom.Remark.ToString(); } } } }
//获取当前文本框的值 public CarrieCompanyTB Getparm() { CarrieCompanyTB CCom = new CarrieCompanyTB(); CCom.CoName = txtCoName.Text.Trim(); CCom.Clinkman = txtMan.Text.Trim(); CCom.LinkmanTel = txtTel.Text.Trim(); CCom.Cmoney = Convert.ToDouble(txtMoney.Text); CCom.Remark = txtRemark.Text.Trim(); return(CCom); }
//根据公司名查看是否已有该公司 public int SelectCarrieCompanyByCoName(string CoName) { CarrieCompanyTB car = ccs.selectIsHaveCarrieCompany(CoName); if (car.CoName == null) { return(0); } else { return(1); } }
//插入新的公司 public int InsertCarrieCompany(CarrieCompanyTB cacom) { string str = "insert into CarrieCompanyTB values (@CoName,@Clinkman,@LinkmanTel,@Cmoney,@Remark)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CoName", cacom.CoName), new SqlParameter("@Clinkman", cacom.Clinkman), new SqlParameter("@LinkmanTel", cacom.LinkmanTel), new SqlParameter("@Cmoney", cacom.Cmoney), new SqlParameter("@Remark", cacom.Remark) }; return(DBHelper.ExecuteCommand(str, para)); }
//根据Cid修改公司内容 public int UpdateCarrieCompanyByCid(int Cid, CarrieCompanyTB cacom) { string str = "Update CarrieCompanyTB set CoName=@CoName,Clinkman=@Clinkman,LinkmanTel=@LinkmanTel,Cmoney=@Cmoney,Remark=@Remark where Cid=@Cid"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Cid", Cid), new SqlParameter("@CoName", cacom.CoName), new SqlParameter("@Clinkman", cacom.Clinkman), new SqlParameter("@LinkmanTel", cacom.LinkmanTel), new SqlParameter("@Cmoney", cacom.Cmoney), new SqlParameter("@Remark", cacom.Remark) }; return(DBHelper.ExecuteCommand(str, para)); }
//获取信息 private static List <CarrieCompanyTB> GetCarrieCompanyBySql(string strsql) { List <CarrieCompanyTB> list = new List <CarrieCompanyTB>(); DataTable table = DBHelper.GetTable(strsql); foreach (DataRow row in table.Rows) { CarrieCompanyTB cc = new CarrieCompanyTB(); cc.Cid = Convert.ToInt32(row["Cid"]); cc.CoName = row["CoName"].ToString(); cc.Clinkman = row["Clinkman"].ToString(); cc.LinkmanTel = row["LinkmanTel"].ToString(); cc.Cmoney = Convert.ToDouble(row["Cmoney"]); cc.Remark = row["Remark"].ToString(); list.Add(cc); } return(list); }
//根据coName查询是否已有该公司 public CarrieCompanyTB selectIsHaveCarrieCompany(string CoName) { string str = "select * from CarrieCompanyTB where CoName=@CoName"; CarrieCompanyTB carcom = new CarrieCompanyTB(); try { DataTable dt = DBHelper.GetTable(str, new SqlParameter("@CoName", CoName)); foreach (DataRow row in dt.Rows) { carcom.Cid = Convert.ToInt32(row["Cid"]); carcom.CoName = (string)row["coName"]; carcom.Clinkman = (string)row["Clinkman"]; carcom.LinkmanTel = (string)row["LinkmanTel"]; carcom.Cmoney = Convert.ToDouble(row["Cmoney"]); carcom.Remark = (row["Remark"] == DBNull.Value) ? "" : row[5].ToString(); } return(carcom); } catch (Exception e) { throw e; } }
public static void ExportExcel <T>(List <T> objList, string FileName, Dictionary <string, string> columnInfo) { if (columnInfo.Count == 0) { return; } if (objList.Count == 0) { return; } //生成EXCEL的HTML string excelStr = ""; Type myType = objList[0].GetType(); //根据反射从传递进来的属性名信息得到要显示的属性 //根据反射从传递进来的属性名信息得到要显示的属性 List <PropertyInfo> myPro = new List <PropertyInfo>(); foreach (string cName in columnInfo.Keys) { PropertyInfo p = myType.GetProperty(cName); if (p != null) { myPro.Add(p); excelStr += columnInfo[cName] + "\t"; } } //如果没有找到可用的属性则结束 if (myPro.Count == 0) { return; } excelStr += "\n"; foreach (T obj in objList) { foreach (PropertyInfo p in myPro) { string str = ""; Object objec = p.GetValue(obj, null); if (objec != null) { //判断objec是否是外键对象类型,如果不是,直接返回 if (Type.GetTypeCode(objec.GetType()) == TypeCode.String || Type.GetTypeCode(objec.GetType()) == TypeCode.Int64 || Type.GetTypeCode(objec.GetType()) == TypeCode.Int32 || Type.GetTypeCode(objec.GetType()) == TypeCode.Double || Type.GetTypeCode(objec.GetType()) == TypeCode.DBNull) { str = objec.ToString().Trim(); } else if (Type.GetTypeCode(objec.GetType()) == TypeCode.DateTime) { str = Convert.ToDateTime(objec).ToString("yyyy-M-d"); } else { CustomersTB Customers = objec as CustomersTB; if (Customers != null) { str = GetObjectPropertyValue(Customers); } else { CarrieCompanyTB carriecompany = objec as CarrieCompanyTB; if (carriecompany != null) { str = GetObjectPropertyValue(carriecompany); } } } if ((p.Name == "CusTel" || p.Name == "Telephone" || p.Name == "LinkmanTel" || p.Name == "BeginNo" || p.Name == "Rid" || p.Name == "CSid" || p.Name == "EndNo") && str != "") { excelStr += "'" + str + "\t"; } else { excelStr += str + "\t"; } } else { excelStr += "\t"; } } excelStr += "\n"; } //输出Excel HttpResponse rs = System.Web.HttpContext.Current.Response; rs.Clear(); rs.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); rs.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)); rs.ContentType = "application/ms-excel"; rs.Write(excelStr); rs.End(); }
//插入新的公司 public int InsertCarrieCompany(CarrieCompanyTB cacom) { return(ccs.InsertCarrieCompany(cacom)); }
//根据Cid修改公司内容 public int UpdateCarrieCompanyByCid(int Cid, CarrieCompanyTB cacom) { return(ccs.UpdateCarrieCompanyByCid(Cid, cacom)); }
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; } } } }