/*
* private void operatorDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
* {
* DataGridView view = (DataGridView)sender;
* string cellName = view.Columns[e.ColumnIndex].Name;
* DataGridViewRow row = view.Rows[e.RowIndex];
* DataGridViewCell cell = row.Cells[e.ColumnIndex];
* if (cellName == "IsSuper")
* {
* if (cell.Value==null) return;
* if (Convert.IsDBNull(cell.Value)) return;
* bool isSuper=(bool)cell.Value;
* if (!isSuper) return;
* foreach(DataGridViewCell c in row.Cells) c.ReadOnly=true;
* try
* {
* cell=row.Cells["OperatorID"];
* int id = (int)cell.Value;
* if (id == MyFunction.OperatorID)
* row.Cells["LoginName"].ReadOnly = false;
* }
* catch{}
* return;
* }
* }
*/
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
MyFunction.AddNewItem(operatorDataGridView, "operatorID", "operatorID", m_DataSet.Operator);
DataGridViewRow row = operatorDataGridView.CurrentRow;
row.Cells["LoginName"].Value = "Name" + row.Cells["operatorID"].Value.ToString();
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
if (m_SelectedMonth <= 0 || m_SelectedMonth > 12)
{
MessageBox.Show("請選擇月份再新增!");
return;
}
try
{
accVouchBindingSource.AddNew();
MyFunction.AddNewItem(dgvAccVoucher, "ColumnAccVoucherID", "ID", damaiDataSet.AccVouch);
var rowView = (DataRowView)accVouchBindingSource.Current;
var accVouch = rowView.Row as DamaiDataSet.AccVouchRow;
accVouch.Money = 0;
if (m_SelectedMonth > 0 && m_SelectedMonth <= 12)
{
int year = MyFunction.IntHeaderYear;
accVoucherTimeTextBox.Text = (new DateTime(year, m_SelectedMonth, 28)).ToShortDateString();
var serials = from r in damaiDataSet.AccVouch
where !r.IsAccVoucherTimeNull() && r.AccVoucherTime.Month == m_SelectedMonth && !r.IsAccVoucherIDNull()
select r.AccVoucherID % 1000;
int no = 1;
if (serials.Count() != 0)
{
no = serials.Max() + 1;
}
accVoucherIDTextBox.Text = (year % 100).ToString("d2") + m_SelectedMonth.ToString("d2") + no.ToString("d3");
}
accVouchBindingSource.EndEdit();
}
catch (Exception ex)
{
MessageBox.Show("加入新傳票時出錯,原因:" + ex.Message);
}
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
MyFunction.AddNewItem(this.apartmentDataGridView, "columnApartmentID", "ApartmentID", this.damaiDataSet.Apartment);
DataGridViewRow row = apartmentDataGridView.CurrentRow; // 剛被新增那行一定是CurrentRow
foreach (string s in ColumnsEncryted)
{
try
{
row.Cells[s].Value = ""; // 因為在ColumnsEncrypted內的欄位在SQLDB內都被定義成不准NULL,所以必需填值
}
catch (Exception ex)
{
MessageBox.Show("DataGridView欄位<" + s + ">設定初值失敗!程式錯誤,請將本訊息通知碼農修正錯誤!");
}
}
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
if (MyFunction.LockAll)
{
MessageBox.Show("鎖定中,新增無用");
}
if (checkBoxSort.Checked)
{
checkBoxSort.Checked = false;
}
MyFunction.AddNewItem(dgvBankDetail, "columnID", "ID", m_DataSet.BankDetail);
DataGridViewRow row = dgvBankDetail.CurrentRow;
DataGridViewCell cell = row.Cells["columnAccount"];
if (cbSelectBank.SelectedIndex < 1) // 第一個是 全部
{
MessageBox.Show("未選戶頭! 己預設");
cell.Value = 2;
return;
}
cell.Value = cbSelectBank.SelectedValue;
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
DateTime maxDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
MyInventoryRow rowIsnull = null;
foreach (var r in m_DataSet.Inventory)
{
rowIsnull = r;
if (r.RowState == DataRowState.Deleted)
{
continue;
}
if (!r.IsCheckDayNull())
{
if (r.CheckDay >= maxDate)
{
maxDate = r.CheckDay.AddDays(1); // 設定盤點日為最大那張的加一天
}
}
if (r.Locked)
{
continue;
}
MessageBox.Show("有尚未核可的單子,無法新增盤點表!");
return;
}
if (rowIsnull == null)
{
MessageBox.Show("初值，请输入食材的盘点、金额和产品的本期");
prevVolumeColumn.Visible = false;
dgvColumnCurrentIn.Visible = false;
dgvColumnPrevStockVolume.Visible = false;
StockMoneyColumn.ReadOnly = false;
dgvColumnLostMoney.Visible = false;
isFrist = true;
}
else
{
prevVolumeColumn.Visible = true;
dgvColumnCurrentIn.Visible = true;
dgvColumnPrevStockVolume.Visible = true;
StockMoneyColumn.ReadOnly = true;
dgvColumnLostMoney.Visible = true;
isFrist = false;
}
if (maxDate.Year != MyFunction.IntHeaderYear)
{
MessageBox.Show("預計的盤點日超過資料年<" + MyFunction.HeaderYear + ">");
return;
}
this.inventoryBindingSource.AddNew();
DataGridViewRow row = dgvInventories.CurrentRow;
DataGridViewCell cell = row.Cells["ColumnInventoryID"];
if (cell == null)
{
MessageBox.Show("程式或資料庫版本錯誤, <dgvInventories>沒有<ColumnInventoryID>!");
return;
}
if (Convert.IsDBNull(cell.Value))
{
try
{
MyFunction.AddNewItem(dgvInventories, "ColumnInventoryID", "InventoryID", m_DataSet.Inventory);
bindingNavigatorAddNewItem.Enabled = false;
DataRowView rowView = row.DataBoundItem as DataRowView;
var data = rowView.Row as MyInventoryRow;
data.CheckDay = maxDate; // 盤點日
int inventoryID = data.InventoryID;
// 從食材表中有Code的,加入vEDataSet.InventoryDetail
foreach (var ingredient in m_DataSet.Ingredient)
{
if (ingredient.IsCodeNull())
{
continue;
}
if (ingredient.Code <= 0)
{
continue; // 無代号食材不納入盤點
}
var detail = m_DataSet.InventoryDetail.NewInventoryDetailRow();
detail.ID = Guid.NewGuid();
detail.IngredientID = ingredient.IngredientID;
detail.InventoryID = inventoryID;
m_DataSet.InventoryDetail.AddInventoryDetailRow(detail);
}
// 產品表中有Code的,加入vEDataSet.InventoryProducts
foreach (var product in m_OrderSet.Product)
{
if (product.IsClassNull())
{
continue;
}
if (product.Code <= 0)
{
continue;
}
var inventoryProducts = m_DataSet.InventoryProducts.NewInventoryProductsRow();
inventoryProducts.ID = Guid.NewGuid();
inventoryProducts.ProductID = product.ProductID;
inventoryProducts.InventoryID = inventoryID;
m_DataSet.InventoryProducts.AddInventoryProductsRow(inventoryProducts);
}
inventoryBindingSource.ResetBindings(false); // inventoryDetailBindingSource 會連動,不用自己呼叫
chBoxHide.Checked = false; // 初創立,要看到所有有產品碼的
}
catch (Exception ex)
{
MessageBox.Show("新增時錯誤,原因<" + ex.Message + ">");
return;
}
}
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
MyFunction.AddNewItem(vendorDataGridView, "columnVendorID", "VendorID", damaiDataSet.Vendor);
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
DateTime maxDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
foreach (var r in m_DataSet.ProductScrapped)
{
if (r.RowState == DataRowState.Deleted)
{
continue;
}
if (!r.IsScrappedDateNull())
{
if (r.ScrappedDate >= maxDate)
{
maxDate = r.ScrappedDate.AddDays(1); // 設定盤點日為最大那張的加一天
}
}
if ((!r.IsLockedNull()) && r.Locked == true)
{
continue;
}
}
if (maxDate.Year != MyFunction.IntHeaderYear)
{
MessageBox.Show("預計的日期超過資料年<" + MyFunction.HeaderYear + ">");
return;
}
this.productScrappedBindingSource.AddNew();
DataGridViewRow row = dgvProductScrapped.CurrentRow;
DataGridViewCell cell = row.Cells["ColumnProductScrappedID"];
if (cell == null)
{
MessageBox.Show("程式或資料庫版本錯誤, <dgvProductScrapped>沒有<ColumnProductScrappedID>!");
return;
}
if (Convert.IsDBNull(cell.Value))
{
try
{
MyFunction.AddNewItem(dgvProductScrapped, "ColumnProductScrappedID", "ProductScrappedID", m_DataSet.ProductScrapped);
bindingNavigatorAddNewItem.Enabled = false;
var rowView = row.DataBoundItem as DataRowView;
var data = rowView.Row as MyProductScrappedRow;
data.ScrappedDate = maxDate; // 盤點日
int productScrappedID = data.ProductScrappedID;
// 從產品表中有Code的,加入vEDataSet.ProductScrappedDetail
foreach (var product in m_OrderSet.Product)
{
if (product.IsCodeNull())
{
continue;
}
if (product.Code <= 0)
{
continue; // 無代号產品不納入報癈
}
var detail = m_DataSet.ProductScrappedDetail.NewProductScrappedDetailRow();
detail.ID = Guid.NewGuid();
detail.ProductID = product.ProductID;
detail.ProdcutScrappedID = productScrappedID;
if (!product.IsPriceNull())
{
detail.Price = (decimal)product.Price;
}
if (!product.IsEvaluatedCostNull())
{
detail.EvaluatedCost = product.EvaluatedCost;
}
m_DataSet.ProductScrappedDetail.AddProductScrappedDetailRow(detail);
}
productScrappedBindingSource.ResetBindings(false); // productScrappedDetailBindingSource 會連動,不用自己呼叫
chBoxHide.Checked = false; // 初創立,要看到所有有產品碼的
}
catch (Exception ex)
{
MessageBox.Show("新增時錯誤,原因<" + ex.Message + ">");
return;
}
}
}
private void AddNewItem_Click(object sender, EventArgs e)
{
productClassBindingSource.AddNew();
MyFunction.AddNewItem(productClassDataGridView, "dgvColumnID", "ID", damaiDataSet.ProductClass);
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
MyFunction.AddNewItem(dgvRecipe, "dgvColumnID", "RecipeID", m_DataSet.Recipe);
recipeBindingSource.ResetBindings(false); // 不加這行Detail顯示不會改
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
MyFunction.AddNewItem(this.dgvHR, "columnEmployeeID", "EmployeeID", m_DataSet.HR);
this.hRBindingSource.ResetBindings(false);
}
private void bindingNavigatorAddNewItem_Click_1(object sender, EventArgs e)
{
MyFunction.AddNewItem(customerDataGridView, "ColumnCustomerID", "CustomerID", damaiDataSet.Customer);
bindingNavigatorAddNewItem.Enabled = false;
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
MyFunction.AddNewItem(dgvBankAccount, "columnID", "ID", damaiDataSet.BankAccount);
}
