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