private void btnOK_Click(object sender, EventArgs e) { if (mode == mode.Add && checkAdd()) { int count = 0; foreach (DataGridViewRow row in dgvItem.Rows) { Inventory ent = new Inventory(APConfig.Conn); ent.INV_SERNO = My.GenSerNo(); ent.INV_STATUS = InventoryStatus.寄庫品.ToString(); ent.INV_NAME = row.Cells["dgvItem_Name"].Value.ToString(); ent.INV_POSTCOMMENT = row.Cells["dgvItem_Comment"].Value.ToString(); ent.INV_POSTAMT = Convert.ToInt32(row.Cells["dgvItem_Amount"].Value); ent.INV_POSTDTTM = DateTime.Parse(row.Cells["dgvItem_ImportDTTM"].Value.ToString()); ent.INV_MODIFIEDBY = APConfig.AccountName; ent.INV_MODIFIEDDTTM = DateTime.Now; count += ent.insert(); } APConfig.SweetAlert(ShowBoxType.alert, string.Format("寄庫品登記完成!\r\n新增 {0} 件寄庫品", count.ToString())); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.Edit && checkAdd()) { Inventory ent = new Inventory(APConfig.Conn); ent.INV_SERNO = serno; ent.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5}" , Inventory.ncFields.INV_NAME.ToString() , Inventory.ncFields.INV_POSTAMT.ToString() , Inventory.ncFields.INV_POSTDTTM.ToString() , Inventory.ncFields.INV_POSTCOMMENT.ToString() , Inventory.ncFields.INV_MODIFIEDBY.ToString() , Inventory.ncFields.INV_MODIFIEDDTTM.ToString()); ent.INV_NAME = txtName.Text; ent.INV_POSTAMT = Convert.ToInt32(txtAmount.Text); ent.INV_POSTDTTM = DateTime.Parse(dpkImportDTTM.Value.ToString()); ent.INV_POSTCOMMENT = txtComment.Text; ent.INV_MODIFIEDBY = APConfig.AccountName; ent.INV_MODIFIEDDTTM = DateTime.Now; ent.update(); APConfig.SweetAlert(ShowBoxType.alert, "修改完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.View) { this.DialogResult = DialogResult.OK; this.Close(); } else { return; } }
private void btnOK_Click(object sender, EventArgs e) { if (mode == mode.Add && check()) { Phrase ent = new Phrase(APConfig.Conn); ent.PHS_SERNO = My.GenSerNo(); ent.PHS_CATEGORY = ddlCategory.SelectedItem.ToString(); ent.PHS_NAME = txtName.Text; ent.PHS_INDEX = txtIndex.Text; ent.PHS_TYPE = txtType.Text; ent.PHS_COLOR = txtColor.Text; ent.PHS_SIZE = txtSize.Text; ent.PHS_MODIFIEDBY = APConfig.AccountName; ent.PHS_MODIFIEDDTTM = DateTime.Now; ent.insert(); APConfig.SweetAlert(ShowBoxType.alert, "新增完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.Edit && check()) { Phrase ent = new Phrase(APConfig.Conn); ent.PHS_SERNO = serno; ent.ModifyFields = string.Format("{0};{1};{2};{3},{4},{5},{6}" , Phrase.ncFields.PHS_NAME.ToString() , Phrase.ncFields.PHS_INDEX.ToString() , Phrase.ncFields.PHS_TYPE.ToString() , Phrase.ncFields.PHS_SIZE.ToString() , Phrase.ncFields.PHS_COLOR.ToString() , Phrase.ncFields.PHS_MODIFIEDBY.ToString() , Phrase.ncFields.PHS_MODIFIEDDTTM.ToString()); ent.PHS_NAME = txtName.Text; ent.PHS_INDEX = txtIndex.Text; ent.PHS_TYPE = txtType.Text; ent.PHS_COLOR = txtColor.Text; ent.PHS_SIZE = txtSize.Text; ent.PHS_MODIFIEDBY = APConfig.AccountName; ent.PHS_MODIFIEDDTTM = DateTime.Now; ent.update(); APConfig.SweetAlert(ShowBoxType.alert, "修改完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.View) { this.DialogResult = DialogResult.OK; this.Close(); } else { return; } }
private void btnSubmit_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(checkSubmit())) { Account entAccount = new Account(APConfig.Conn); entAccount.ACT_SERNO = My.GenSerNo(); entAccount.ACT_NAME = txtName.Text; entAccount.ACT_ACCOUNT = txtAccount.Text; entAccount.ACT_PASSWORD = txtPassword.Text; entAccount.ACT_CREATEDTTM = DateTime.Now; entAccount.insert(); APConfig.SweetAlert(ShowBoxType.alert, "新增完成!"); } }
private void btnOK_Click(object sender, EventArgs e) { if (mode == mode.Add) { if (dgvItem.Rows.Count == 0) { this.DialogResult = DialogResult.OK; this.Close(); return; } int count = 0; foreach (DataGridViewRow row in dgvItem.Rows) { Roster ent = new Roster(APConfig.Conn); ent.RST_SERNO = My.GenSerNo(); ent.RST_NO = row.Cells["dgvItem_No"].Value.ToString(); ent.RST_NAME = row.Cells["dgvItem_Name"].Value.ToString(); ent.RST_PHONE = row.Cells["dgvItem_Phone"].Value.ToString(); ent.RST_MOBILE1 = row.Cells["dgvItem_Mobile1"].Value.ToString(); ent.RST_MOBILE2 = row.Cells["dgvItem_Mobile2"].Value.ToString(); ent.RST_AMOUNT = Convert.ToInt32(row.Cells["dgvItem_Amount"].Value.ToString()); ent.RST_ORDERDTTM = DateTime.Parse(row.Cells["dgvItem_OrderDTTM"].Value.ToString()); ent.RST_ADDR = row.Cells["dgvItem_Addr"].Value.ToString(); ent.RST_COMMENT1 = row.Cells["dgvItem_Comment1"].Value.ToString(); ent.RST_COMMENT2 = row.Cells["dgvItem_Comment2"].Value.ToString(); ent.RST_COMMENT3 = row.Cells["dgvItem_Comment3"].Value.ToString(); ent.RST_INSERTBY = APConfig.AccountName; ent.RST_INSERTDTTM = DateTime.Now; ent.RST_MODIFIEDBY = APConfig.AccountName; ent.RST_MODIFIEDDTTM = DateTime.Now; count += ent.insert(); } APConfig.SweetAlert(ShowBoxType.alert, string.Format("訂單登記完成!\r\n新增 {0} 件", count.ToString())); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.Edit) { Roster ent = new Roster(APConfig.Conn); ent.RST_SERNO = serno; ent.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9};{10};{11};{12}" , Roster.ncFields.RST_NO.ToString() , Roster.ncFields.RST_NAME.ToString() , Roster.ncFields.RST_PHONE.ToString() , Roster.ncFields.RST_MOBILE1.ToString() , Roster.ncFields.RST_MOBILE2.ToString() , Roster.ncFields.RST_AMOUNT.ToString() , Roster.ncFields.RST_ORDERDTTM.ToString() , Roster.ncFields.RST_ADDR.ToString() , Roster.ncFields.RST_COMMENT1.ToString() , Roster.ncFields.RST_COMMENT2.ToString() , Roster.ncFields.RST_COMMENT3.ToString() , Roster.ncFields.RST_MODIFIEDBY.ToString() , Roster.ncFields.RST_MODIFIEDDTTM.ToString()); ent.RST_NO = txtNo.Text; ent.RST_NAME = txtName.Text; ent.RST_PHONE = txtPhone.Text; ent.RST_MOBILE1 = txtMobile1.Text; ent.RST_MOBILE2 = txtMobile2.Text; ent.RST_AMOUNT = Convert.ToInt32(txtAmount.Text); ent.RST_ORDERDTTM = DateTime.Parse(dpkOrderDTTM.Value.ToString()); ent.RST_ADDR = txtAddr.Text; ent.RST_COMMENT1 = txtComment1.Text; ent.RST_COMMENT2 = txtComment2.Text; ent.RST_COMMENT3 = txtComment3.Text; ent.RST_MODIFIEDBY = APConfig.AccountName; ent.RST_MODIFIEDDTTM = DateTime.Now; ent.update(); APConfig.SweetAlert(ShowBoxType.alert, "修改完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.View) { this.DialogResult = DialogResult.OK; this.Close(); } else { return; } }
private void btnOK_Click(object sender, EventArgs e) { if (mode == mode.Add && checkAdd()) { foreach (DataGridViewRow row in dgvItem.Rows) { RosterDial ent = new RosterDial(APConfig.Conn); ent.RSD_SERNO = My.GenSerNo(); ent.RST_SERNO = mRosterInfo.RST_SERNO; ent.RSD_STATUS = ddlStatus.SelectedItem.ToString(); ent.RSD_ITEMTYPE = row.Cells["dgvItem_Type"].Value.ToString(); ent.RSD_ITEM = row.Cells["dgvItem_Item"].Value.ToString(); ent.RSD_AMOUNT = row.Cells["dgvItem_Amount"].Value.ToString(); ent.RSD_COMMENT = txtComment.Text; ent.RSD_DEALER = ddlDealer.SelectedItem.ToString(); ent.RSD_MODIFIEDBY = APConfig.AccountName; ent.RSD_MODIFIEDDTTM = DateTime.Now; ent.RSD_INSERTBY = APConfig.AccountName; ent.RSD_INSERTDTTM = DateTime.Now; ent.RSD_DEALDDTTM = DateTime.Parse(dpkDealDTTM.Value.ToString()); ent.insert(); } APConfig.SweetAlert(ShowBoxType.alert, "新增完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.Edit && checkAdd()) { RosterDial ent = new RosterDial(APConfig.Conn); ent.RSD_SERNO = serno; ent.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8}" , RosterDial.ncFields.RSD_DEALER.ToString() , RosterDial.ncFields.RSD_STATUS.ToString() , RosterDial.ncFields.RSD_ITEMTYPE.ToString() , RosterDial.ncFields.RSD_ITEM.ToString() , RosterDial.ncFields.RSD_AMOUNT.ToString() , RosterDial.ncFields.RSD_COMMENT.ToString() , RosterDial.ncFields.RSD_MODIFIEDBY.ToString() , RosterDial.ncFields.RSD_MODIFIEDDTTM.ToString() , RosterDial.ncFields.RSD_DEALDDTTM.ToString()); ent.RSD_DEALER = ddlDealer.SelectedItem.ToString(); ent.RSD_STATUS = ddlStatus.SelectedItem.ToString(); ent.RSD_ITEMTYPE = ddlType.SelectedItem.ToString(); ent.RSD_ITEM = txtItemInfo.Text; ent.RSD_AMOUNT = txtAmount.Text; ent.RSD_COMMENT = txtComment.Text; ent.RSD_MODIFIEDBY = APConfig.AccountName; ent.RSD_MODIFIEDDTTM = DateTime.Now; ent.RSD_DEALDDTTM = DateTime.Parse(dpkDealDTTM.Value.ToString()); ent.update(); APConfig.SweetAlert(ShowBoxType.alert, "修改完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.View) { this.DialogResult = DialogResult.OK; this.Close(); } else { return; } }
private void btnOK_Click(object sender, EventArgs e) { if (mode == mode.Add && checkAdd()) { int newCount = 0; foreach (DataGridViewRow row in dgvItem.Rows) { Inventory ent = new Inventory(APConfig.Conn); ent.INV_SERNO = My.GenSerNo(); ent.INV_STATUS = InventoryStatus.庫存中.ToString(); ent.INV_VENDOR = row.Cells["dgvItem_Vendor"].Value.ToString(); ent.INV_NAME = row.Cells["dgvItem_Name"].Value.ToString(); ent.INV_TYPE = row.Cells["dgvItem_Type"].Value.ToString(); ent.INV_COLOR = row.Cells["dgvItem_Color"].Value.ToString(); ent.INV_SIZE = row.Cells["dgvItem_Size"].Value.ToString(); ent.INV_INCOMMENT = row.Cells["dgvItem_Comment"].Value.ToString(); ent.INV_INAMT = Convert.ToInt32(row.Cells["dgvItem_Amount"].Value); ent.INV_INDTTM = DateTime.Parse(row.Cells["dgvItem_ImportDTTM"].Value.ToString()); ent.INV_MODIFIEDBY = APConfig.AccountName; ent.INV_MODIFIEDDTTM = DateTime.Now; newCount += ent.insert(); } APConfig.SweetAlert(ShowBoxType.alert, string.Format("進貨完成!\r\n新增 {0} 件進貨單 ", newCount.ToString())); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.Edit && checkAdd()) { Inventory ent = new Inventory(APConfig.Conn); ent.INV_SERNO = serno; ent.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5},{6},{7},{8},{9}" , Inventory.ncFields.INV_NAME.ToString() , Inventory.ncFields.INV_TYPE.ToString() , Inventory.ncFields.INV_COLOR.ToString() , Inventory.ncFields.INV_SIZE.ToString() , Inventory.ncFields.INV_INAMT.ToString() , Inventory.ncFields.INV_INDTTM.ToString() , Inventory.ncFields.INV_INCOMMENT.ToString() , Inventory.ncFields.INV_MODIFIEDBY.ToString() , Inventory.ncFields.INV_MODIFIEDDTTM.ToString() , Inventory.ncFields.INV_VENDOR.ToString()); ent.INV_NAME = txtName.Text; ent.INV_TYPE = txtType.Text; ent.INV_SIZE = txtSize.Text; ent.INV_COLOR = txtColor.Text; ent.INV_INAMT = Convert.ToInt32(txtAmount.Text); ent.INV_INDTTM = DateTime.Parse(dpkImportDTTM.Value.ToString()); ent.INV_INCOMMENT = txtComment.Text; ent.INV_MODIFIEDBY = APConfig.AccountName; ent.INV_MODIFIEDDTTM = DateTime.Now; ent.INV_VENDOR = ddlVendor.SelectedItem.ToString(); ent.update(); APConfig.SweetAlert(ShowBoxType.alert, "修改完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.View) { this.DialogResult = DialogResult.OK; this.Close(); } else { return; } }
private void btnOK_Click(object sender, EventArgs e) { if (mode == mode.Add && checkAdd()) { RosterInfo vRoster = new RosterInfo(APConfig.Conn); vRoster.Conditions = vRoster.getCondition(RosterInfo.ncConditions.main.ToString(), txtMain.Text); if (vRoster.calculateCount() == 0) { Roster entRoster = new Roster(APConfig.Conn); entRoster.RST_SERNO = My.GenSerNo(); entRoster.RST_NAME = txtName.Text; entRoster.RST_MAIN = txtMain.Text; entRoster.RST_SEX = ddlSex.SelectedItem.ToString(); entRoster.RST_PHONE1 = txtPhone1.Text; entRoster.RST_PHONE2 = txtPhone2.Text; entRoster.RST_MOBILE = txtMobile.Text; entRoster.RST_FAX = txtFax.Text; entRoster.RST_ADDR = txtAddr.Text; entRoster.RST_PRINCIPAL = ddlPrinciple.SelectedItem.ToString(); entRoster.RST_COMMENT = txtComment.Text; entRoster.RST_MODIFIEDBY = APConfig.AccountName; entRoster.RST_MODIFIEDDTTM = DateTime.Now; entRoster.RST_INSERTBY = APConfig.AccountName; entRoster.RST_INSERTDTTM = DateTime.Now; entRoster.insert(); APConfig.SweetAlert(ShowBoxType.alert, "新增完成"); this.DialogResult = DialogResult.OK; this.Close(); } else { APConfig.SweetAlert(ShowBoxType.alert, "主要號碼已經存在"); txtMain.Focus(); } } else if (mode == mode.Edit && checkAdd()) { Roster entRoster = new Roster(APConfig.Conn); entRoster.RST_SERNO = serno; entRoster.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9};{10}" , Roster.ncFields.RST_NAME.ToString() , Roster.ncFields.RST_MAIN.ToString() , Roster.ncFields.RST_SEX.ToString() , Roster.ncFields.RST_PHONE1.ToString() , Roster.ncFields.RST_PHONE2.ToString() , Roster.ncFields.RST_FAX.ToString() , Roster.ncFields.RST_ADDR.ToString() , Roster.ncFields.RST_PRINCIPAL.ToString() , Roster.ncFields.RST_COMMENT.ToString() , Roster.ncFields.RST_MODIFIEDBY.ToString() , Roster.ncFields.RST_MODIFIEDDTTM.ToString()); entRoster.RST_NAME = txtName.Text; entRoster.RST_MAIN = txtMain.Text; entRoster.RST_SEX = ddlSex.SelectedItem.ToString(); entRoster.RST_PHONE1 = txtPhone1.Text; entRoster.RST_PHONE2 = txtPhone2.Text; entRoster.RST_FAX = txtFax.Text; entRoster.RST_ADDR = txtAddr.Text; entRoster.RST_PRINCIPAL = ddlPrinciple.SelectedItem.ToString(); entRoster.RST_COMMENT = txtComment.Text; entRoster.RST_MODIFIEDBY = APConfig.AccountName; entRoster.RST_MODIFIEDDTTM = DateTime.Now; entRoster.update(); APConfig.SweetAlert(ShowBoxType.alert, "修改完成"); this.DialogResult = DialogResult.OK; this.Close(); } else if (mode == mode.View) { this.DialogResult = DialogResult.OK; this.Close(); } else { return; } }