public static liness FindLines(string id) { string sql; OleDbConnection conn = new OleDbConnection(db.constring()); sql = string.Format("select * from po_lines_all where po_line_id={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 { liness line = new liness(); line.line_id = id; line.head_id = dr[1].ToString(); line.num = dr[2].ToString(); line.code = dr[3].ToString(); line.quantity = dr[4].ToString(); line.requantity = dr[5].ToString(); line.price = dr[6].ToString(); dr.Close(); conn.Close(); return(line); } }
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { txblineid.Text = GridView2.SelectedDataKey.Values[0].ToString(); liness line = new liness(); line = liness.FindLines(txblineid.Text); if (line == null) { string mess = "选择数据出错!!"; string url = "require.aspx"; Response.Write(message.MessageAndUrl(mess, url)); } else { GridView2.Visible = true; btnlineadd.Visible = true; btnlineupdate.Visible = true; btnlinedelete.Visible = true; btnshowhead.Visible = true; txbheadid2.Text = line.head_id; txbitemnum.Text = line.num; txblinenum.Text = line.code; txbquantity.Text = line.quantity; txbprice.Text = line.price; } }
protected void btnlineupdatepost_Click(object sender, EventArgs e) { string mess; liness line = new liness(); line.line_id = txblineid.Text; line.head_id = txbheadid2.Text; line.code = txbitemnum.Text; line.num = txblinenum.Text; line.quantity = txbquantity.Text; line.requantity = txbrequantity.Text; line.price = txbprice.Text; if (txbheadid2.Text == "" || txbitemnum.Text == "" || txblinenum.Text == "" || txbquantity.Text == "" || txbprice.Text == "") { mess = "请将信息填写完整!"; Response.Write(message.goBack(mess)); } else { try { int.Parse(txbheadid2.Text); int.Parse(txbitemnum.Text); int.Parse(txblinenum.Text); int.Parse(txbquantity.Text); int.Parse(txbrequantity.Text); float.Parse(txbprice.Text); if (liness.FindUpheader(txbheadid2.Text) == false) { mess = "订单头编号不存在!!"; Response.Write(message.goBack(mess)); } else { if (liness.FindUpItem(txbitemnum.Text) == true) { liness.UpdateLine(line); mess = "订单行修改成功!!"; string url = "order.aspx"; Response.Write(message.MessageAndUrl(mess, url)); } else { mess = "物品编号不存在!!"; Response.Write(message.goBack(mess)); } } } catch { mess = "每个输入框中只能输入数字!!!"; Response.Write(message.goBack(mess)); } } }
public static void UpdateLine(liness line) { string sql; OleDbConnection conn = new OleDbConnection(db.constring()); sql = string.Format("update po_lines_all set po_header_id='" + line.head_id + "',line_num='" + line.num + "',item_num='" + line.code + "',Quantity='" + line.quantity + "',received_quantity='" + line.requantity + "',price='" + line.price + "' where po_line_id= '" + line.line_id + "'"); OleDbCommand command = new OleDbCommand(sql, conn); conn.Open(); command.ExecuteNonQuery(); conn.Close(); }
public static void InsertLines(liness line) { string sql; OleDbConnection conn = new OleDbConnection(db.constring()); sql = string.Format("insert into po_lines_all(po_header_id,line_num,item_num,Quantity,received_quantity,price)values('" + line.head_id + "','" + line.num + "','" + line.code + "','" + line.quantity + "','" + line.requantity + "','" + line.price + "')"); OleDbCommand command = new OleDbCommand(sql, conn); conn.Open(); command.ExecuteNonQuery(); conn.Close(); }