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