private void delete_all_btn_Click(object sender, EventArgs e) { if (vt_search_moving_dgv.Rows.Count > 0 && vt_search_moving_dgv.DataSource != null && applyupdate == "0") { try { if (MessageBox.Show("Bạn có chắc xóa mã code: " + code_status_cmb.Text + ": " + code_name_cmb.Text + " này !", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { MovingMachineVTVo inVo = new MovingMachineVTVo { CodeName = code_name_cmb.Text, CodeStatus = code_status_cmb.Text }; MovingMachineVTVo outVo = new MovingMachineVTVo(); outVo = (MovingMachineVTVo)DefaultCbmInvoker.Invoke(new Cbm.DeleteMovingVTCbm(), inVo); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, machine_serial_lbl + " : " + machine_serial_cmb.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); } GridBind(); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MovingMachineVTVo inVo = (MovingMachineVTVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <MovingMachineVTVo> voList = new ValueObjectList <MovingMachineVTVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select max(bg_cd) as bg_cd_max, max(m_cd) as m_cd_max, max(t_cd) as t_cd_max , max(th_cd) as th_cd_max from t_vt_moving"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { MovingMachineVTVo outVo = new MovingMachineVTVo { BGCode = dataReader["bg_cd_max"].ToString(), MCode = dataReader["m_cd_max"].ToString(), TCode = dataReader["t_cd_max"].ToString(), THCode = dataReader["th_cd_max"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MovingMachineVTVo inVo = (MovingMachineVTVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"update t_vt_moving set status =:status, comments_machine =:comments_machine, registration_user_cd =:registration_user_cd, registration_date_time = now() where moving_id =:moving_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("status", inVo.Status); sqlParameter.AddParameter("moving_id", inVo.MovingId); sqlParameter.AddParameter("comments_machine", inVo.CommentsMachine); sqlParameter.AddParameter("registration_user_cd", UserData.GetUserData().UserCode); // sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime); //execute SQL MovingMachineVTVo outVo = new MovingMachineVTVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void delete_btn_Click(object sender, EventArgs e) { if (vt_search_moving_dgv.Rows.Count > 0 && vt_search_moving_dgv.DataSource != null) { try { if (MessageBox.Show("Bạn có chắc xóa thiết bị này !", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { MovingMachineVTVo selectedvo = (MovingMachineVTVo)vt_search_moving_dgv.CurrentRow.DataBoundItem; MovingMachineVTVo outVo = new MovingMachineVTVo(); outVo = (MovingMachineVTVo)DefaultCbmInvoker.Invoke(new Cbm.DeleteMovingVTCbm(), selectedvo); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, machine_serial_lbl + " : " + machine_serial_cmb.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); } GridBind(); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } }
private void update_btn_Click(object sender, EventArgs e) { if (vt_search_moving_dgv.SelectedCells.Count > 0 && applyupdate == "0") //khong che cung 1 loai codename moi cho update { MovingMachineVTVo selectedvo = (MovingMachineVTVo)vt_search_moving_dgv.CurrentRow.DataBoundItem; if (new AddMovingMachineVTForm { movingmachineVo = selectedvo, }.ShowDialog() == DialogResult.OK) { GridBind(); } } }
void GridBind() { try { MovingMachineVTVo inVo = new MovingMachineVTVo { MachineSerial = machine_serial_cmb.Text, ReceivedFactoryName = factory_received_cmb.Text, TranferFactoryName = factory_tranfer_cmb.Text, CodeStatus = code_status_cmb.Text, CodeName = code_name_cmb.Text, }; ValueObjectList <MovingMachineVTVo> listvo = (ValueObjectList <MovingMachineVTVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchMovingVTCbm(), inVo); vt_search_moving_dgv.DataSource = listvo.GetList(); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MovingMachineVTVo inVo = (MovingMachineVTVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("Delete From t_vt_moving"); sql.Append(" Where "); if (inVo.CodeStatus == "Bàn Giao") { sql.Append(" bg_cd = :code_name ;"); } if (inVo.CodeStatus == "Mượn") { sql.Append(" m_cd = :code_name ;"); } if (inVo.CodeStatus == "Trả") { sql.Append(" t_cd = :code_name ;"); } if (inVo.CodeStatus == "Thuê") { sql.Append(" th_cd = :code_name ;"); } DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("code_name", inVo.CodeName); MovingMachineVTVo outVo = new MovingMachineVTVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MovingMachineVTVo inVo = (MovingMachineVTVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <MovingMachineVTVo> voList = new ValueObjectList <MovingMachineVTVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); //Bàn Giao //Mượn //Trả //Thuê if (inVo.CodeStatus == "Bàn Giao") { sql.Append(@"select distinct bg_cd from t_vt_moving order by bg_cd DESC "); } if (inVo.CodeStatus == "Mượn") { sql.Append(@"select distinct m_cd from t_vt_moving order by m_cd DESC"); } if (inVo.CodeStatus == "Trả") { sql.Append(@"select distinct t_cd from t_vt_moving order by t_cd DESC "); } if (inVo.CodeStatus == "Thuê") { sql.Append(@"select distinct th_cd from t_vt_moving order by th_cd DESC "); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { if (inVo.CodeStatus == "Bàn Giao") { MovingMachineVTVo outVo = new MovingMachineVTVo { CodeName = dataReader["bg_cd"].ToString(), }; voList.add(outVo); } if (inVo.CodeStatus == "Mượn") { MovingMachineVTVo outVo = new MovingMachineVTVo { CodeName = dataReader["m_cd"].ToString(), }; voList.add(outVo); } if (inVo.CodeStatus == "Trả") { MovingMachineVTVo outVo = new MovingMachineVTVo { CodeName = dataReader["t_cd"].ToString(), }; voList.add(outVo); } if (inVo.CodeStatus == "Thuê") { MovingMachineVTVo outVo = new MovingMachineVTVo { CodeName = dataReader["th_cd"].ToString(), }; voList.add(outVo); } } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MovingMachineVTVo inVo = (MovingMachineVTVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"insert into t_vt_moving(machine_serial, factory_tranfer_cd , factory_received_cd , bg_cd, m_cd, t_cd, th_cd, status, comments_machine, reason_tranfer, confirm_received, registration_user_cd, registration_date_time, factory_cd) "); sql.Append(@"values(:machine_serial , :factory_tranfer_cd, :factory_received_cd , :bg_cd , :m_cd, :t_cd, :th_cd, :status, :comments_machine, :reason_tranfer, :confirm_received, :registration_user_cd, :registration_date_time, :factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("machine_serial", inVo.MachineSerial); sqlParameter.AddParameter("factory_tranfer_cd", inVo.TranferFactoryName); sqlParameter.AddParameter("factory_received_cd", inVo.ReceivedFactoryName); sqlParameter.AddParameter("bg_cd", inVo.BGCode); sqlParameter.AddParameter("m_cd", inVo.MCode); sqlParameter.AddParameter("t_cd", inVo.TCode); sqlParameter.AddParameter("th_cd", inVo.THCode); sqlParameter.AddParameter("status", inVo.Status); sqlParameter.AddParameter("comments_machine", inVo.CommentsMachine); sqlParameter.AddParameter("reason_tranfer", inVo.ReasonTranfer); sqlParameter.AddParameter("confirm_received", inVo.ConfirmReceived); sqlParameter.AddParameter("registration_user_cd", UserData.GetUserData().UserCode); sqlParameter.AddParameter("factory_cd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime); //execute SQL MovingMachineVTVo outVo = new MovingMachineVTVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void Ok_btn_Click(object sender, EventArgs e) { // code_status_cmb_SelectedIndexChanged(sender, e); if (checkdata()) { MovingMachineVTVo outVo = new MovingMachineVTVo(); MovingMachineVTVo inVo = new MovingMachineVTVo { MovingId = movingmachineVo.MovingId, MachineSerial = machine_serial_cmb.Text, TranferFactoryName = factory_tranfer_cmb.Text, ReceivedFactoryName = factory_received_cmb.Text, Status = status_machine_cmb.Text, CommentsMachine = comments_txt.Text, ReasonTranfer = reason_tranfer_txt.Text, ConfirmReceived = confirm_received_txt.Text, BGCode = BG_code_value, TCode = T_code_value, THCode = Th_code_value, MCode = M_code_value, }; try { if (movingmachineVo.MovingId > 0) { outVo = (MovingMachineVTVo)DefaultCbmInvoker.Invoke(new Cbm.UpdateMovingVTCbm(), inVo); } else { outVo = (MovingMachineVTVo)DefaultCbmInvoker.Invoke(new Cbm.AddMovingVTCbm(), inVo); if (code_status_cmb.Text == "Bàn Giao") { WarehouseVTVo updateBG = new WarehouseVTVo(); updateBG = (WarehouseVTVo)DefaultCbmInvoker.Invoke(new UpdateBGMovingVTCbm(), new WarehouseVTVo() { MachineSerial = inVo.MachineSerial, MachineSupplier = inVo.ReceivedFactoryName, MachineStatus = "Đã Bàn Giao", RegistrationUserCode = inVo.RegistrationUserCode, RegistrationDateTime = DateTime.Now, }); } if ((code_status_cmb.Text == "Mượn") && (UserData.GetUserData().FactoryName == inVo.ReceivedFactoryName))//minh di muon thì add thêm { WarehouseVTVo addnewmachine = new WarehouseVTVo(); addnewmachine = (WarehouseVTVo)DefaultCbmInvoker.Invoke(new AddNewMachineVTCbm(), new WarehouseVTVo() { RFId = rfid_txt.Text, MachineCode = "", MachineName = machine_name_cmb.Text, MachineQty = 1, MachineModel = machine_model_cmb.Text, MachineSerial = machine_serial_cmb.Text, MachineLocation = "", MachineSupplier = factory_tranfer_cmb.Text, MachineInvoice = "", MachineCostValue = cost_value_cmb.Text, RegistrationUserCode = UserData.GetUserData().UserName, RegistrationDateTime = DateTime.Now, TimeCheck = 1, MachineStatus = "Đã Mượn", }); } if ((code_status_cmb.Text == "Mượn") && (UserData.GetUserData().FactoryName == inVo.TranferFactoryName))//minh cho ngta muon, thì update statust { WarehouseVTVo updateBG = new WarehouseVTVo(); updateBG = (WarehouseVTVo)DefaultCbmInvoker.Invoke(new UpdateBGMovingVTCbm(), new WarehouseVTVo() { MachineSerial = inVo.MachineSerial, MachineSupplier = inVo.TranferFactoryName, MachineStatus = "Đã Cho Mượn", RegistrationUserCode = inVo.RegistrationUserCode, RegistrationDateTime = DateTime.Now, }); } if ((code_status_cmb.Text == "Trả") && (UserData.GetUserData().FactoryName == inVo.TranferFactoryName))//mình trả cho ngta, thì xóa dòng đó. { WarehouseVTVo deletemachine = new WarehouseVTVo(); deletemachine = (WarehouseVTVo)DefaultCbmInvoker.Invoke(new DeleteMachineVTCbm(), new WarehouseVTVo() { MachineSerial = inVo.MachineSerial }); } if ((code_status_cmb.Text == "Trả") && (UserData.GetUserData().FactoryName == inVo.ReceivedFactoryName))//nguoi ta tra mình, update status { WarehouseVTVo updateBG = new WarehouseVTVo(); updateBG = (WarehouseVTVo)DefaultCbmInvoker.Invoke(new UpdateBGMovingVTCbm(), new WarehouseVTVo() { MachineSerial = inVo.MachineSerial, MachineSupplier = inVo.ReceivedFactoryName, MachineStatus = "Máy CTY", RegistrationUserCode = inVo.RegistrationUserCode, RegistrationDateTime = DateTime.Now, }); } if ((code_status_cmb.Text == "Thuê") && (UserData.GetUserData().FactoryName == inVo.ReceivedFactoryName))//mình đi thuê thì add thêm { WarehouseVTVo addnewmachine = new WarehouseVTVo(); addnewmachine = (WarehouseVTVo)DefaultCbmInvoker.Invoke(new AddNewMachineVTCbm(), new WarehouseVTVo() { RFId = rfid_txt.Text, MachineCode = "", MachineName = machine_name_cmb.Text, MachineQty = 1, MachineModel = machine_model_cmb.Text, MachineSerial = machine_serial_cmb.Text, MachineLocation = "", MachineSupplier = factory_tranfer_cmb.Text, MachineInvoice = "", MachineCostValue = cost_value_cmb.Text, RegistrationUserCode = UserData.GetUserData().UserName, RegistrationDateTime = DateTime.Now, TimeCheck = 1, MachineStatus = "Máy Thuê", }); } } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (outVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, machine_serial_cmb.Text + " : " + machine_serial_cmb.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MovingMachineVTVo inVo = (MovingMachineVTVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <MovingMachineVTVo> voList = new ValueObjectList <MovingMachineVTVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //Bàn Giao //Mượn //Trả //Thuê //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select a.moving_id, a.machine_serial, a.factory_tranfer_cd, a.factory_received_cd, a.bg_cd, a.m_cd, a.t_cd, a.th_cd, a.status, a.comments_machine, a.reason_tranfer, a.confirm_received, a.registration_user_cd, a.registration_date_time, a.factory_cd, b.machine_name, b.machine_model, b.machine_costvalue from t_vt_moving a left join t_vt_machine b on a.machine_serial = b.machine_serial where 1=1 "); if (!String.IsNullOrEmpty(inVo.MachineSerial)) { sql.Append(" and a.machine_serial =:machine_serial"); sqlParameter.AddParameterString("machine_serial", inVo.MachineSerial); } if (!String.IsNullOrEmpty(inVo.TranferFactoryName)) { sql.Append(" and a.factory_tranfer_cd =:factory_tranfer_cd"); sqlParameter.AddParameterString("factory_tranfer_cd", inVo.TranferFactoryName); } if (!String.IsNullOrEmpty(inVo.ReceivedFactoryName)) { sql.Append(" and a.factory_received_cd =:factory_received_cd"); sqlParameter.AddParameterString("factory_received_cd", inVo.ReceivedFactoryName); } if (inVo.CodeStatus == "Bàn Giao") { if (!String.IsNullOrEmpty(inVo.CodeName)) { sql.Append(" and a.bg_cd =:bg_cd"); sqlParameter.AddParameterString("bg_cd", inVo.CodeName); } else { sql.Append(" and a.bg_cd >'0'"); } } if (inVo.CodeStatus == "Mượn") { if (!String.IsNullOrEmpty(inVo.CodeName)) { sql.Append(" and a.m_cd =:m_cd"); sqlParameter.AddParameterString("m_cd", inVo.CodeName); } else { sql.Append(" and a.m_cd >'0'"); } } if (inVo.CodeStatus == "Trả") { if (!String.IsNullOrEmpty(inVo.CodeName)) { sql.Append(" and a.t_cd =:t_cd"); sqlParameter.AddParameterString("t_cd", inVo.CodeName); } else { sql.Append(" and a.t_cd >'0'"); } } if (inVo.CodeStatus == "Thuê") { if (!String.IsNullOrEmpty(inVo.CodeName)) { sql.Append(" and a.th_cd =:th_cd"); sqlParameter.AddParameterString("th_cd", inVo.CodeName); } else { sql.Append(" and a.th_cd >'0'"); } } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { if (inVo.CodeStatus == "Bàn Giao") { MovingMachineVTVo outVo = new MovingMachineVTVo { MovingId = int.Parse(dataReader["moving_id"].ToString()), MachineSerial = dataReader["machine_serial"].ToString(), TranferFactoryName = dataReader["factory_tranfer_cd"].ToString(), ReceivedFactoryName = dataReader["factory_received_cd"].ToString(), CodeName = dataReader["bg_cd"].ToString(), //only change Status = dataReader["status"].ToString(), CommentsMachine = dataReader["comments_machine"].ToString(), ReasonTranfer = dataReader["reason_tranfer"].ToString(), ConfirmReceived = dataReader["confirm_received"].ToString(), MachineName = (dataReader["machine_name"].ToString()), RegistrationUserCode = dataReader["registration_user_cd"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), FactoryCode = dataReader["factory_cd"].ToString(), CodeStatus = inVo.CodeStatus, MachineModel = dataReader["machine_model"].ToString(), MachineCostValue = dataReader["machine_costvalue"].ToString(), }; voList.add(outVo); } if (inVo.CodeStatus == "Mượn") { MovingMachineVTVo outVo = new MovingMachineVTVo { MovingId = int.Parse(dataReader["moving_id"].ToString()), MachineSerial = dataReader["machine_serial"].ToString(), TranferFactoryName = dataReader["factory_tranfer_cd"].ToString(), ReceivedFactoryName = dataReader["factory_received_cd"].ToString(), CodeName = dataReader["m_cd"].ToString(),//only change Status = dataReader["status"].ToString(), CommentsMachine = dataReader["comments_machine"].ToString(), ReasonTranfer = dataReader["reason_tranfer"].ToString(), ConfirmReceived = dataReader["confirm_received"].ToString(), MachineName = (dataReader["machine_name"].ToString()), RegistrationUserCode = dataReader["registration_user_cd"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), FactoryCode = dataReader["factory_cd"].ToString(), CodeStatus = inVo.CodeStatus, MachineModel = dataReader["machine_model"].ToString(), MachineCostValue = dataReader["machine_costvalue"].ToString(), }; voList.add(outVo); } if (inVo.CodeStatus == "Trả") { MovingMachineVTVo outVo = new MovingMachineVTVo { MovingId = int.Parse(dataReader["moving_id"].ToString()), MachineSerial = dataReader["machine_serial"].ToString(), TranferFactoryName = dataReader["factory_tranfer_cd"].ToString(), ReceivedFactoryName = dataReader["factory_received_cd"].ToString(), CodeName = dataReader["t_cd"].ToString(),//only change Status = dataReader["status"].ToString(), CommentsMachine = dataReader["comments_machine"].ToString(), ReasonTranfer = dataReader["reason_tranfer"].ToString(), ConfirmReceived = dataReader["confirm_received"].ToString(), MachineName = (dataReader["machine_name"].ToString()), RegistrationUserCode = dataReader["registration_user_cd"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), FactoryCode = dataReader["factory_cd"].ToString(), CodeStatus = inVo.CodeStatus, MachineModel = dataReader["machine_model"].ToString(), MachineCostValue = dataReader["machine_costvalue"].ToString(), }; voList.add(outVo); } if (inVo.CodeStatus == "Thuê") { MovingMachineVTVo outVo = new MovingMachineVTVo { MovingId = int.Parse(dataReader["moving_id"].ToString()), MachineSerial = dataReader["machine_serial"].ToString(), TranferFactoryName = dataReader["factory_tranfer_cd"].ToString(), ReceivedFactoryName = dataReader["factory_received_cd"].ToString(), CodeName = dataReader["th_cd"].ToString(),//only change Status = dataReader["status"].ToString(), CommentsMachine = dataReader["comments_machine"].ToString(), ReasonTranfer = dataReader["reason_tranfer"].ToString(), ConfirmReceived = dataReader["confirm_received"].ToString(), MachineName = (dataReader["machine_name"].ToString()), RegistrationUserCode = dataReader["registration_user_cd"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), FactoryCode = dataReader["factory_cd"].ToString(), CodeStatus = inVo.CodeStatus, MachineModel = dataReader["machine_model"].ToString(), MachineCostValue = dataReader["machine_costvalue"].ToString(), }; voList.add(outVo); } } dataReader.Close(); return(voList); }