public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" Update m_line_sap_item"); sqlQuery.Append(" Set cycle_time = :stdcycletime, "); sqlQuery.Append(" registration_user_cd = :registrationusercd, "); sqlQuery.Append(" registration_date_time = :registrationdatetime "); sqlQuery.Append(" Where factory_cd = :factcode"); sqlQuery.Append(" and line_sap_item_id = :lineitemcycletimeid "); //sqlQuery.Append(" and line_id = :lineid "); //sqlQuery.Append(" and sap_item_cd = :sapitemcd "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterDecimal("stdcycletime", inVo.StdCycleTime); sqlParameter.AddParameterInteger("lineitemcycletimeid", inVo.LineItemCycleTimeId); sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factcode", trxContext.UserData.FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList(); LineItemCycleTimeVo deleteInVo = (LineItemCycleTimeVo)inList.FirstOrDefault(); ValueObjectList <LineItemCycleTimeVo> addInVo = (ValueObjectList <LineItemCycleTimeVo>)inList.Skip(1).FirstOrDefault();; //ValueObjectList<LineItemCycleTimeVo> inVo = new ValueObjectList<LineItemCycleTimeVo>(); UpdateResultVo outVo = new UpdateResultVo(); UpdateResultVo resultVo = (UpdateResultVo)deleteLineItemCycleTimeMasterMntCbm.Execute(trxContext, deleteInVo); if (addInVo != null && addInVo.GetList() != null && addInVo.GetList().Count > 0) { foreach (LineItemCycleTimeVo currentVo in addInVo.GetList()) { resultVo = (UpdateResultVo)addLineItemCycleTimeMasterMntCbm.Execute(trxContext, currentVo); outVo.AffectedCount = resultVo.AffectedCount; } return(outVo); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_line_sap_item"); sqlQuery.Append(" Where "); //sqlQuery.Append(" line_sap_item_id = :lineSapItemId "); sqlQuery.Append(" line_id = :lineid"); //sqlQuery.Append(" and sap_matnr_item_cd = :sapMatnrItemCd "); sqlQuery.Append(" and factory_cd = :faccd "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); //sqlParameter.AddParameterInteger("lineSapItemId", inVo.LineItemCycleTimeId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterString("sapMatnrItemCd", inVo.SapItemCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private LineItemCycleTimeVo FormConditionVo() { LineItemCycleTimeVo inVo = new LineItemCycleTimeVo(); inVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue); if (SapItem_cmb.SelectedIndex > -1) { inVo.SapItemCode = SapItem_cmb.SelectedValue.ToString(); } else { inVo.SapItemCode = null; } return(inVo); }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(LineItemCycleTimeVo conditionInVo) { StartProgress(Properties.Resources.mmci00009); LineItem_dgv.DataSource = null; ValueObjectList <LineItemCycleTimeVo> outVo = null; try { outVo = (ValueObjectList <LineItemCycleTimeVo>)base.InvokeCbm(getLineItemCycleTimeMasterCbm, conditionInVo, false); } catch (Framework.ApplicationException exception) { CompleteProgress(); popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } CompleteProgress(); LineItem_dgv.AutoGenerateColumns = false; if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0) { SapItem_cmb.DataSource = null; SapItem_cmb.SelectedIndex = -1; SapItem_cmb.Text = string.Empty; return; } LineItem_dgv.DataSource = outVo.GetList(); if (SapItem_cmb.SelectedIndex > -1) { // do nothing } else { SapItem_cmb.DataSource = null; SapItem_cmb.DisplayMember = "SapItemCode"; SapItem_cmb.ValueMember = "SapItemCode"; SapItem_cmb.DataSource = outVo.GetList(); SapItem_cmb.SelectedIndex = -1; } LineItem_dgv.ClearSelection(); }
/// <summary> /// Item code search click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ItemSearch_btn_Click(object sender, EventArgs e) { ItemCodeSearchForm frm = new ItemCodeSearchForm(); frm.ShowDialog(); if (frm.sapItemSearchVo != null && frm.sapItemSearchVo.GetList() != null && frm.sapItemSearchVo.GetList().Count > 0) { ValueObjectList <SapItemSearchVo> sapItemSearchVo = frm.sapItemSearchVo; sapItemSearchVo.GetList().ForEach(v => v.SapItemName = v.SapItemCode + " - " + v.SapItemName); ValueObjectList <LineItemCycleTimeVo> sapItemVo = new ValueObjectList <LineItemCycleTimeVo>(); foreach (SapItemSearchVo itmVo in sapItemSearchVo.GetList()) { LineItemCycleTimeVo sapItmVo = new LineItemCycleTimeVo(); sapItmVo.SapItemCode = itmVo.SapItemCode; sapItemVo.add(sapItmVo); } ValueObjectList <LineItemCycleTimeVo> grdCycleVo = new ValueObjectList <LineItemCycleTimeVo>(); ValueObjectList <LineItemCycleTimeVo> itmCycleVo = new ValueObjectList <LineItemCycleTimeVo>(); if ((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource != null) { itmCycleVo.SetNewList((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource); } if (itmCycleVo != null && itmCycleVo.GetList() != null && itmCycleVo.GetList().Count > 0) { List <string> sapitemlist = itmCycleVo.GetList().Select(v => v.SapItemCode).ToList(); List <LineItemCycleTimeVo> selectedItem = sapItemVo.GetList().Where(x => !sapitemlist.Contains(x.SapItemCode)).ToList(); itmCycleVo.GetList().AddRange(selectedItem); } else { itmCycleVo.GetList().AddRange(sapItemVo.GetList()); } grdCycleVo.SetNewList(itmCycleVo.GetList().Where(x => !String.IsNullOrWhiteSpace(x.SapItemCode)) .Select(x => new LineItemCycleTimeVo { SapItemCode = x.SapItemCode, StdCycleTimeNull = x.StdCycleTimeNull }) .GroupBy(x => x.SapItemCode).Select(x => x.FirstOrDefault()).Distinct().ToList()); LineItem_dgv.AutoGenerateColumns = false; LineItem_dgv.DataSource = null; LineItem_dgv.DataSource = grdCycleVo.GetList(); LineItem_dgv.ClearSelection(); ValueObjectList <LineItemCycleTimeVo> cmbCycleVo = new ValueObjectList <LineItemCycleTimeVo>(); if ((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource != null) { cmbCycleVo.SetNewList((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource); if ((List <LineItemCycleTimeVo>)SapItem_cmb.DataSource != null) { cmbCycleVo.GetList().AddRange((List <LineItemCycleTimeVo>)SapItem_cmb.DataSource); } } SapItem_cmb.DataSource = null; SapItem_cmb.DisplayMember = "SapItemCode"; SapItem_cmb.ValueMember = "SapItemCode"; SapItem_cmb.DataSource = cmbCycleVo.GetList().Where(x => !String.IsNullOrWhiteSpace(x.SapItemCode)) .Select(x => new LineItemCycleTimeVo { SapItemCode = x.SapItemCode, StdCycleTimeNull = x.StdCycleTimeNull }) .GroupBy(x => x.SapItemCode).Select(x => x.FirstOrDefault()).Distinct().ToList(); SapItem_cmb.SelectedIndex = -1; } }
/// <summary> /// updates Line Machine /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Update_btn_Click(object sender, EventArgs e) { if (LineItem_dgv.RowCount == 0) // || LineItem_dgv.SelectedRows.Count == 0 { return; } if (Line_cmb.Text == string.Empty || Line_cmb.SelectedIndex < 0) { messageData = new MessageData("mmce00002", Properties.Resources.mmce00002, LineId_lbl.Text); popUpMessage.Warning(messageData, Text); Line_cmb.Focus(); return; } ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); LineItemCycleTimeVo deleteInVo = new LineItemCycleTimeVo(); deleteInVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue); ValueObjectList <LineItemCycleTimeVo> addInVo = new ValueObjectList <LineItemCycleTimeVo>(); foreach (DataGridViewRow row in LineItem_dgv.Rows) { if (row.Cells["clmstdcycletime"].Value != null && !row.Cells["clmstdcycletime"].Value.ToString().Equals(string.Empty)) { decimal cycleTime = Convert.ToDecimal(row.Cells["clmstdcycletime"].Value); if (cycleTime > 0) { LineItemCycleTimeVo selectedItem = (LineItemCycleTimeVo)row.DataBoundItem; LineItemCycleTimeVo addVo = new LineItemCycleTimeVo(); addVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue); addVo.StdCycleTime = cycleTime; addVo.SapItemCode = row.Cells["colSapItemCode"].Value.ToString(); addInVo.add(addVo); } } } inVoList.add(deleteInVo); inVoList.add(addInVo); //if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0) //{ // messageData = new MessageData("mmci00047", Properties.Resources.mmci00047, LineId_lbl.Text); // popUpMessage.Information(messageData, Text); // LineItem_dgv.Focus(); // return; //} UpdateResultVo outVo = null; try { Cursor.Current = Cursors.WaitCursor; outVo = (UpdateResultVo)base.InvokeCbm(new AddUpdateLineItemCycleTimeMasterMntCbm(), inVoList, false); Cursor.Current = Cursors.Default; } catch (Framework.ApplicationException exception) { Cursor.Current = Cursors.Default; popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (outVo == null) { return; } messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append(" select "); sqlQuery.Append(" sap_matnr_item_cd, "); sqlQuery.Append(" cycle_time, "); sqlQuery.Append(" line_sap_item_id, "); sqlQuery.Append(" line_id "); sqlQuery.Append(" from m_line_sap_item "); sqlQuery.Append(" where "); sqlQuery.Append(" factory_cd = :factorycode "); sqlQuery.Append(" and line_id = :lineid "); if (inVo.SapItemCode != null) { sqlQuery.Append(" and sap_matnr_item_cd = :sapMatnrItemCd "); } sqlQuery.Append(" ORDER BY sap_matnr_item_cd, cycle_time"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterString("sapMatnrItemCd", inVo.SapItemCode); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <LineItemCycleTimeVo> lineItemCycleTimeVo = null; while (dataReader.Read()) { LineItemCycleTimeVo currVo = new LineItemCycleTimeVo(); currVo.LineId = ConvertDBNull <int>(dataReader, "line_id"); currVo.SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd"); if (dataReader["cycle_time"] != null) { currVo.StdCycleTimeNull = ConvertDBNull <decimal>(dataReader, "cycle_time"); } currVo.LineItemCycleTimeId = ConvertDBNull <int>(dataReader, "line_sap_item_id"); if (lineItemCycleTimeVo == null) { lineItemCycleTimeVo = new ValueObjectList <LineItemCycleTimeVo>(); } lineItemCycleTimeVo.add(currVo); } dataReader.Close(); return(lineItemCycleTimeVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append(" select "); //lin.line_id, //sqlQuery.Append(" lin.line_name, "); sqlQuery.Append(" si.sap_matnr_item_cd, "); sqlQuery.Append(" si.sap_maktx_item_name, "); sqlQuery.Append(" subQry.cycle_time, "); sqlQuery.Append(" subQry.line_sap_item_id, "); sqlQuery.Append(" subQry.line_id "); sqlQuery.Append(" from sap_item si "); sqlQuery.Append("left join(select sap_matnr_item_cd, cycle_time, line_sap_item_id,line_id"); sqlQuery.Append(" from m_line_sap_item li where li.line_id = :lineid) as subQry"); //sqlQuery.Append(" right join m_line lin on lin.line_id = ct.line_id "); //sqlQuery.Append(" right join sap_item si on si.sap_matnr_item_cd = ct.sap_matnr_item_cd "); sqlQuery.Append(" on si.sap_matnr_item_cd = subQry.sap_matnr_item_cd "); sqlQuery.Append(" where "); sqlQuery.Append(" si.factory_cd = :factorycode "); //if (inVo.LineId > -1) //{ // sqlQuery.Append(" and ct.Line_id = :lineid "); //} if (inVo.SapItemCode != null) { sqlQuery.Append(" and si.sap_matnr_item_cd = :sapMatnrItemCd "); } sqlQuery.Append(" ORDER BY si.sap_matnr_item_cd,subQry.cycle_time"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); //sqlParameter.AddParameterInteger("lineId", inVo.LineId); //if (inVo.SapItemCode != null) //{ sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterString("sapMatnrItemCd", inVo.SapItemCode); //} sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); //sqlQuery.Append(" order by gi.global_item_id "); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <LineItemCycleTimeVo> lineItemCycleTimeVo = null; while (dataReader.Read()) { LineItemCycleTimeVo currVo = new LineItemCycleTimeVo { LineId = ConvertDBNull <int>(dataReader, "Line_id"), //LineName = ConvertDBNull<string>(dataReader, "line_name"), SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd"), SapItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name"), StdCycleTime = ConvertDBNull <decimal>(dataReader, "cycle_time"), LineItemCycleTimeId = ConvertDBNull <int>(dataReader, "line_sap_item_id") }; if (lineItemCycleTimeVo == null) { lineItemCycleTimeVo = new ValueObjectList <LineItemCycleTimeVo>(); } lineItemCycleTimeVo.add(currVo); } dataReader.Close(); return(lineItemCycleTimeVo); }