private void Button_IdentificationCardModify_Click(object sender, EventArgs e)
{
this.userControl_WelderBase1.FillClass();
string str_NewIdentificationCard = "";
Form_InputBox myForm = new Form_InputBox();
myForm.str_DefaultResponse = this.myClass_Welder.IdentificationCard;
myForm.str_Prompt = "请输入身份证号码：";
myForm.str_Title = "输入身份证号码";
if (myForm.ShowDialog() == DialogResult.OK)
{
str_NewIdentificationCard = myForm.str_DefaultResponse;
}
else
{
return;
}
if (!Class_DataValidateTool.CheckIdentificationCard(str_NewIdentificationCard, this.myClass_Welder.Sex))
{
MessageBox.Show("身份证号码格式错误，操作失败！");
return;
}
if (Class_Welder.ExistAndCanDeleteAndDelete(str_NewIdentificationCard, ZCCL.ClassBase.Enum_zwjKindofUpdate.Exist) == true)
{
MessageBox.Show("身份证号码重复，操作失败！");
return;
}
this.myClass_Welder.IdentificationCardModify(str_NewIdentificationCard, this.myClass_Welder.Sex);
this.userControl_WelderBase1.InitControl(this.myClass_Welder, false);
}
private void Button_WPSIDModify_Click(object sender, EventArgs e)
{
string str_NewWPSID = "";
Form_InputBox myForm = new Form_InputBox();
myForm.str_DefaultResponse = this.myClass_WPS.WPSID;
myForm.str_Prompt = "请输入焊接工艺编号：";
myForm.str_Title = "输入焊接工艺编号";
if (myForm.ShowDialog() == DialogResult.OK)
{
str_NewWPSID = myForm.str_DefaultResponse;
}
if (str_NewWPSID.Length == 0)
{
MessageBox.Show("你没有输入焊接工艺编号，操作失败！");
return;
}
if (Class_WPS.ExistAndCanDeleteAndDelete(str_NewWPSID, ZCCL.ClassBase.Enum_zwjKindofUpdate.Exist) == true)
{
MessageBox.Show("焊接工艺编号重复，操作失败！");
return;
}
this.myClass_WPS.ModifyWPSID(str_NewWPSID);
if (this.myEventArgs_WPSQuery != null)
{
this.myEventArgs_WPSQuery.bool_JustFill = false;
Publisher_WPSQuery.OnEventName(this.myEventArgs_WPSQuery);
}
this.userControl_WPSBase1.InitControl(this.myClass_WPS, false);
}
private void DoRename()
{
if (!SaveData())
{
return;
}
var dr = dgvBalA1.GetCurrentDataRow() as klonsDataSet.BalA1Row;
if (dr == null)
{
return;
}
Form_InputBox f = new Form_InputBox("Bilances atskaites", "Mainīt atskaites kodu", dr.balid);
if (f.ShowDialog(MyMainForm) != DialogResult.OK)
{
return;
}
string newid = f.SelectedValue;
if (newid == dr.balid)
{
return;
}
if (newid == "" || newid.Length > 10 ||
MyData.DataSetKlons.BalA1.FindBybalid(newid) != null)
{
MyMainForm.ShowWarning("Nekorekts atskaites kods: " + newid);
return;
}
dr.balid = newid;
bsBalA2.GetTable().AcceptChanges();
dgvBalA1.RefreshCurrent();
SaveData();
}
private void toolStripMenuItem_RowIssueStatSecond_Click(object sender, EventArgs e)
{
if (myEventArgs_ShipClassification.bool_GXTheory)
{
return;
}
string str_Subhead;
Form_InputBox myForm_InputBox = new Form_InputBox();
myForm_InputBox.str_Title = "报表副标题输入";
myForm_InputBox.str_Prompt = "请输入报表的副标题：";
if (myForm_InputBox.ShowDialog() == DialogResult.OK)
{
str_Subhead = myForm_InputBox.str_DefaultResponse;
}
else
{
return;
}
StringBuilder str_IssueStat = new StringBuilder();
str_IssueStat.Append("select t4.WeldingClass, t4.WeldingClassCount, t5.* from dbo.Exam_Issue as t5 left join");
str_IssueStat.Append(" (select t1.issueno, t3.WeldingClass, count(t3.WeldingClass) as WeldingClassCount from dbo.Exam_Issue as t1 inner join dbo.Exam_Student as t2 on t1.issueno=t2.issueno");
str_IssueStat.Append(" inner join dbo.Parameter_WeldingSubject as t3 on t2.ExamSubjectID = t3.SubjectID");
str_IssueStat.Append(" where t2.SkillResult=1 or t2.SkillMakeupResult=1");
str_IssueStat.Append(" group by t1.issueno, t3.WeldingClass) as t4 on t5.issueno=t4.issueno");
str_IssueStat.Append(" where ");
bool b_Flag = false;
foreach (DataRow myDataRow in this.myDataTable.Rows)
{
if (b_Flag)
{
str_IssueStat.Append(" Or ");
}
else
{
b_Flag = true;
}
str_IssueStat.Append(string.Format(" t5.IssueNo = '{0}'", myDataRow["IssueNo"].ToString()));
}
ReportDataSource[] myReportDataSourceRange = new ReportDataSource[2];
myReportDataSourceRange[0] = new ReportDataSource("DataSet_IssueStat", Class_zwjPublic.myClass_SqlConnection.GetDataTable(str_IssueStat.ToString()));
myReportDataSourceRange[1] = new ReportDataSource("DataSet_IssueStatSecond", this.myDataView);
ReportParameter myReportParameter_Subhead = new ReportParameter("Report_Parameter_Subhead", str_Subhead);
ReportParameter[] myReportParameterRange = new ReportParameter[] { myReportParameter_Subhead };
Form_Report myForm = new Form_Report();
myForm.InitReport("ZCWelder.Reports.焊工考试班级统计汇总表.rdlc", myReportDataSourceRange, myReportParameterRange);
myForm.ShowDialog();
}
public int GetYearToAdd()
{
int yr = 0;
if (MyData.DataSetKlons.ITEMS.WhereNotDeleted().Count() == 0)
{
MyMainForm.ShowWarning("Pamatlīdzekļu saraksts ir tukšs.");
return(0);
}
if (Year2 > 0)
{
yr = Year2 + 1;
}
else
{
yr = DateTime.Today.Year;
}
var fm = new Form_InputBox(
"Pievoenot nolietojuma aprēķina gadu",
"Gads",
yr.ToString());
if (fm.ShowDialog(MyMainForm) != DialogResult.OK)
{
return(0);
}
if (string.IsNullOrEmpty(fm.SelectedValue))
{
MyMainForm.ShowWarning("Netika norādīts gads.");
return(0);
}
if (!int.TryParse(fm.SelectedValue, out yr) || yr < 1900 || yr > 2100)
{
MyMainForm.ShowWarning("Norādīts nekorekts gads.");
return(0);
}
if (MyData.DataSetKlons.TAXDEPRECYEAR.WhereX(d => d.YR == yr).Count() > 0)
{
MyMainForm.ShowWarning("Norādītajam gadam jau ir izveidoti dati.");
return(0);
}
return(yr);
}
private void miAvansaMaksājumaProcentsNoPēdējāsAlgas_Click(object sender, EventArgs e)
{
var f = new Form_InputBox("", "Norādi procentus avansa maksājumam no pēdējās algas", AddPercent.ToString());
var rt = f.ShowDialog();
if (rt != DialogResult.OK)
{
return;
}
string s = f.SelectedValue;
if (!int.TryParse(s, out int p))
{
return;
}
if (p < 0 || p > 100)
{
return;
}
AddPercent = p;
}
public void ShowVacationUseData()
{
if (bsPersons.Position == -1 || bsPersons.Current == null || !Validate())
{
return;
}
var dr = (bsPersons.Current as DataRowView).Row as KlonsADataSet.PERSONSRow;
var rrvd = new RepRowVacDays();
DateTime dt = DateTime.Today;
var fim = new Form_InputBox("Atvaļinājuma dienu aprēķins", "Aprēķina datums:", Utils.DateToString(dt));
var rt = fim.ShowMyDialogModal();
if (rt != DialogResult.OK)
{
return;
}
if (!Utils.StringToDate(fim.SelectedValue, out dt))
{
MyMainForm.ShowWarning("Norādīts nekorekts datums.");
return;
}
var er1 = Report_VacDays.GetVacDaysNotUsed(dr, dt, rrvd);
if (er1 == "OK")
{
string msg = $"Darbinieks: {dr.YNAME}\n";
msg += $"Datums: {Utils.DateToString(dt)}\n\n";
msg += $"Pienākas atvaļinājuma dienas: {rrvd.ToUse}\n";
msg += $"Izmantotās atvaļinājuma dienas: {rrvd.Used}\n";
msg += $"Neizmantotās atvaļinājuma dienas: {rrvd.ToUse - rrvd.Used}\n";
msg += $"Kompensētās atvaļinājuma dienas: {rrvd.Compansated}\n";
msg += $"Atlikušās atvaļinājuma dienas: {rrvd.NotUsed}";
MyMainForm.ShowInfo(msg, "Atvaļinājuma dati:");
}
else
{
MyMainForm.ShowWarning(er1);
}
}
private void DoCopy()
{
if (!SaveData())
{
return;
}
var dr = dgvBalA1.GetCurrentDataRow() as klonsDataSet.BalA1Row;
if (dr == null)
{
return;
}
Form_InputBox f = new Form_InputBox("Bilances atskaites", "Jaunās atskaites kods", "");
if (f.ShowDialog(MyMainForm) != DialogResult.OK)
{
return;
}
string newid = f.SelectedValue;
if (newid == "" || newid.Length > 10 ||
MyData.DataSetKlons.BalA1.FindBybalid(newid) != null)
{
MyMainForm.ShowWarning("Nekorekts atskaites kods: " + newid);
return;
}
try
{
DataSetHelper.CopyRowWithChildRows(dr, null, newid);
}
catch (Exception e)
{
Form_Error.ShowException(MyMainForm, e);
}
SaveData();
Refresh();
}
private void button_StudentQuery_Click(object sender, EventArgs e)
{
string str_ExaminingNo = "";
Form_InputBox myForm = new Form_InputBox();
myForm.str_DefaultResponse = this.textBox_ExaminingNo.Text;
myForm.str_Prompt = "请输入考试编号：";
myForm.str_Title = "输入考试编号";
if (myForm.ShowDialog() == DialogResult.OK)
{
str_ExaminingNo = myForm.str_DefaultResponse;
}
else
{
return;
}
Class_QC myClass_QC = new Class_QC();
myClass_QC.ExaminingNo = str_ExaminingNo;
if (myClass_QC.FillData())
{
if (myClass_QC.ValidUntil > DateTime.Today)
{
Class_Student myClass_Student = new Class_Student(str_ExaminingNo);
this.InitControlStudent(myClass_Student);
}
else
{
MessageBox.Show(string.Format("考试编号为“{0}”的焊工证书已过有效期，不能重新启用！", str_ExaminingNo));
}
}
else
{
MessageBox.Show(string.Format("没有找到考试编号为“{0}”焊工证书！", str_ExaminingNo));
}
}
private void Button_KindofEmployerModify_Click(object sender, EventArgs e)
{
string str_NewKindofEmployer = "";
Form_InputBox myForm = new Form_InputBox();
myForm.str_DefaultResponse = this.myClass_KindofEmployer.KindofEmployer;
myForm.str_Prompt = "请输入报考单位名称：";
myForm.str_Title = "输入报考单位名称";
if (myForm.ShowDialog() == DialogResult.OK)
{
str_NewKindofEmployer = myForm.str_DefaultResponse;
}
else
{
return;
}
if (Class_KindofEmployer.ExistAndCanDeleteAndDelete(str_NewKindofEmployer, ZCCL.ClassBase.Enum_zwjKindofUpdate.Exist) == true)
{
MessageBox.Show("报考单位名称重复，操作失败！");
return;
}
this.myClass_KindofEmployer.KindofEmployerModify(str_NewKindofEmployer);
this.userControl_KindofEmployerBase1.InitControl(this.myClass_KindofEmployer, false);
}
