/// <summary>
/// 以sql查询结果填充下拉列表
/// </summary>
/// <param name="sql"></param>
/// <param name="cbox"></param>
public static void fillComboBox(string sql, ComboBox cbox)
{
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
Dictionary<int, string> Dict = new Dictionary<int, string>();
foreach (DataRow dr in dt.Rows)
{
int id = (int)dr.ItemArray[0];
string com_name = dr.ItemArray[1].ToString();
Dict.Add(id, com_name);
}
BindingSource bs = new BindingSource();
bs.DataSource = Dict;
cbox.DataSource = bs;
cbox.ValueMember = "Key";
cbox.DisplayMember = "Value";
}
/// <summary>
/// 通过按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_pass_Click(object sender, EventArgs e)
{
AccessDB adb = new AccessDB();
string query = "select sum(HW_TOTALPRICE) from OSM_HW where OFFERSHEET_CODE = '" + offerSheetCode + "'";
DataTable dt = adb.SQLTableQuery(query);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
double require_payment = 0;
try
{
require_payment = double.Parse(dr[0].ToString());
}
catch (Exception exception)
{
MessageBox.Show("该报价单没有对应的货物列表，无法通过审核！" + exception.ToString(), "警告");
return;
}
//生成订单存入数据库
string insertSQL = "insert into OSM_ORDER_SHEET(OFFERSHEET_ID,ORDER_STATE,REQUIRE_PAYMENT,ORDER_DATE,PAY_STATE) values ('" + offerSheetID + "','1'," + require_payment + ",#" + DateTime.Now.ToString("yyyy-MM-dd") + "#,'1')";
if (adb.SQLExecute(insertSQL))
{
MessageBox.Show("已将审核通过的报价单生成订单","消息");
string sql = "update OSM_OFFER_SHEET set OFFERSHEET_STATE = '2' where ID = " + offerSheetID;
if (adb.SQLExecute(sql))
{
main_form.TSMItem_offer_aduit_Refresh();
this.Close();
this.Dispose();
}
}
}
else
{
MessageBox.Show("该报价单没有对应的货物列表，无法通过审核！", "警告");
}
}
/// <summary>
/// 以sql查询结果填充下拉列表
/// </summary>
/// <param name="sql"></param>
/// <param name="cbox"></param>
public static void fillComboBox(string sql, ComboBox cbox)
{
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
Dictionary <int, string> Dict = new Dictionary <int, string>();
foreach (DataRow dr in dt.Rows)
{
int id = (int)dr.ItemArray[0];
string com_name = dr.ItemArray[1].ToString();
Dict.Add(id, com_name);
}
BindingSource bs = new BindingSource();
bs.DataSource = Dict;
cbox.DataSource = bs;
cbox.ValueMember = "Key";
cbox.DisplayMember = "Value";
}
/// <summary>
/// 检查是否可以发货，不能发货则生成对应的采购单
/// </summary>
/// <param name="hashList">货物列表</param>
/// <param name="order_id">订单ID</param>
/// <returns></returns>
private bool checkDelivery(List<Hashtable> hashList, string order_id)
{
List<Hashtable> purchaseList = new List<Hashtable>();
AccessDB adb = new AccessDB();
for (int i = 0; i < hashList.Count; i++)
{
Hashtable ht = hashList[i];
string product_id = ht["PRODUCT_ID"].ToString();
int hw_need_number = int.Parse(ht["HW_NUMBER"].ToString());
string sql = "select ID,HW_NUMBER from OSM_STORAGE where ID = " + product_id + "";
DataTable dt = adb.SQLTableQuery(sql);
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
int hw_storage_number = int.Parse(dr["HW_NUMBER"].ToString());
int hw_diff_number = hw_need_number - hw_storage_number;
if (hw_diff_number > 0)
{
string updateSQL = "update OSM_STORAGE set HW_NUMBER = 0 where ID = " + product_id;
adb.SQLExecute(updateSQL);
ht["HW_NUMBER"] = hw_diff_number;
purchaseList.Add(ht);
}
else
{
string updateSQL = "update OSM_STORAGE set HW_NUMBER = " + (-hw_diff_number) + " where ID = " + product_id;
adb.SQLExecute(updateSQL);
break;
}
}
else
{
ht["HW_NUMBER"] = hw_need_number;
purchaseList.Add(ht);
}
}
if (purchaseList.Count == 0)
{
//string insertSQL = "insert into OSM_DILIVERY_SHEET(ORDER_ID,DILIVERY_STATE) values(" + order_id + ",'1')";
//if (adb.SQLExecute(insertSQL))
//{
// return true;
//}
return true;
}
else
{
int count = createPurchaseSheet(purchaseList, order_id);
MessageBox.Show("库存不足，新增" + count + "条采购记录", "消息");
return false;
}
}
/// <summary>
/// 检查订单对应货物列表
/// </summary>
/// <param name="order_id">订单ID</param>
/// <param name="offersheet_code">报价单编号</param>
private void checkOfferHW(string order_id, string offersheet_code)
{
string sql = "select PRODUCT_ID,HW_NUMBER from OSM_HW where OFFERSHEET_CODE = '" + offersheet_code + "'";
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
List<Hashtable> hashList = new List<Hashtable>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
Hashtable ht = new Hashtable();
ht.Add("PRODUCT_ID", dr["PRODUCT_ID"]);
//ht.Add("HW_NAME", dr["HW_NAME"]);
//ht.Add("HW_CODE", dr["HW_CODE"]);
ht.Add("HW_NUMBER", dr["HW_NUMBER"]);
hashList.Add(ht);
}
if (checkDelivery(hashList, order_id))
{
//MessageBox.Show("根据与库存容量比对，可以发货！", "消息");
sql = "update OSM_ORDER_SHEET set ORDER_STATE = '3' where ID = " + order_id;
if (adb.SQLExecute(sql))
{
MessageBox.Show("库存充足,对应订单已可以进行发货审核！", "消息");
//查询订单视图返回结果
queryFromOrderSheetV(dataGridView_Order, "where ORDER_STATE = '1' ");
}
}
else
{
sql = "update OSM_ORDER_SHEET set ORDER_STATE = '2' where ID = " + order_id;
if (adb.SQLExecute(sql))
{
//查询订单视图返回结果
queryFromOrderSheetV(dataGridView_Order, "where ORDER_STATE = '1' ");
}
}
}
/// <summary>
/// 打开订单窗口可触发动作，显示读取到的数据
/// </summary>
/// <param name="ht"></param>
public void viewOrderSheet(Hashtable ht)
{
if (viewState == 0)
{
textBox_AlreadyPayment.ReadOnly = true;
textBox_PrePayment.ReadOnly = true;
textBox_RequirePayment.ReadOnly = true;
//textBox_AlreadyPayment.Enabled = false;
//textBox_PrePayment.Enabled = false;
//textBox_RequirePayment.Enabled = false;
comboBox_OrderState.Enabled = false;
comboBox_PayMode.Enabled = false;
comboBox_PayState.Enabled = false;
dateTimePicker_OrderDate.Enabled = false;
}
if (viewState == 1)
{
textBox_RequirePayment.ReadOnly = true;
comboBox_OrderState.Enabled = false;
comboBox_PayState.Enabled = false;
dateTimePicker_OrderDate.Enabled = false;
}
textBox_OfferSheetCode.Text = ht["OFFERSHEET_CODE"].ToString();
textBox_AlreadyPayment.Text = ht["ALREADY_PAYMENT"].ToString();
textBox_PrePayment.Text = ht["PRE_PAYMENT"].ToString();
textBox_RequirePayment.Text = ht["REQUIRE_PAYMENT"].ToString();
dateTimePicker_OrderDate.Text = ((DateTime)ht["ORDER_DATE"]).ToString("yyyy-MM-dd");
for (int i = 0; i < comboBox_OrderState.Items.Count; i++)
{
KeyValuePair<string, string> kv = (KeyValuePair<string, string>)comboBox_OrderState.Items[i];
if (ht["ORDER_STATE"].ToString() == kv.Key)
{
comboBox_OrderState.SelectedIndex = i;
break;
}
}
if (string.IsNullOrWhiteSpace(ht["PAY_MODE"].ToString()))
{
comboBox_PayMode.SelectedIndex = -1;
}
else
{
for (int i = 0; i < comboBox_PayMode.Items.Count; i++)
{
KeyValuePair<string, string> kv = (KeyValuePair<string, string>)comboBox_PayMode.Items[i];
if (ht["PAY_MODE"].ToString() == kv.Key)
{
comboBox_PayMode.SelectedIndex = i;
break;
}
}
}
for (int i = 0; i < comboBox_PayState.Items.Count; i++)
{
KeyValuePair<string, string> kv = (KeyValuePair<string, string>)comboBox_PayState.Items[i];
if (ht["PAY_STATE"].ToString() == kv.Key)
{
comboBox_PayState.SelectedIndex = i;
break;
}
}
string sql = "select * from OSM_HW_LIST_V where OFFERSHEET_CODE = '" + ht["OFFERSHEET_CODE"].ToString() + "'";
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
dataGridView_HW.AutoGenerateColumns = false;
dataGridView_HW.DataSource = dt;
}
/// <summary>
/// 产品选择下拉列表选择触发事件
/// 选择后将对应代码产品信息填入货物信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void comboBox_Product_SelectedIndexChanged(object sender, EventArgs e)
{
KeyValuePair<int, string> kv = (KeyValuePair<int, string>)comboBox_Product.SelectedItem;
int product_id = kv.Key;
string sql = "SELECT * FROM OSM_STORAGE WHERE ID = " + product_id;
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
textBox_HW_NAME.Text = dr["HW_NAME"].ToString();
textBox_HW_CODE.Text = dr["HW_CODE"].ToString();
for (int i = 0; i < comboBox_HW_TYPE.Items.Count; i++)
{
KeyValuePair<string, string> item = (KeyValuePair<string, string>)comboBox_HW_TYPE.Items[i];
if (item.Key == dr["HW_TYPE"].ToString())
{
comboBox_HW_TYPE.SelectedIndex = i;
break;
}
}
hw.setPRODUCT_ID(int.Parse(dr["ID"].ToString()));
}
}
/// <summary>
/// 到货确认按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_OK_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(purchase_id) && !string.IsNullOrWhiteSpace(product_id) && !string.IsNullOrWhiteSpace(order_id))
{
if (string.IsNullOrWhiteSpace(textBox_HWNumber.Text))
{
MessageBox.Show("请填写到货数量,谢谢！", "警告");
return;
}
int number_want = int.Parse(textBox_PurchaseNumber.Text);
int number_real = int.Parse(textBox_HWNumber.Text);
if (number_want > number_real)
{
//需采购数量大于到货数量，不能确认
MessageBox.Show("到货数量小于需求数量，无法确认到货！", "警告");
return;
}
else
{
//到货数量大于等于需采购数量,改变采购记录状态，改变库存数量
AccessDB adb = new AccessDB();
string sql = "select HW_NUMBER,REAL_NUMBER from OSM_STORAGE where ID = " + product_id;
DataTable dt = adb.SQLTableQuery(sql);
DataRow dr = dt.Rows[0];
int hw_number = int.Parse(dr["HW_NUMBER"].ToString());
int real_number = int.Parse(dr["REAL_NUMBER"].ToString());
real_number += number_real;
hw_number += number_real - number_want;
string updateSQL = "update OSM_STORAGE set HW_NUMBER = " + hw_number + ", REAL_NUMBER = " + real_number + " where ID = " + product_id;
if (adb.SQLExecute(updateSQL))
{
updateSQL = "update OSM_PURCHASE_SHEET set PURCHASE_STATE = '2' where ID = " + purchase_id;
if (adb.SQLExecute(updateSQL))
{
MessageBox.Show("到货确认成功！", "消息");
fWindow.refresh_dataGridView();
checkOrder(order_id);
this.Close();
this.Dispose();
}
}
}
}
else
{
MessageBox.Show("UNEXCEPTED ERROR!", "ERROR");
}
}
/// <summary>
/// 查看报价单按钮
/// </summary>
/// <param name="offersheet_code"></param>
private void viewOfferSheet(string offersheet_code)
{
string sql = "select * from OSM_OFFER_SHEET ";
sql += "where OFFERSHEET_CODE = '" + offersheet_code + "'";
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
Hashtable hashtable = new Hashtable();
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
hashtable.Add("ID", dr["ID"]);
hashtable.Add("OFFERSHEET_CODE", dr["OFFERSHEET_CODE"]);
hashtable.Add("GMF_ID", dr["GMF_ID"]);
hashtable.Add("BJF_ID", dr["BJF_ID"]);
hashtable.Add("OFFERSHEET_TYPE", dr["OFFERSHEET_TYPE"]);
hashtable.Add("OFFERSHEET_DATE", dr["OFFERSHEET_DATE"]);
hashtable.Add("OFFERSHEET_STATE", dr["OFFERSHEET_STATE"]);
hashtable.Add("OFFERSHEET_REGION", dr["OFFERSHEET_REGION"]);
hashtable.Add("CONFIRM_DATE", dr["CONFIRM_DATE"]);
}
FormOSM_Offers_Add form_add_offers = new FormOSM_Offers_Add();
form_add_offers.dataGridView_viewBtn_click_reaction(hashtable);
form_add_offers.setMainForm(main_form);
form_add_offers.setViewState(1);
form_add_offers.StartPosition = FormStartPosition.CenterParent;
form_add_offers.ShowDialog();
}
/// <summary>
/// DataGridView单元格点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridView_PayList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView_PayList.Columns[e.ColumnIndex].Name == "viewOrderBtn")
{
string order_id = dataGridView_PayList.Rows[e.RowIndex].Cells["ORDER_ID"].Value.ToString();
viewOrderSheet(order_id);
}
if (dataGridView_PayList.Columns[e.ColumnIndex].Name == "PayBtn")
{
AccessDB adb = new AccessDB();
string p_id = dataGridView_PayList.Rows[e.RowIndex].Cells["ID"].Value.ToString();
string order_id = dataGridView_PayList.Rows[e.RowIndex].Cells["ORDER_ID"].Value.ToString();
string payMode = dataGridView_PayList.Rows[e.RowIndex].Cells["PAY_MODE"].Value.ToString();
string payState = dataGridView_PayList.Rows[e.RowIndex].Cells["PAY_STATE"].Value.ToString();
string need_to_pay = dataGridView_PayList.Rows[e.RowIndex].Cells["REQUIRE_PAYMENT"].Value.ToString();
string pre_pay = dataGridView_PayList.Rows[e.RowIndex].Cells["PRE_PAYMENT"].Value.ToString();
string already_pay = dataGridView_PayList.Rows[e.RowIndex].Cells["ALREADY_PAYMENT"].Value.ToString();
switch (payMode)
{
case "1":
if (payState == "1")
{
getPayed(order_id, p_id, need_to_pay);
}
else
{
MessageBox.Show("该订单已付款！", "消息");
return;
}
break;
case "2":
if (payState == "1")
{
string sql = "select ORDER_STATE from OSM_ORDER_SHEET where ID = " + order_id;
DataTable dt = adb.SQLTableQuery(sql);
DataRow dr = dt.Rows[0];
string order_state = dr["ORDER_STATE"].ToString();
if (order_state == "6")
{
getPayed(order_id, p_id, need_to_pay);
}
else
{
MessageBox.Show("该订单为货到付款，现订单状态非已到货,无法提前付款！", "警告");
}
}
else
{
MessageBox.Show("该订单已付款！", "消息");
return;
}
break;
case "3":
if (payState == "1")
{
getPrePayed(order_id, p_id, need_to_pay);
}
else if (payState == "3")
{
string sql = "select ORDER_STATE from OSM_ORDER_SHEET where ID = " + order_id;
DataTable dt = adb.SQLTableQuery(sql);
DataRow dr = dt.Rows[0];
string order_state = dr["ORDER_STATE"].ToString();
if (order_state == "6")
{
getRestPayed(order_id, p_id, need_to_pay, already_pay);
}
else
{
MessageBox.Show("该订单已预付部分款，现订单状态非已到货,无法提前付剩余款！", "警告");
}
}
else
{
MessageBox.Show("该订单已付款！", "消息");
return;
}
break;
default:
MessageBox.Show("付款方式出错！", "错误");
break;
}
}
}
/// <summary>
/// 对应报价单审核通过
/// </summary>
/// <param name="offerSheetID">报价单ID</param>
/// <param name="offerSheetCode">报价单编号</param>
private void PassOfferSheet(string offerSheetID, string offerSheetCode)
{
AccessDB adb = new AccessDB();
string query = "select sum(HW_TOTALPRICE) as REQUIRE_PAYMENT from OSM_HW where OFFERSHEET_CODE = '" + offerSheetCode + "'";
DataTable dt = adb.SQLTableQuery(query);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
double require_payment = 0;
try
{
require_payment = double.Parse(dr["REQUIRE_PAYMENT"].ToString());
}
catch (Exception exception)
{
MessageBox.Show("该报价单没有对应的货物列表，无法通过审核！" + exception.ToString(), "警告");
return;
}
FormOSM_PayMode_Select fps = new FormOSM_PayMode_Select();
fps.setOfferForm(this);
fps.StartPosition = FormStartPosition.CenterParent;
fps.ShowDialog();
if (!string.IsNullOrWhiteSpace(pay_mode))
{
//生成订单存入数据库
string insertSQL = "insert into OSM_ORDER_SHEET(OFFERSHEET_ID,ORDER_STATE,REQUIRE_PAYMENT,ORDER_DATE,PAY_STATE,PAY_MODE) values ('";
insertSQL += offerSheetID + "','1'," + require_payment + ",#" + DateTime.Now.ToString("yyyy-MM-dd") + "#,'1','" + pay_mode + "')";
if (adb.SQLExecute(insertSQL))
{
MessageBox.Show("已将审核通过的报价单生成订单", "消息");
string sql = "update OSM_OFFER_SHEET set OFFERSHEET_STATE = '2' where ID = " + offerSheetID;
if (adb.SQLExecute(sql))
{
main_form.TSMItem_offer_aduit_Refresh();
}
}
}
else
{
MessageBox.Show("请确定付款方式！", "警告");
}
}
else
{
MessageBox.Show("该报价单没有对应的货物列表，无法通过审核！", "警告");
}
}
/// <summary>
/// 查询对应报价单货物列表
/// </summary>
/// <param name="dgv"></param>
private void queryByHW(DataGridView dgv)
{
switch (view_state)
{
case 0:
break;
case 1:
dgv.Columns["delBtn"].Visible = false;
break;
case 2:
break;
}
string sql = "select * from OSM_HW_LIST_V where OFFERSHEET_CODE = '" + textBox_OFFERSHEET_CODE.Text + "' ";
sql += "order by ID DESC";
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
dgv.DataSource = dt;
}
/// <summary>
/// 购买方按钮index变化触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void comboBox_BUYER_SelectedIndexChanged(object sender, EventArgs e)
{
KeyValuePair<int, string> kv = ((KeyValuePair<int, string>)comboBox_BUYER.SelectedItem);
string id = kv.Key.ToString();
string sql = "select COM_NAME,COM_CODE,ADDR,CONTACT,PHONE,ZIP_CODE,EMAIL,FAX,COMMENT from OSM_GMF where ID = ";
sql += id;
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
if (dt.Rows.Count == 1)
{
//构造购买方ID
buyer.setID(int.Parse(id));
//报价单中购买方ID
offer_sheet.setGMF_ID(int.Parse(id));
DataRow dr = dt.Rows[0];
buyer.setCOM_NAME(dr.ItemArray[0].ToString());
buyer.setCOM_CODE(dr.ItemArray[1].ToString());
buyer.setADDR(dr.ItemArray[2].ToString());
buyer.setCONTACT(dr.ItemArray[3].ToString());
buyer.setPHONE(dr.ItemArray[4].ToString());
buyer.setZIP_CODE(dr.ItemArray[5].ToString());
buyer.setEMAIL(dr.ItemArray[6].ToString());
buyer.setFAX(dr.ItemArray[7].ToString());
buyer.setCOMMENT(dr.ItemArray[8].ToString());
textBox_COM_NAME_BUYER.Text = buyer.getCOM_NAME();
textBox_COM_CODE_BUYER.Text = buyer.getCOM_CODE();
textBox_ADDR_BUYER.Text = buyer.getADDR();
textBox_CONTACT_BUYER.Text = buyer.getCONTACT();
textBox_PHONE_BUYER.Text = buyer.getPHONE();
textBox_ZIPCODE_BUYER.Text = buyer.getZIP_CODE();
textBox_EMAIL_BUYER.Text = buyer.getEMAIL();
textBox_FAX_BUYER.Text = buyer.getFAX();
textBox_COMMENT_BUYER.Text = buyer.getCOMMENT();
}
else
{
MessageBox.Show("数据库返回数据不止一条！");
return;
}
}
/// <summary>
/// 刷新货物列表
/// </summary>
public void refresh_hw_datagrid()
{
string sql = "select * from OSM_HW_LIST_V where OFFERSHEET_CODE = '" + textBox_OFFERSHEET_CODE.Text + "' ";
sql += "order by ID DESC";
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
dataGridView_HW.DataSource = dt;
}
/// <summary>
/// 查看订单按钮
/// </summary>
/// <param name="order_id"></param>
private void viewOrderSheet(string order_id)
{
string sql = "select OSM_ORDER_SHEET.ID,OFFERSHEET_ID,ORDER_STATE,ORDER_DATE,PAY_MODE,PAY_STATE,ALREADY_PAYMENT,PRE_PAYMENT,REQUIRE_PAYMENT,OFFERSHEET_CODE ";
sql += " from (OSM_ORDER_SHEET inner join OSM_OFFER_SHEET on OSM_ORDER_SHEET.OFFERSHEET_ID = OSM_OFFER_SHEET.ID) ";
sql += " where OSM_ORDER_SHEET.ID = " + order_id + " ";
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
Hashtable hashtable = new Hashtable();
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
hashtable.Add("ID", dr["ID"]);
hashtable.Add("OFFERSHEET_ID", dr["OFFERSHEET_ID"]);
hashtable.Add("ORDER_STATE", dr["ORDER_STATE"]);
hashtable.Add("ORDER_DATE", dr["ORDER_DATE"]);
hashtable.Add("PAY_MODE", dr["PAY_MODE"]);
hashtable.Add("PAY_STATE", dr["PAY_STATE"]);
hashtable.Add("ALREADY_PAYMENT", dr["ALREADY_PAYMENT"]);
hashtable.Add("PRE_PAYMENT", dr["PRE_PAYMENT"]);
hashtable.Add("REQUIRE_PAYMENT", dr["REQUIRE_PAYMENT"]);
hashtable.Add("OFFERSHEET_CODE", dr["OFFERSHEET_CODE"]);
}
FormOSM_Order_View orderView = new FormOSM_Order_View();
orderView.setOrderID(order_id);
//设置窗口状态为查看
orderView.setViewState(0);
orderView.viewOrderSheet(hashtable);
orderView.StartPosition = FormStartPosition.CenterParent;
orderView.ShowDialog();
}
/// <summary>
/// 采购到货确认
/// </summary>
/// <param name="purchase_id">采购记录编号</param>
private void confirmPurchase(string purchase_id)
{
string sql = "SELECT OSM_PURCHASE_SHEET.ORDER_ID, OSM_PURCHASE_SHEET.PRODUCT_ID, OSM_STORAGE.HW_TYPE, OSM_STORAGE.HW_NAME, OSM_STORAGE.HW_CODE, OSM_PURCHASE_SHEET.PURCHASE_NUMBER ";
sql += " FROM OSM_STORAGE INNER JOIN OSM_PURCHASE_SHEET ON OSM_STORAGE.ID = OSM_PURCHASE_SHEET.PRODUCT_ID";
sql += " WHERE OSM_PURCHASE_SHEET.ID = " + purchase_id;
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
Hashtable hashtable = new Hashtable();
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
hashtable.Add("ID", purchase_id);
hashtable.Add("ORDER_ID", dr["ORDER_ID"]);
hashtable.Add("PRODUCT_ID", dr["PRODUCT_ID"]);
hashtable.Add("HW_TYPE", dr["HW_TYPE"]);
hashtable.Add("HW_NAME", dr["HW_NAME"]);
hashtable.Add("HW_CODE", dr["HW_CODE"]);
hashtable.Add("PURCHASE_NUMBER", dr["PURCHASE_NUMBER"]);
}
FormOSM_Purchase_Confirm fpc = new FormOSM_Purchase_Confirm();
fpc.Set_fWindow(this);
fpc.viewProduct(hashtable);
fpc.StartPosition = FormStartPosition.CenterParent;
fpc.ShowDialog();
//MessageBox.Show(purchase_id);
}
/// <summary>
/// 检查是否可以发货
/// </summary>
/// <param name="order_id"></param>
private void checkDelivery(string order_id)
{
string sql = "select PAY_MODE,PAY_STATE,ALREADY_PAYMENT,PRE_PAYMENT,REQUIRE_PAYMENT from OSM_ORDER_SHEET where ID = " + order_id;
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
Hashtable hashtable = new Hashtable();
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
string pay_mode = dr["PAY_MODE"].ToString();
string pay_state = dr["PAY_STATE"].ToString();
double already_payment = double.Parse(dr["ALREADY_PAYMENT"].ToString());
double pre_payment = double.Parse(dr["PRE_PAYMENT"].ToString());
double require_payment = double.Parse(dr["REQUIRE_PAYMENT"].ToString());
//hashtable.Add("PAY_MODE", dr["PAY_MODE"]);
//hashtable.Add("PAY_STATE", dr["PAY_STATE"]);
//hashtable.Add("ALREADY_PAYMENT", dr["ALREADY_PAYMENT"]);
//hashtable.Add("PRE_PAYMENT", dr["PRE_PAYMENT"]);
//hashtable.Add("REQUIRE_PAYMENT", dr["REQUIRE_PAYMENT"]);
switch (pay_mode)
{
case "1":
if (pay_state == "2")
{
orderDeliver(order_id);
}
else
{
MessageBox.Show("未付全款，无法发货！", "警告");
}
break;
case "2":
if (pay_state == "1")
{
orderDeliver(order_id);
}
break;
case "3":
if (pay_state == "3")
{
orderDeliver(order_id);
}
else
{
MessageBox.Show("未预付部分款，无法发货！", "警告");
}
break;
}
string checkPayListSQL = "select ID from OSM_PAYMENTREMINDER_SHEET where ORDER_ID = " + order_id;
DataTable dataT = adb.SQLTableQuery(checkPayListSQL);
if (dataT.Rows.Count == 0)
{
createPaySheet(order_id);
}
}
}
/// <summary>
/// 检查订单是否可以发货
/// </summary>
/// <param name="order_id"></param>
private void checkOrder(string order_id)
{
bool flag = true;
AccessDB adb = new AccessDB();
string sql = "select PURCHASE_STATE from OSM_PURCHASE_SHEET where ORDER_ID = " + order_id;
DataTable dt = adb.SQLTableQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
if ("1" == dr["PURCHASE_STATE"].ToString())
{
flag = false;
}
}
if (flag)
{
string updateSQL = "update OSM_ORDER_SHEET set ORDER_STATE = '3' where ID = " + order_id;
if (adb.SQLExecute(updateSQL))
{
MessageBox.Show("对应订单已可以进入发货流程！", "消息");
//string insertSQL = "insert into OSM_DILIVERY_SHEET(ORDER_ID,DILIVERY_STATE) values(" + order_id + ",'1')";
//if (adb.SQLExecute(insertSQL))
//{
// MessageBox.Show("对应订单已可以发货,已生成发货单！", "消息");
//}
}
}
}