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