/// <summary>
/// 构造函数
/// </summary>
public FormOSM_Purchase_Confirm()
{
InitializeComponent();
string where = "where PID = 43";
SJZDController.setZD_ComboBox(where, comboBox_HWType);
}
/// <summary>
/// 构造函数
/// </summary>
public FormOSM_Offers_Add(string uuid = "")
{
InitializeComponent();
buyer = new Buyer();
seller = new Seller();
offer_sheet = new OfferSheet();
//hw = new HW();
dataGridView_HW.AutoGenerateColumns = false;
string whereString = "where PID = 10";
SJZDController.setZD_ComboBox(whereString, comboBox_OFFERSHEET_REGION);
whereString = "where PID = 33";
SJZDController.setZD_ComboBox(whereString, comboBox_OFFERSHEET_TYPE);
string offsht_code = "U" + uuid + "OSC" + DateTime.Now.ToString("yyyyMMddHHmmss");
textBox_OFFERSHEET_CODE.Text = offsht_code;
fillSellerComboBox(comboBox_SELLER);
fillBuyerComboBox(comboBox_BUYER);
//queryByHW(dataGridView_HW);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Purchase_Complete()
{
InitializeComponent();
dateTimePicker_InitDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 30";
SJZDController.setZD_ComboBox(whereString, comboBox_PurchaseState);
for (int i = 0; i < comboBox_PurchaseState.Items.Count; i++)
{
KeyValuePair <string, string> kv = (KeyValuePair <string, string>)comboBox_PurchaseState.Items[i];
if (kv.Key == "1")
{
comboBox_PurchaseState.SelectedIndex = i;
comboBox_PurchaseState.Enabled = false;
break;
}
}
whereString = "where PID = 43";
SJZDController.setZD_ComboBox(whereString, comboBox_HWType);
//查询未到货采购单视图
queryFromPurchaseSheetV(dataGridView_Purchase_Complete, " where PURCHASE_STATE = '1' ");
}
/// <summary>
/// 构造函数
/// </summary>
public FormOSM_Product_Add()
{
InitializeComponent();
string where = "where PID = 43";
SJZDController.setZD_ComboBox(where, comboBox_Type);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Offer_Audit_Form()
{
InitializeComponent();
dateTimePicker_OfferSheet_Audit.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 10";
SJZDController.setZD_ComboBox(whereString, comboBox_OfferSheet_Audit);
refreshOfferSheetList(dataGridView_OfferSheet_Audit, "where OFFERSHEET_STATE = '1'");
}
/// <summary>
/// 构造函数
/// </summary>
public FormOSM_HW_Add()
{
InitializeComponent();
hw = new HW();
string whereString = "where PID = 43 ";
SJZDController.setZD_ComboBox(whereString, comboBox_HW_TYPE);
comboBox_HW_TYPE.Enabled = false;
//产品列表数据填充
fillProductComboBox();
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_DeliverySheet_Form()
{
InitializeComponent();
dateTimePicker_DeliverDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
dateTimePicker_ArrDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 53 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_DeliveryState);
queryFromDiliverySheetV(dataGridView_Delivery);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Offers_Form()
{
InitializeComponent();
dateTimePicker_OfferSheet.Text = DateTime.Now.ToString("yyyy-MM-dd");
//查询报价单视图返回结果
queryFromOfferSheetV(dataGridView_OfferSheet);
//设置页码控件控制的datagridview
//osM_Pager_offerSheet.setDataGridView(dataGridView_OfferSheet);
string whereString = "where PID = 1";
SJZDController.setZD_ComboBox(whereString, comboBox_OfferSheet);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Delivery_Audit_Form()
{
InitializeComponent();
dateTimePicker_DeliverDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
dateTimePicker_ArrDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 53 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_DeliveryState);
//comboBox_DeliveryState.SelectedIndex = 1;
comboBox_DeliveryState.Enabled = false;
queryFromDiliverySheetV(dataGridView_Delivery, "where DILIVERY_STATE = '1'");
}
public OSM_PayList_Form()
{
InitializeComponent();
dateTimePicker_GenDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 20 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_PayMode);
whereString = "where PID = 24 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_PayState);
queryFormPayListView(dataGridView_PayList);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Purchase_Form()
{
InitializeComponent();
dateTimePicker_InitDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 30";
SJZDController.setZD_ComboBox(whereString, comboBox_PurchaseState);
whereString = "where PID = 43";
SJZDController.setZD_ComboBox(whereString, comboBox_HWType);
//查询采购单视图返回结果
queryFromPurchaseSheetV(dataGridView_Purchase);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Orders_Form()
{
InitializeComponent();
dateTimePicker_OrderDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 2 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_OrderState);
whereString = "where PID = 24 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_PayState);
//查询订单视图返回结果
queryFromOrderSheetV(dataGridView_Order);
}
/// <summary>
/// 构造函数
/// </summary>
public OSM_Order_Delivery_Form()
{
InitializeComponent();
dateTimePicker_OrderDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string whereString = "where PID = 2 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_OrderState);
comboBox_OrderState.SelectedIndex = 0;
comboBox_OrderState.Enabled = false;
whereString = "where PID = 24 order by ID";
SJZDController.setZD_ComboBox(whereString, comboBox_PayState);
//查询订单视图返回结果
queryFromOrderSheetV(dataGridView_Order, "where ORDER_STATE = '1' ");
}
/// <summary>
/// 构造函数
/// </summary>
public FormOSM_Order_View()
{
InitializeComponent();
string whereString = "where PID = 2";
SJZDController.setZD_ComboBox(whereString, comboBox_OrderState);
whereString = "where PID = 20";
SJZDController.setZD_ComboBox(whereString, comboBox_PayMode);
whereString = "where PID = 24";
SJZDController.setZD_ComboBox(whereString, comboBox_PayState);
textBox_OfferSheetCode.ReadOnly = true;
label_PrePayment.Visible = false;
textBox_PrePayment.Visible = false;
}
/// <summary>
/// 产品列表数据填充
/// </summary>
/// <param name="comboBox_Product"></param>
private void fillProductComboBox()
{
string sql = "select ID,HW_CODE from OSM_STORAGE";
SJZDController.fillComboBox(sql, comboBox_Product);
}
/// <summary>
/// 刷新购买方列表
/// </summary>
public void refresh_buyer_comboBox()
{
string sql = "select ID,COM_NAME from OSM_GMF";
SJZDController.fillComboBox(sql, comboBox_BUYER);
}
/// <summary>
/// 加载购买方列表
/// </summary>
/// <param name="cbox"></param>
private void fillBuyerComboBox(ComboBox cbox)
{
string sql = "select ID,COM_NAME from OSM_GMF";
SJZDController.fillComboBox(sql, cbox);
}
/// <summary>
/// 刷新报价方列表
/// </summary>
public void refresh_seller_comboBox()
{
string sql = "select ID,COM_NAME from OSM_BJF";
SJZDController.fillComboBox(sql, comboBox_SELLER);
}
