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