public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DrawingVo inVo = (DrawingVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DrawingVo> voList = new ValueObjectList <DrawingVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT distinct b.machine_name from m_machine b, t_draw a where a.machine_id = b.machine_id and model_id = :model_id");
sqlParameter.AddParameterInteger("model_id", inVo.ModelId);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DrawingVo outVo = new DrawingVo
{
//DrawId = int.Parse(dataReader["draw_id"].ToString()),
//DrawCode = dataReader["draw_cd"].ToString(),
MachineName = dataReader["machine_name"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DrawingVo inVo = (DrawingVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DrawingVo> voList = new ValueObjectList <DrawingVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT distinct department from t_draw");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DrawingVo outVo = new DrawingVo
{
Department = dataReader["department"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void drawing_cmb_SelectedIndexChanged(object sender, EventArgs e)
{
if (drawing_cmb.SelectedItem != null)
{
DrawingVo dvo = (DrawingVo)drawing_cmb.SelectedItem;
ValueObjectList <DrawingVo> drawvolist = (ValueObjectList <DrawingVo>)DefaultCbmInvoker.Invoke(new GetDrawingCbm(), new DrawingVo {
DrawType = dvo.DrawType, ModelId = ((ModelVo)this.model_cmb.SelectedItem).ModelId
});
version_cmb.DisplayMember = "DrawCode";
version_cmb.DataSource = drawvolist.GetList();
version_cmb.Text = "";
}
}
private void update_btn_Click(object sender, EventArgs e)
{
if (draw_dgv.SelectedCells.Count > 0)
{
DrawingVo selectedvo = (DrawingVo)draw_dgv.CurrentRow.DataBoundItem;
if (new AddDrawForm {
vo = selectedvo
}.ShowDialog() != DialogResult.OK)
{
selectdata();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DrawingVo inVo = (DrawingVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_draw set device_cd=:device_cd,
draw_id=:draw_id,
model_id=:model_id,
machine_id=:machine_id,
department=:department,
draw_type=:draw_type,
time_record=:time_record,
revision=:revision");
sql.Append(" where device_id =:device_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("device_id", inVo.DeviceID);
sqlParameter.AddParameter("device_cd", inVo.DeviceCode);
sqlParameter.AddParameter("draw_id", inVo.DrawId);
sqlParameter.AddParameter("model_id", inVo.ModelId);
sqlParameter.AddParameter("machine_id", inVo.MachineID);
sqlParameter.AddParameter("department", inVo.Department);
sqlParameter.AddParameter("draw_type", inVo.DrawType);
sqlParameter.AddParameter("time_record", inVo.TimeFrom);
sqlParameter.AddParameter("revision", inVo.Revision);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("factory_cd", inVo.FactoryCode);
//execute SQL
DrawingVo outVo = new DrawingVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DrawingVo inVo = (DrawingVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DrawingVo> voList = new ValueObjectList <DrawingVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT a.device_id, a.device_cd, b.draw_cd, c.model_cd, d.machine_name, a.time_record,
a.department, a.revision, a.registration_user_cd,a.registration_date_time, a.registration_user_cd, a.factory_cd
from t_draw a
left join m_draw b on b.draw_id = a.draw_id
left join m_model c on c.model_id = a.model_id
left join m_machine d on d.machine_id = a.machine_id
WHERE ");
sql.Append(@"time_record >= :timefrom");
sqlParameter.AddParameterDateTime("timefrom", inVo.TimeFrom);
sql.Append(" and time_record <= :timeto");
sqlParameter.AddParameterDateTime("timeto", inVo.TimeTo);
if (!String.IsNullOrEmpty(inVo.DeviceCode))
{
sql.Append(" and device_cd =:device_cd ");
sqlParameter.AddParameterString("device_cd", inVo.DeviceCode);
}
if (!String.IsNullOrEmpty(inVo.ModelCode))
{
sql.Append(" and model_cd =:model_cd ");
sqlParameter.AddParameterString("model_cd", inVo.ModelCode);
}
if (!String.IsNullOrEmpty(inVo.DrawCode))
{
sql.Append(" and draw_cd =:draw_cd ");
sqlParameter.AddParameterString("draw_cd", inVo.DrawCode);
}
if (!String.IsNullOrEmpty(inVo.MachineName))
{
sql.Append(" and machine_name =:machine_name ");
sqlParameter.AddParameterString("machine_name", inVo.MachineName);
}
if (!String.IsNullOrEmpty(inVo.Department))
{
sql.Append(" and department =:department ");
sqlParameter.AddParameterString("department", inVo.Department);
}
if (!String.IsNullOrEmpty(inVo.Revision))
{
sql.Append(" and revision =:revision ");
sqlParameter.AddParameterString("revision", inVo.Revision);
}
if (!String.IsNullOrEmpty(inVo.DrawType))
{
sql.Append(" and draw_type =:draw_type ");
sqlParameter.AddParameterString("draw_type", inVo.DrawType);
}
if (!String.IsNullOrEmpty(inVo.RegistrationUserCode))
{
sql.Append(" and a.registration_user_cd =:registration_user_cd ");
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DrawingVo outVo = new DrawingVo
{
// , h., i., k., o.prodution_work_content_name
DeviceID = int.Parse(dataReader["device_id"].ToString()),
DeviceCode = dataReader["device_cd"].ToString(),
DrawCode = dataReader["draw_cd"].ToString(),
MachineName = dataReader["machine_name"].ToString(),
Department = dataReader["department"].ToString(),
RegistrationUserCode = dataReader["registration_user_cd"].ToString(),
TimeFrom = DateTime.Parse(dataReader["time_record"].ToString()),
ModelCode = dataReader["model_cd"].ToString(),
Revision = dataReader["revision"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void OK_btn_Click(object sender, EventArgs e) // ok buttion
{
string mcPath = @"Z:\(01)Motor\(02)Engineering\(03)FA\1. PRIVATE DOCUMENTS\1. MECHANIC\MES\" + Machine_cmb.Text + @"\";
string parentPath = mcPath + drawing_cmb.Text + @"\";
string folder1 = parentPath + @"1.Drawing\";
string folder2 = parentPath + @"2.List\";
string folder3 = parentPath + @"3.Calculation\";
string folder4 = parentPath + @"4.Improvement failure\";
string folder1a = folder1 + @"AutoCad\";
string folder1b = folder1 + @"PDF\";
if (!checkdata())
{
return;
}
DrawingVo outVo = new DrawingVo();
DrawingVo inVo = new DrawingVo
{
DeviceID = this.vo.DeviceID,
TimeFrom = this.timereceive_dtp.Value,
ModelId = ((ModelVo)this.model_cmb.SelectedItem).ModelId,
DeviceCode = device_code_txt.Text,
DrawId = ((DrawVo)this.drawing_cmb.SelectedItem).DrawId,
MachineID = ((MachineVo)this.Machine_cmb.SelectedItem).MachineId,
Department = depart_txt.Text,
DrawType = DrawType_txt.Text,
Revision = revision_txt.Text,
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
try
{
if (inVo.DeviceID > 0)
{
outVo = (DrawingVo)DefaultCbmInvoker.Invoke(new UpdateDrawingCbm(), inVo);
}
else
{
outVo = (DrawingVo)DefaultCbmInvoker.Invoke(new AddDrawingCbm(), inVo);
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo.AffectedCount > 0)
{
this.DialogResult = DialogResult.OK;
}
// Create a new target folder.
if (!System.IO.Directory.Exists(mcPath))
{
System.IO.Directory.CreateDirectory(mcPath);
if (!System.IO.Directory.Exists(parentPath))
{
System.IO.Directory.CreateDirectory(parentPath);
System.IO.Directory.CreateDirectory(folder1);
System.IO.Directory.CreateDirectory(folder1a);
System.IO.Directory.CreateDirectory(folder1b);
System.IO.Directory.CreateDirectory(folder2);
System.IO.Directory.CreateDirectory(folder3);
System.IO.Directory.CreateDirectory(folder4);
MessageBox.Show("Drawing folder is created" + "\r\nYou can find it in " + "'" + parentPath + "'", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Drawing folder is already exists!", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (!System.IO.Directory.Exists(parentPath))
{
System.IO.Directory.CreateDirectory(parentPath);
System.IO.Directory.CreateDirectory(folder1);
System.IO.Directory.CreateDirectory(folder1a);
System.IO.Directory.CreateDirectory(folder1b);
System.IO.Directory.CreateDirectory(folder2);
System.IO.Directory.CreateDirectory(folder3);
System.IO.Directory.CreateDirectory(folder4);
MessageBox.Show("Drawing folder is created" + "\r\nYou can find it in " + "'" + parentPath + "'", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Drawing folder is already exists!", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
