private async Task <IEnumerable <PersonVo> > GetPeopleAsync()
{
var list = new List <PersonVo>();
var bs = Resources.人员名单资料;
IWorkbook workbook = new XSSFWorkbook(new MemoryStream(bs));
ISheet sheet = workbook.GetSheetAt(0); //获取第一个工作表
for (int i = 1; i < sheet.LastRowNum; i++) //对工作表每一行
{
var row = sheet.GetRow(i);
if (row != null)
{
var person = new PersonVo()
{
Id = row.GetCell(0).ToString(),
Name = row.GetCell(2).ToString(),
IDCardNumber = row.GetCell(5).ToString(),
ExaminationNumber = row.GetCell(1).ToString(),
School = row.GetCell(8).ToString(),
Class = row.GetCell(6).ToString(),
StudentNumber = row.GetCell(7).ToString(),
HasCollection = false
};
if (DateTime.TryParseExact(row.GetCell(4).ToString(), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime dt))
{
person.Birthday = dt;
}
list.Add(person);
}
}
workbook.Close();
return(list);
}
/*
* PagedSearchDTO<PersonVO> FindWithPagedSearch(string name, string sortDirection, int pageSize, int page)
* {
* string query = @"select * from person p where";
* if (!string.IsNullOrEmpty(name)) query = query + $"and p.name like '%{name}%";
* query = query + $"order by p.name{sortDirection} limit {pageSize} offset{page}";
* string countQuery = @"select * from person p where";
* if (!string.IsNullOrEmpty(name)) countQuery = countQuery + $"and p.name like '%{name}%";
*
*
* var persons = this.converter.ParserList(this.repository.FindWithPagedSearch(query));
* int totalResults = this.repository.GetCount(query);
* return new PagedSearchDTO<PersonVO>
* {
* CurrentPage = page,
* List = this.converter.ParserList(persons),
* PageSize = pageSize,
* SortDirections = sortDirection,
* TotalResults = totalResults
*
* };
* }
*/
public PersonVo Update(PersonVo person)
{
var personEntity = this.converter.Parse(person);
personEntity = this.repository.Update(personEntity);
return(this.converter.Parse(personEntity));
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PersonVo inVo = (PersonVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from t_productioncontroller_person Where 1=1 ");
{
sql.Append(" and person_id = :person_id ");
sqlParameter.AddParameterInteger("person_id", inVo.PersonId);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
PersonVo outVo = new PersonVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void delete_btn_Click(object sender, EventArgs e)
{
if (person_dgv.RowCount > 0)
{
int selectedrowindex = person_dgv.SelectedCells[0].RowIndex;
PersonVo vo = (PersonVo)person_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.DateTimes.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
PersonVo checkPerson = (PersonVo)DefaultCbmInvoker.Invoke(new CheckPersonCbm(), new PersonVo()
{
PersonId = vo.PersonId, RegistrationUserCode = UserData.GetUserData().UserCode
});
if (dialogResult == DialogResult.OK)
{
if (checkPerson.AffectedCount > 0)
{
try
{
PersonVo outVo = (PersonVo)DefaultCbmInvoker.Invoke(new DeletePersonCbm(), vo);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
clearcmb();
add_btn.Text = "Cập Nhật";
add_btn.BackColor = Color.Green;
setting_gbc.Text = "Info";
GridBind();
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
else if (checkPerson.AffectedCount == 0)
{
messageData = new MessageData("mmci00003", "Bạn không có quyền xóa dòng này ! ", null);
logger.Warn(messageData);
popUpMessage.Information(messageData, Text);
}
}
}
}
public IActionResult Put([FromBody] PersonVo person)
{
if (person == null)
{
NotFound();
}
return(new ObjectResult(this.personBusiness.Update(person)));
}
public IActionResult Post([FromBody] PersonVo person)
{
if (person == null)
{
return(BadRequest());
}
return(new ObjectResult(this.personBusiness.Create(person)));
}
private void person_dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (person_dgv.RowCount > 0)
{
int selectedrowindex = person_dgv.SelectedCells[0].RowIndex;
vo = (PersonVo)person_dgv.Rows[selectedrowindex].DataBoundItem;
PersonVo checkPerson = (PersonVo)DefaultCbmInvoker.Invoke(new CheckPersonCbm(), new PersonVo()
{
PersonId = vo.PersonId, RegistrationUserCode = UserData.GetUserData().UserCode
});
if (checkPerson.AffectedCount > 0)
{
try
{
model_cmb.Text = vo.Model;
line_cmb.Text = vo.Line;
datetime_dtp.Value = vo.DateTimes;
shift_cmb.Text = vo.Shift.ToString();
lot_txt.Text = vo.LotNumber;
plan_txt.Text = vo.PlanPro.ToString();
st_plan_txt.Text = vo.PlanST.ToString();
st_actual_txt.Text = vo.ActualSt.ToString();
actual_co_txt.Text = vo.DoCo.ToString();
actual_ra_txt.Text = vo.DoRa.ToString();
actual_ca_txt.Text = vo.DoCa.ToString();
actual_ba_txt.Text = vo.DoBa.ToString();
actual_ma_txt.Text = vo.DoMa.ToString();
absent_co_txt.Text = vo.AbsentCo.ToString();
absent_ra_txt.Text = vo.AbsentRa.ToString();
absent_ca_txt.Text = vo.AbsentCa.ToString();
absent_ba_txt.Text = vo.AbsentBa.ToString();
absent_ma_txt.Text = vo.AbsentMa.ToString();
overtime_txt.Text = vo.TimeOver.ToString();
offsettime_txt.Text = vo.TimeOffset.ToString();
totaltime_txt.Text = vo.TimeTotal.ToString();
add_btn.Text = "Chỉnh Sửa";
add_btn.BackColor = Color.Yellow;
actual_co_txt_Click(sender, e);
setting_gbc.Text = "Update Info";
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
else if (checkPerson.AffectedCount == 0)
{
messageData = new MessageData("mmci00003", "Bạn không có quyền chỉnh sửa dòng này ! ", null);
logger.Warn(messageData);
popUpMessage.Information(messageData, Text);
}
}
}
public async Task BuyBook(PersonVo person, BookVo book)
{
var buyingRecord = new BuyingRecord();
buyingRecord.Id = Guid.NewGuid().ToString();
buyingRecord.TradingPrice = (float)(book.Price * 0.8);
buyingRecord.CurrentOwner = person.Id;
buyingRecord.TradingTime = DateTime.Now.AddMinutes(-_Random.Next(100, 10000));
buyingRecord.Book = book.Id;
await _buyingRecordWrite.InsertAsync(buyingRecord);
}
private void edit_btn_Click(object sender, EventArgs e)
{
totaltime();
if (Checkdata())
{
PersonVo invo = new PersonVo
{
PersonId = vo.PersonId,
Model = model_cmb.Text,
Line = line_cmb.Text,
DateTimes = datetime_dtp.Value,
FactoryCode = UserData.GetUserData().FactoryCode,
BuildingCode = "2A",
LotNumber = lot_txt.Text,
LeaderName = leader_txt.Text,
Shift = int.Parse(shift_cmb.Text),
PlanPro = int.Parse(plan_txt.Text),
PlanST = double.Parse(st_plan_txt.Text),
ActualSt = double.Parse(st_actual_txt.Text),
DoCo = double.Parse(actual_co_txt.Text),
DoRa = double.Parse(actual_ra_txt.Text),
DoCa = double.Parse(actual_ca_txt.Text),
DoBa = double.Parse(actual_ba_txt.Text),
DoMa = double.Parse(actual_ma_txt.Text),
AbsentCo = double.Parse(absent_co_txt.Text),
AbsentRa = double.Parse(absent_ra_txt.Text),
AbsentCa = double.Parse(absent_ca_txt.Text),
AbsentBa = double.Parse(absent_ba_txt.Text),
AbsentMa = double.Parse(absent_ma_txt.Text),
TimeOver = double.Parse(overtime_txt.Text),
TimeOffset = double.Parse(offsettime_txt.Text),
TimeTotal = double.Parse(totaltime_txt.Text),
RegistrationUserCode = UserData.GetUserData().UserCode,
};
try
{
PersonVo updatePerson = (PersonVo)DefaultCbmInvoker.Invoke(new UpdatePersonProCbm(), invo);
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, leader_lbl.Text + " : " + leader_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
//clearcmb();
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PersonVo inVo = (PersonVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into t_productioncontroller_person(model_cd, line_cd,datetimes,factory_cd,building_cd, ");
sql.Append("lot_numbers, leader_name, shift, plan_pro, plan_st, actual_st, doing_co, absent_co, doing_ra,");
sql.Append("absent_ra,doing_ca, absent_ca, doing_ba, absent_ba,doing_ma, absent_ma, timeover, timeoffset, sum_timedoing, registration_user_cd )");
sql.Append("values(:model_cd,:line_cd, :datetimes,:factory_cd,:building_cd,");
sql.Append(":lot_numbers, :leader_name, :shift, :plan_pro,:plan_st,:actual_st,:doing_co,:absent_co,:doing_ra,");
sql.Append(":absent_ra, :doing_ca,:absent_ca,:doing_ba, :absent_ba, :doing_ma, :absent_ma, :timeover, :timeoffset, :sum_timedoing, :registration_user_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("model_cd", inVo.Model);
sqlParameter.AddParameterString("line_cd", inVo.Line);
sqlParameter.AddParameterDateTime("datetimes", inVo.DateTimes);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("building_cd", inVo.BuildingCode);
sqlParameter.AddParameterString("lot_numbers", inVo.LotNumber);
sqlParameter.AddParameterString("leader_name", inVo.LeaderName);
sqlParameter.AddParameterInteger("shift", inVo.Shift);
sqlParameter.AddParameterInteger("plan_pro", inVo.PlanPro);
sqlParameter.AddParameter("plan_st", inVo.PlanST);
sqlParameter.AddParameter("actual_st", inVo.ActualSt);
sqlParameter.AddParameter("doing_co", inVo.DoCo);
sqlParameter.AddParameter("doing_ra", inVo.DoRa);
sqlParameter.AddParameter("doing_ca", inVo.DoCa);
sqlParameter.AddParameter("doing_ba", inVo.DoBa);
sqlParameter.AddParameter("doing_ma", inVo.DoMa);
sqlParameter.AddParameter("absent_co", inVo.AbsentCo);
sqlParameter.AddParameter("absent_ra", inVo.AbsentRa);
sqlParameter.AddParameter("absent_ca", inVo.AbsentCa);
sqlParameter.AddParameter("absent_ba", inVo.AbsentBa);
sqlParameter.AddParameter("absent_ma", inVo.AbsentMa);
sqlParameter.AddParameter("timeover", inVo.TimeOver);
sqlParameter.AddParameter("timeoffset", inVo.TimeOffset);
sqlParameter.AddParameter("sum_timedoing", inVo.TimeTotal);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
PersonVo outVo = new PersonVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PersonVo inVo = (PersonVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <PersonVo> voList = new ValueObjectList <PersonVo>();
//PersonVo outVo = new PersonVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select count(*) as counter from t_productioncontroller_person where 1=1 ");
if (!String.IsNullOrEmpty(inVo.DateTimes.ToString()))
{
sql.Append(" and cast(datetimes as date) = :datetimes");
sqlParameter.AddParameter("datetimes", inVo.DateTimes.Date);
}
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(" and model_cd =:model_cd");
sqlParameter.AddParameterString("model_cd", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Line))
{
sql.Append(" and line_cd =:line_cd");
sqlParameter.AddParameterString("line_cd", inVo.Line);
}
if (inVo.Shift > 0 && inVo.Shift < 4)
{
sql.Append(" and shift =:shift");
sqlParameter.AddParameter("shift", inVo.Shift);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
string dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
PersonVo outVo = new PersonVo
{
AffectedCount = int.Parse(dataReader),
//AffectedCount
};
//voList.add(outVo);
//dataReader.Close();
return(outVo);
}
public PersonVo GetPersonByUserId(string userId)
{
ITPersonMsDao dao = ComponentLocator.Instance().Resolve <ITPersonMsDao>();
TPersonMs personms = dao.getPersonByUserId(userId);
if (personms == null)
{
throw new ApplicationException(MessageUtils.GetMessage("E0001"));
}
else
{
PersonVo personvo = new PersonVo();
PropertiesCopier.CopyProperties(personms, personvo);
personvo.ICompanyCd = personms.Id.ICompanyCd;
personvo.IPersonCd = personms.Id.IPersonCd;
return(personvo);
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PersonVo inVo = (PersonVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <PersonVo> voList = new ValueObjectList <PersonVo>();
//PersonVo outVo = new PersonVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select count(*) as counter from t_productioncontroller_person where 1=1 ");
if (inVo.PersonId > 0)
{
sql.Append(" and person_id =:person_id");
sqlParameter.AddParameter("person_id", inVo.PersonId);
}
if (!String.IsNullOrEmpty(inVo.RegistrationUserCode))
{
sql.Append(" and registration_user_cd =:registration_user_cd");
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
string dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
PersonVo outVo = new PersonVo
{
AffectedCount = int.Parse(dataReader),
};
return(outVo);
}
private void GridBind()
{
person_dgv.DataSource = null;
try
{
PersonVo vo = new PersonVo
{
Line = line_cmb.Text,
Model = model_cmb.Text,
Shift = int.Parse(shift_cmb.Text),
TimeFrom = DateTime.Parse(timefrom_dtp.Value.ToShortDateString()),
TimeTo = DateTime.Parse(timeto_dtp.Value.ToShortDateString()),
};
ValueObjectList <PersonVo> volist = (ValueObjectList <PersonVo>)DefaultCbmInvoker.Invoke(new SearchPersonCbm(), vo);
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
person_dgv.DataSource = bindingsource;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
bool Checkdata()
{
if (lot_txt.Text.Length < 3)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, lot_lbl.Text);
popUpMessage.Warning(messageData, Text);
lot_txt.Focus();
return(false);
}
if (plan_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, plan_lbl.Text);
popUpMessage.Warning(messageData, Text);
plan_txt.Focus();
return(false);
}
if (st_plan_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, st_plan_lbl.Text);
popUpMessage.Warning(messageData, Text);
st_plan_txt.Focus();
return(false);
}
if (st_actual_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, st_actual_lbl.Text);
popUpMessage.Warning(messageData, Text);
st_actual_txt.Focus();
return(false);
}
if (actual_co_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, actual_co_lbl.Text);
popUpMessage.Warning(messageData, Text);
actual_co_txt.Focus();
return(false);
}
if (absent_co_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, absent_co_lbl.Text);
popUpMessage.Warning(messageData, Text);
absent_co_txt.Focus();
return(false);
}
if (actual_ra_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, actual_ra_lbl.Text);
popUpMessage.Warning(messageData, Text);
actual_ra_txt.Focus();
return(false);
}
if (absent_ra_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, absent_ra_lbl.Text);
popUpMessage.Warning(messageData, Text);
absent_ra_txt.Focus();
return(false);
}
if (actual_ma_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, actual_ma_lbl.Text);
popUpMessage.Warning(messageData, Text);
actual_ma_txt.Focus();
return(false);
}
if (absent_ma_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, absent_ma_lbl.Text);
popUpMessage.Warning(messageData, Text);
absent_ma_txt.Focus();
return(false);
}
if (actual_ba_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, actual_ba_lbl.Text);
popUpMessage.Warning(messageData, Text);
actual_ba_txt.Focus();
return(false);
}
if (absent_ba_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, absent_ba_lbl.Text);
popUpMessage.Warning(messageData, Text);
absent_ba_txt.Focus();
return(false);
}
if (actual_ca_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, actual_ca_lbl.Text);
popUpMessage.Warning(messageData, Text);
actual_ca_txt.Focus();
return(false);
}
if (absent_ca_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, absent_ca_lbl.Text);
popUpMessage.Warning(messageData, Text);
absent_ca_txt.Focus();
return(false);
}
if (shift_cmb.SelectedItem == null)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, shift_lbl.Text);
popUpMessage.Warning(messageData, Text);
shift_cmb.Focus();
return(false);
}
if (line_cmb.Text == "" || line_cmb.Text == "All Line")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, line_lbl.Text);
popUpMessage.Warning(messageData, Text);
line_cmb.Focus();
return(false);
}
if (model_cmb.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, model_lbl.Text);
popUpMessage.Warning(messageData, Text);
model_cmb.Focus();
return(false);
}
PersonVo check = (PersonVo)DefaultCbmInvoker.Invoke(new CheckPerson_DuplicateCbm(), new PersonVo()
{
DateTimes = datetime_dtp.Value, Model = model_cmb.Text, Line = line_cmb.Text, Shift = int.Parse(shift_cmb.Text)
});
if (check.AffectedCount >= 1 && add_btn.Text == "Cập Nhật")
{
messageData = new MessageData("mmcc00005", "Dữ liệu ca " + shift_cmb.Text + " Line " + line_cmb.Text + " ngày " + datetime_dtp.Text + " đã tồn tại !", leader_lbl.Text);
popUpMessage.Warning(messageData, Text);
leader_txt.Focus();
return(false);
}
if (leader_txt.Text == "")
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, leader_lbl.Text);
popUpMessage.Warning(messageData, Text);
leader_txt.Focus();
return(false);
}
return(true);
}
private void MainForm_Load(object sender, EventArgs e)
{
try
{
SplashScreen.UdpateStatusText(MessageUtils.GetMessage("I0001"));
ToolStripManager.Renderer = new Office2007Renderer();
//get all condition
String d = LangUtils.GetDefaultLanguage();
ConditionUtils.GetAllConditionsList(d);
Thread.CurrentThread.CurrentUICulture = (System.Globalization.CultureInfo) new System.Globalization.CultureInfo(d);
rm = new System.Resources.ResourceManager(typeof(MainForm));
init_ToolStripComboBox();
//castle windsor initial
ComponentLocator.Instance();
LoginUserInfoVo uservo = (LoginUserInfoVo)SessionUtils.GetSession(SessionUtils.COMMON_LOGIN_USER_INFO);
IAction_MainForm af = ComponentLocator.Instance().Resolve <IAction_MainForm>();
//display status strip
this.toolStripStatusLabelTime.Text = rm.GetString("Status.Time") + DateTime.Now.GetDateTimeFormats('D')[3].ToString();
this.toolStripStatusLabelLoginUser.Text = rm.GetString("Status.LoginUser") + uservo.Username;
SplashScreen.UdpateStatusText(MessageUtils.GetMessage("I0004"));
//IList<FunctionAllVo> flist = af.GetFunctionDataList();
//加载用户权限。
IList <FunctionAllVo> flist = af.GetCatalogFunctionByUserId(uservo.Userid);
//加载工厂
TermVo termvo = af.GetTermInfo(uservo.Userid);
uservo.Term = termvo;
if (termvo == null)
{
uservo.Factory = null;
}
else
{
FactoryVo factory = af.GetFactoryByCd(termvo.IFacCd);
uservo.Factory = factory;
}
//加载person
PersonVo person = af.GetPersonByUserId(uservo.Userid);
uservo.Person = person;
CompanyConditionVo companycondition = af.GetCompanyCondition(person.ICompanyCd);
uservo.CompanyCondition = companycondition;
this.toolStripStatusLabelCompany.Text = companycondition.ICompanyArgDesc;
//SessionUtils.RemoveSession(SessionUtils.COMMON_LOGIN_USER_INFO);
//SessionUtils.SetSession(SessionUtils.COMMON_LOGIN_USER_INFO, uservo);
SplashScreen.UdpateStatusText(MessageUtils.GetMessage("I0002"));
init_MenuStrip(flist);
init_MenuWindow(flist);
//Thread.Sleep(1000);
//SplashScreen.UdpateStatusTextWithStatus("Success Message", TypeOfMessage.Success);
SplashScreen.UdpateStatusText(MessageUtils.GetMessage("I0003"));
this.Show();
SplashScreen.CloseSplashScreen();
this.Activate();
}
catch (ApplicationException ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
this.Dispose();
}
}
private void add_btn_Click(object sender, EventArgs e)
{
totaltime();
if (Checkdata())
{
PersonVo outvo = new PersonVo();
try
{
if (add_btn.Text == "Cập Nhật")
{
PersonVo invo = new PersonVo
{
Model = model_cmb.Text,
Line = line_cmb.Text,
DateTimes = datetime_dtp.Value,
FactoryCode = UserData.GetUserData().FactoryCode,
BuildingCode = "2A",
LotNumber = lot_txt.Text,
LeaderName = leader_txt.Text,
Shift = int.Parse(shift_cmb.Text),
PlanPro = int.Parse(plan_txt.Text),
PlanST = double.Parse(st_plan_txt.Text),
ActualSt = double.Parse(st_actual_txt.Text),
DoCo = double.Parse(actual_co_txt.Text),
DoRa = double.Parse(actual_ra_txt.Text),
DoCa = double.Parse(actual_ca_txt.Text),
DoBa = double.Parse(actual_ba_txt.Text),
DoMa = double.Parse(actual_ma_txt.Text),
AbsentCo = double.Parse(absent_co_txt.Text),
AbsentRa = double.Parse(absent_ra_txt.Text),
AbsentCa = double.Parse(absent_ca_txt.Text),
AbsentBa = double.Parse(absent_ba_txt.Text),
AbsentMa = double.Parse(absent_ma_txt.Text),
TimeOver = double.Parse(overtime_txt.Text),
TimeOffset = double.Parse(offsettime_txt.Text),
TimeTotal = double.Parse(totaltime_txt.Text),
RegistrationUserCode = UserData.GetUserData().UserCode,
};
outvo = (PersonVo)DefaultCbmInvoker.Invoke(new AddPersonProCbm(), invo);
}
else if (add_btn.Text == "Chỉnh Sửa")
{
PersonVo invoUpdate = new PersonVo
{
PersonId = vo.PersonId,
Model = model_cmb.Text,
Line = line_cmb.Text,
DateTimes = datetime_dtp.Value,
FactoryCode = UserData.GetUserData().FactoryCode,
BuildingCode = "2A",
LotNumber = lot_txt.Text,
LeaderName = leader_txt.Text,
Shift = int.Parse(shift_cmb.Text),
PlanPro = int.Parse(plan_txt.Text),
PlanST = double.Parse(st_plan_txt.Text),
ActualSt = double.Parse(st_actual_txt.Text),
DoCo = double.Parse(actual_co_txt.Text),
DoRa = double.Parse(actual_ra_txt.Text),
DoCa = double.Parse(actual_ca_txt.Text),
DoBa = double.Parse(actual_ba_txt.Text),
DoMa = double.Parse(actual_ma_txt.Text),
AbsentCo = double.Parse(absent_co_txt.Text),
AbsentRa = double.Parse(absent_ra_txt.Text),
AbsentCa = double.Parse(absent_ca_txt.Text),
AbsentBa = double.Parse(absent_ba_txt.Text),
AbsentMa = double.Parse(absent_ma_txt.Text),
TimeOver = double.Parse(overtime_txt.Text),
TimeOffset = double.Parse(offsettime_txt.Text),
TimeTotal = double.Parse(totaltime_txt.Text),
RegistrationUserCode = UserData.GetUserData().UserCode
};
outvo = (PersonVo)DefaultCbmInvoker.Invoke(new UpdatePersonProCbm(), invoUpdate);
add_btn.Text = "Cập Nhật";
add_btn.BackColor = Color.Green;
setting_gbc.Text = "Info";
}
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, leader_lbl.Text + " : " + leader_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
clearcmb();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PersonVo inVo = (PersonVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <PersonVo> voList = new ValueObjectList <PersonVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select person_id, model_cd, line_cd, datetimes, factory_cd, building_cd,lot_numbers, leader_name, shift,plan_pro, plan_st, actual_st, doing_co,absent_co,");
sql.Append("doing_ra,absent_ra, doing_ca, absent_ca, doing_ba, absent_ba, doing_ma, absent_ma, timeover, timeoffset, sum_timedoing, registration_user_cd, factory_cd from t_productioncontroller_person ");
sql.Append(" where 1=1 ");
sql.Append(@" and datetimes >= :timefrom");
sqlParameter.AddParameterDateTime("timefrom", inVo.TimeFrom);
sql.Append(" and datetimes <= :timeto");
sqlParameter.AddParameterDateTime("timeto", inVo.TimeTo);
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(" and model_cd =:model_cd");
sqlParameter.AddParameterString("model_cd", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Line))
{
sql.Append(" and line_cd =:line_cd");
sqlParameter.AddParameterString("line_cd", inVo.Line);
}
if (!String.IsNullOrEmpty(inVo.Shift.ToString()))
{
sql.Append(" and shift =:shift");
sqlParameter.AddParameterInteger("shift", inVo.Shift);
}
//sql.Append(" order by datetimes");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
PersonVo outVo = new PersonVo
{
// , h., i., k., o.prodution_work_content_name
PersonId = int.Parse(dataReader["person_id"].ToString()),
Model = dataReader["model_cd"].ToString(),
Line = dataReader["line_cd"].ToString(),
DateTimes = DateTime.Parse(dataReader["datetimes"].ToString()),
FactoryCode = dataReader["factory_cd"].ToString(),
BuildingCode = dataReader["building_cd"].ToString(),
LotNumber = dataReader["lot_numbers"].ToString(),
LeaderName = dataReader["leader_name"].ToString(),
Shift = int.Parse(dataReader["shift"].ToString()),
PlanPro = int.Parse(dataReader["plan_pro"].ToString()),
PlanST = double.Parse(dataReader["plan_st"].ToString()),
ActualSt = double.Parse(dataReader["actual_st"].ToString()),
DoCo = double.Parse(dataReader["doing_co"].ToString()),
AbsentCo = double.Parse(dataReader["absent_co"].ToString()),
DoRa = double.Parse(dataReader["doing_ra"].ToString()),
AbsentRa = double.Parse(dataReader["absent_ra"].ToString()),
DoCa = double.Parse(dataReader["doing_ca"].ToString()),
AbsentCa = double.Parse(dataReader["absent_ca"].ToString()),
DoBa = double.Parse(dataReader["doing_ba"].ToString()),
AbsentBa = double.Parse(dataReader["absent_ba"].ToString()),
DoMa = double.Parse(dataReader["doing_ma"].ToString()),
AbsentMa = double.Parse(dataReader["absent_ma"].ToString()),
TimeOver = double.Parse(dataReader["timeover"].ToString()),
TimeOffset = double.Parse(dataReader["timeoffset"].ToString()),
TimeTotal = double.Parse(dataReader["sum_timedoing"].ToString()),
RegistrationUserCode = dataReader["registration_user_cd"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
