/// <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); }
public FormOSM_Buyer_Add() { InitializeComponent(); buyer = new Buyer(); }
/// <summary> /// 输入窗口内容构造购买方对象 /// </summary> /// <param name="buyer"></param> private void createBuyer(Buyer buyer) { buyer.setCOM_NAME(textBox_COM_NAME_BUYER.Text); buyer.setCOM_CODE(textBox_COM_CODE_BUYER.Text); buyer.setADDR(textBox_ADDR_BUYER.Text); buyer.setCONTACT(textBox_CONTACT_BUYER.Text); buyer.setPHONE(textBox_PHONE_BUYER.Text); buyer.setZIP_CODE(textBox_ZIPCODE_BUYER.Text); buyer.setEMAIL(textBox_EMAIL_BUYER.Text); buyer.setFAX(textBox_FAX_BUYER.Text); buyer.setCOMMENT(textBox_COMMENT_BUYER.Text); }
/// <summary> /// 实现数据库插入购买方数据 /// </summary> /// <param name="buyer"></param> /// <returns></returns> private bool addBuyer(Buyer buyer) { string sql = "insert into OSM_GMF(COM_NAME,COM_CODE,ADDR,CONTACT,PHONE,ZIP_CODE,FAX,EMAIL,COMMENT) "; sql += "values ('" + buyer.getCOM_NAME() + "','" + buyer.getCOM_CODE() + "','"; sql += buyer.getADDR() + "','" + buyer.getCONTACT() + "','"; sql += buyer.getPHONE() + "','" + buyer.getZIP_CODE() + "','"; sql += buyer.getFAX() + "','" + buyer.getEMAIL() + "','" + buyer.getCOMMENT() + "')"; AccessDB adb = new AccessDB(); bool isExecuteSucc = adb.SQLExecute(sql); if (isExecuteSucc) { MessageBox.Show("添加成功!", "消息"); } else { MessageBox.Show("添加失败!", "消息"); } return isExecuteSucc; }