protected void btnaddpost_Click(object sender, EventArgs e)
{
string mess;
vender ven = new vender();
ven.vender_code = txbcode.Text;
ven.vender_name = txbname.Text;
ven.address = txbaddress.Text;
ven.contact = txbcontact.Text;
ven.phone = txbphone.Text;
if (txbname.Text == "" || txbaddress.Text == "" || txbcontact.Text == "" || txbphone.Text == "")
{
mess = "请将信息填写完整！！！";
Response.Write(message.goBack(mess));
}
else
{
try
{
int.Parse(txbphone.Text);
vender.InsertVender(ven);
mess = "新供应商添加成功！！！";
string url = "vendersManage.aspx";
Response.Write(message.MessageAndUrl(mess, url));
}
catch
{
mess = "电话号码只能是数字";
Response.Write(message.goBack(mess));
}
}
}
public static vender FindCode(string id)
{
string sql;
OleDbConnection conn = new OleDbConnection(db.constring());
sql = string.Format("select * from po_venders_all where vender_code={0}", id);
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader dr = command.ExecuteReader();
if (dr.Read() == false)
{
dr.Close();
conn.Close();
return(null);
}
else
{
vender ven = new vender();
ven.vender_code = id;
ven.vender_name = dr[1].ToString();
ven.address = dr[2].ToString();
ven.contact = dr[3].ToString();
ven.phone = dr[4].ToString();
dr.Close();
conn.Close();
return(ven);
}
}
public ActionResult _DeleteConfirmed(int id)
{
vender vender = db.vender.Find(id);
db.vender.Remove(vender);
db.SaveChanges();
return(RedirectToAction("Index", new { company = vender.company }));
}
public ActionResult _Edit([Bind(Include = "id,company,contact,title,email,tel_office,tel_mobile,fax,quick_no,note")] vender vender)
{
if (ModelState.IsValid)
{
db.Entry(vender).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { company = vender.company }));
}
return(PartialView(vender));
}
public ActionResult Create([Bind(Include = "id,company,contact,title,email,tel_office,tel_mobile,fax,quick_no,note")] vender vender)
{
if (ModelState.IsValid)
{
db.vender.Add(vender);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vender));
}
public static void UpdateVender(vender ven)
{
string sql;
OleDbConnection conn = new OleDbConnection(db.constring());
sql = string.Format("update po_venders_all set vender_name='" + ven.vender_name + "',address='" + ven.address + "',contact='" + ven.contact + "',phone='" + ven.phone + "' where vender_code= '" + ven.vender_code + "'");
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
public static void InsertVender(vender ven)
{
string sql;
OleDbConnection conn = new OleDbConnection(db.constring());
sql = string.Format("insert into po_venders_all(vender_name,address,contact,phone)values('" + ven.vender_name + "','" + ven.address + "','" + ven.contact + "','" + ven.phone + "')");
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
// GET: Contacts/Details/5
public ActionResult _Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
vender vender = db.vender.Find(id);
if (vender == null)
{
return(HttpNotFound());
}
return(PartialView(vender));
}
// GET: Contacts/Edit/5
public ActionResult _Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
vender vender = db.vender.Find(id);
if (vender == null)
{
return(HttpNotFound());
}
ViewBag.dept = GetVenderList(vender.company);
return(PartialView(vender));
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
txbcode.Text = GridView1.SelectedDataKey.Values[0].ToString();
vender ven = new vender();
ven = vender.FindCode(txbcode.Text);
if (ven == null)
{
string mess = "选择数据出错！！";
string url = "vendersManage.aspx";
Response.Write(message.MessageAndUrl(mess, url));
}
else
{
txbname.Text = ven.vender_name;
txbaddress.Text = ven.address;
txbcontact.Text = ven.contact;
txbphone.Text = ven.phone;
}
}
