private void btnEdit_Click(object sender, EventArgs e)
{
try
{
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
int sortOrder = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colSortOrder));
WorkingStepModel model = new WorkingStepModel();
var dr = grvData.GetRow(grvData.FocusedRowHandle);
model = (WorkingStepModel)dr;
frmWorkingStepDetailH frm = new frmWorkingStepDetailH();
frm.WorkingStep = model;
frm.ArrStep = arrStep;
if (frm.ShowDialog() == DialogResult.OK)
{
var lst = arrStep.ToArray().ToList();
lst = lst.Where(o => ((WorkingStepModel)o).ID != id && ((WorkingStepModel)o).SortOrder != sortOrder).ToList();
arrStep = new ArrayList();
for (int i = 0; i < lst.Count; i++)
{
arrStep.Add(lst[i]);
}
arrStep.Add(frm.WorkingStep);
grdData.DataSource = null;
grdData.DataSource = arrStep;
}
}
catch (Exception ex)
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
using (WaitDialogForm fWait = new WaitDialogForm("Please Wait...", "Processing Data"))
{
ProductGroup.ProductGroupCode = txtCode.Text.Trim();
ProductGroup.ProductGroupName = txtName.Text.Trim();
if (ProductGroup.ID <= 0)
{
ProductGroup.ID = (int)ProductGroupBO.Instance.Insert(ProductGroup);
}
else
{
ProductGroupBO.Instance.Update(ProductGroup);
}
CurentNode = ProductGroup.ID;
for (int i = 0; i < arrStep.Count; i++)
{
_STT = Lib.ToInt(grvData.GetRowCellValue(i, colSortOrder));
_Name = Lib.ToString(grvData.GetRowCellValue(i, colName));
_Des = Lib.ToString(grvData.GetRowCellValue(i, colDes));
WorkingStepModel step = (WorkingStepModel)arrStep[i];
int type = 0;
if (step.ID <= 0)
{
step.ProductGroupID = ProductGroup.ID;
step.ID = (int)WorkingStepBO.Instance.Insert(step);
type = 1;
//Thêm step vào các sản phẩm thuộc nhóm này
}
else
{
//string sql= $"SELECT TOP 1 ws.ID FROM dbo.WorkingStep ws JOIN dbo.ProductStep ps ON ws.ID = ps.WorkingStepID WHERE WorkingStepID = {step.ID} and ws.WorkingStepCode = N'{_Name}' and ws.Description = N'{_Des}' and ws.SortOrder ='{_STT}'";
//int id = Lib.ToInt(LibIE.ExcuteScalar(sql));
//if (id == 0)
//{
WorkingStepBO.Instance.Update(step);
type = 2;
// type = 1;
//Cập nhật vào các sản phẩm thuộc nhóm này
//}
}
LibIE.ExcuteProcedure("spUpdateProductStep_ByWorkingStep"
, new string[] { "@WorkingStepID", "@Type" }
, new object[] { step.ID, type });
}
DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
WorkingStepModel model = new WorkingStepModel();
for (int i = 0; i < grvData.RowCount; i++)
{
model.WorkingStepCode = Lib.ToString(grvData.GetRowCellValue(i, colName));
model.SortOrder = Lib.ToInt(grvData.GetRowCellValue(i, colSortOrder));
model.Description = Lib.ToString(grvData.GetRowCellValue(i, colDes));
model.CreatedBy = "Admin";
model.CreatedDate = DateTime.Now;
model.UpdatedBy = "Admin";
model.UpdatedDate = DateTime.Now;
model.ProductGroupID = Lib.ToInt(cbCopy.EditValue);
WorkingStepBO.Instance.Insert(model);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
ProductGroup.ProductGroupCode = txtCode.Text.Trim();
ProductGroup.ProductGroupName = txtName.Text.Trim();
if (ProductGroup.ID <= 0)
{
ProductGroup.ID = (int)ProductGroupBO.Instance.Insert(ProductGroup);
}
else
{
ProductGroupBO.Instance.Update(ProductGroup);
}
CurentNode = ProductGroup.ID;
for (int i = 0; i < arrStep.Count; i++)
{
WorkingStepModel step = (WorkingStepModel)arrStep[i];
int type = 0;
if (step.ID <= 0)
{
step.ProductGroupID = ProductGroup.ID;
step.ID = (int)WorkingStepBO.Instance.Insert(step);
type = 1;
//Thêm step vào các sản phẩm thuộc nhóm này
}
else
{
WorkingStepBO.Instance.Update(step);
type = 2;
//Cập nhật vào các sản phẩm thuộc nhóm này
}
TextUtils.ExcuteProcedure("spUpdateProductStep_ByWorkingStep"
, new string[] { "@WorkingStepID", "@Type" }
, new object[] { step.ID, type });
}
DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void creatWorkingStep()
{
for (int i = 1; i < 6; i++)
{
for (int j = 1; j < grvData.RowCount; j++)
{
WorkingStepModel gStep = new WorkingStepModel();
gStep.ProductGroupID = i;
gStep.Description = Lib.ToString(grvData.GetRowCellValue(j, "F3")).Trim();
gStep.SortOrder = Lib.ToInt(grvData.GetRowCellValue(j, "F1"));
gStep.WorkingStepCode = "CD" + Lib.ToString(grvData.GetRowCellValue(j, "F2")).Trim();
gStep.ID = (int)WorkingStepBO.Instance.Insert(gStep);
}
Lib.ExcuteSQL(string.Format("EXEC CreateProductStep_ByGroupID {0}", i));
}
}
protected WorkingStepFacade(WorkingStepModel model) : base(model)
{
}
private void btnSaveNew_Click(object sender, EventArgs e)
{
saveData();
WorkingStep = new WorkingStepModel();
loadData();
}
