private void btn_chg_gh_Click(object sender, EventArgs e)
{
string old_workno, new_workno;
old_workno = txt_old_gh.get_value();
new_workno = txt_new_gh.get_value();
if ((old_workno == "") || (new_workno == ""))
{
MessageBox.Show("新、旧工号不能为空 ！");
return;
}
工号表DAL 工号表 = new 工号表DAL();
if (!工号表.IsIn工号表(new_workno))
{
MessageBox.Show("工号错误 或者 不在工号表中 \n 请检查！");
return;
}
工号台时表DAL dal = new 工号台时表DAL();
dal.updateWorkno(old_workno, new_workno, mydate.Value, deptcode);
MessageBox.Show("更改结束");
fill();
}
private void fill()
{
工号台时表DAL dal = new 工号台时表DAL();
mygrid.set_date(dal.getDatePerMonth(mydate.Value));
mygrid.set_hide(0);
}
private void btn_import_Click(object sender, EventArgs e)
{
if (txt_filename.get_value() == "")
{
MessageBox.Show("请指定文件名称");
return;
}
工号表DAL ghdal = new 工号表DAL();
工号台时表DAL dal = new 工号台时表DAL();
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
if (app == null)
{
MessageBox.Show("Excel 启动错误， 程序将返回 ！");
return;
}
Microsoft.Office.Interop.Excel.Workbook wk;
Microsoft.Office.Interop.Excel.Worksheet sh;
string filename = txt_filename.get_value();
if (dal.isHasRecord(mydate.Value, deptcode))
{
wk = app.Workbooks.Open(filename);
sh = null;
foreach (Worksheet mysheet in wk.Worksheets)
{
if (mysheet.Name.Trim() != "成表")
{
continue;
}
else
{
sh = mysheet;
break;
}
}
if (sh == null)
{
MessageBox.Show("没有找到 成表 页 ！");
app.Quit();
return;
}
model.工号台时表 mycls;
List <工号台时表> mylist = new List <工号台时表>();
int myrow = 2;
while (sh.Cells[myrow, 1].value != null)
{
mycls = new 工号台时表();
mycls.Id = Guid.NewGuid();
mycls.工号 = sh.Cells[myrow, 1].value.ToString().Trim();
mycls.部门 = 21;
mycls.日期 = new DateTime(mydate.Value.Year, mydate.Value.Month, 15);
if (sh.Cells[myrow, 2].Value == null)
{
mycls.工时 = 0;
}
else
{
mycls.工时 = (decimal)sh.Cells[myrow, 2].Value;
}
if (sh.Cells[myrow, 3].Value == null)
{
mycls.折合工时 = 0;
}
else
{
mycls.折合工时 = (decimal)sh.Cells[myrow, 3].Value;
}
mylist.Add(mycls);
myrow++;
}
app.Quit();
工号表DAL dal2 = new 工号表DAL();
string wrongworkno = "";
bool wrongflag = true;
foreach (工号台时表 工号台时 in mylist)
{
if (!dal2.IsIn工号表(工号台时.工号))
{
wrongworkno += 工号台时.工号 + ", ";
wrongflag = false;
}
}
if (!wrongflag)
{
MessageBox.Show(wrongworkno, "错误工号");
return;
}
工号台时表DAL da1l = new 工号台时表DAL();
foreach (工号台时表 工号台时 in mylist)
{
da1l.Add(工号台时);
}
}
fill();
}
