/// <summary>
/// 保存为新模版
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonSaveNew_Click(object sender, EventArgs e)
{
if (this.CheckIntegrity() == false)
{
return;
}
Templete temp = new Templete();
SignatureTemplate signtemp1 = new SignatureTemplate();
SignatureTemplate signtemp2 = new SignatureTemplate();
SignatureTemplate signtemp3 = new SignatureTemplate();
SignatureTemplate signtemp4 = new SignatureTemplate();
SignatureTemplate signtemp5 = new SignatureTemplate();
SignatureTemplate signtemp6 = new SignatureTemplate();
SignatureTemplate signtemp7 = new SignatureTemplate();
SignatureTemplate signtemp8 = new SignatureTemplate();
SignatureTemplate signtemp9 = new SignatureTemplate();
SignatureTemplate signtemp10 = new SignatureTemplate();
SignatureTemplate signtemp11 = new SignatureTemplate();
SignatureTemplate signtemp12 = new SignatureTemplate();
List <string> list = new List <string>();
List <SignatureTemplate> tlist = new List <SignatureTemplate>();
temp.Name = this.ConTempName.Text.ToString();
list.Add(this.Column1.Text.ToString());
list.Add(this.Column2.Text.ToString());
list.Add(this.Column3.Text.ToString());
list.Add(this.Column4.Text.ToString());
list.Add(this.Column5.Text.ToString());
temp.ColumnNames = list;
signtemp1.SignInfo = this.Sign1.Text.ToString();
Employee emp1 = new Employee();
emp1.Name = this.SignPer1.SelectedText;
emp1.Id = Convert.ToInt32(this.SignPer1.SelectedValue.ToString());
Department dep1 = new Department();
dep1.Id = Convert.ToInt32(this.SignDep1.SelectedValue.ToString());
dep1.Name = this.SignDep1.SelectedText;
emp1.Department = dep1;
signtemp1.SignEmployee = emp1;
signtemp1.SignLevel = Convert.ToInt32(this.Sign1Level.SelectedItem.ToString());
tlist.Add(signtemp1);
signtemp2.SignInfo = this.Sign2.Text.ToString();
Employee emp2 = new Employee();
emp2.Name = this.SignPer2.SelectedText;
emp2.Id = Convert.ToInt32(this.SignPer2.SelectedValue.ToString());
Department dep2 = new Department();
dep2.Id = Convert.ToInt32(this.SignDep2.SelectedValue.ToString());
dep2.Name = this.SignDep2.SelectedText;
emp2.Department = dep2;
signtemp2.SignEmployee = emp2;
signtemp2.SignLevel = Convert.ToInt32(this.Sign2Level.SelectedItem.ToString());
tlist.Add(signtemp2);
signtemp3.SignInfo = this.Sign3.Text.ToString();
Employee emp3 = new Employee();
emp3.Name = this.SignPer3.SelectedText;
emp3.Id = Convert.ToInt32(this.SignPer3.SelectedValue.ToString());
Department dep3 = new Department();
dep3.Id = Convert.ToInt32(this.SignDep3.SelectedValue.ToString());
dep3.Name = this.SignDep3.SelectedText;
emp3.Department = dep3;
signtemp3.SignEmployee = emp3;
signtemp3.SignLevel = Convert.ToInt32(this.Sign3Level.SelectedItem.ToString());
tlist.Add(signtemp3);
signtemp4.SignInfo = this.Sign4.Text.ToString();
Employee emp4 = new Employee();
emp4.Name = this.SignPer4.SelectedText;
emp4.Id = Convert.ToInt32(this.SignPer4.SelectedValue.ToString());
Department dep4 = new Department();
dep4.Id = Convert.ToInt32(this.SignDep4.SelectedValue.ToString());
dep4.Name = this.SignDep4.SelectedText;
emp4.Department = dep4;
signtemp4.SignEmployee = emp4;
signtemp4.SignLevel = Convert.ToInt32(this.Sign4Level.SelectedItem.ToString());
tlist.Add(signtemp4);
signtemp5.SignInfo = this.Sign5.Text.ToString();
Employee emp5 = new Employee();
emp5.Name = this.SignPer5.SelectedText;
emp5.Id = Convert.ToInt32(this.SignPer5.SelectedValue.ToString());
Department dep5 = new Department();
dep5.Id = Convert.ToInt32(this.SignDep5.SelectedValue.ToString());
dep5.Name = this.SignDep5.SelectedText;
emp5.Department = dep5;
signtemp5.SignEmployee = emp5;
signtemp5.SignLevel = Convert.ToInt32(this.Sign5Level.SelectedItem.ToString());
tlist.Add(signtemp5);
signtemp6.SignInfo = this.Sign6.Text.ToString();
Employee emp6 = new Employee();
emp6.Name = this.SignPer6.SelectedText;
emp6.Id = Convert.ToInt32(this.SignPer6.SelectedValue.ToString());
Department dep6 = new Department();
dep6.Id = Convert.ToInt32(this.SignDep6.SelectedValue.ToString());
dep6.Name = this.SignDep6.SelectedText;
emp6.Department = dep6;
signtemp6.SignEmployee = emp6;
signtemp6.SignLevel = Convert.ToInt32(this.Sign6Level.SelectedItem.ToString());
tlist.Add(signtemp6);
signtemp7.SignInfo = this.Sign7.Text.ToString();
Employee emp7 = new Employee();
emp7.Name = this.SignPer7.SelectedText;
emp7.Id = Convert.ToInt32(this.SignPer7.SelectedValue.ToString());
Department dep7 = new Department();
dep7.Id = Convert.ToInt32(this.SignDep4.SelectedValue.ToString());
dep7.Name = this.SignDep7.SelectedText;
emp7.Department = dep7;
signtemp7.SignEmployee = emp7;
signtemp7.SignLevel = Convert.ToInt32(this.Sign7Level.SelectedItem.ToString());
tlist.Add(signtemp7);
signtemp8.SignInfo = this.Sign8.Text.ToString();
Employee emp8 = new Employee();
emp8.Name = this.SignPer8.SelectedText;
emp8.Id = Convert.ToInt32(this.SignPer8.SelectedValue.ToString());
Department dep8 = new Department();
dep8.Id = Convert.ToInt32(this.SignDep8.SelectedValue.ToString());
dep8.Name = this.SignDep8.SelectedText;
emp8.Department = dep8;
signtemp8.SignEmployee = emp8;
signtemp8.SignLevel = Convert.ToInt32(this.Sign8Level.SelectedItem.ToString());
tlist.Add(signtemp8);
signtemp9.SignInfo = this.Sign9.Text.ToString();
Employee emp9 = new Employee();
emp9.Name = this.SignPer9.SelectedText;
emp9.Id = Convert.ToInt32(this.SignPer9.SelectedValue.ToString());
Department dep9 = new Department();
dep9.Id = Convert.ToInt32(this.SignDep9.SelectedValue.ToString());
dep9.Name = this.SignDep9.SelectedText;
emp9.Department = dep9;
signtemp9.SignEmployee = emp9;
signtemp9.SignLevel = Convert.ToInt32(this.Sign9Level.SelectedItem.ToString());
tlist.Add(signtemp9);
signtemp10.SignInfo = this.Sign10.Text.ToString();
Employee emp10 = new Employee();
emp10.Name = this.SignPer10.SelectedText;
emp10.Id = Convert.ToInt32(this.SignPer10.SelectedValue.ToString());
Department dep10 = new Department();
dep10.Id = Convert.ToInt32(this.SignDep10.SelectedValue.ToString());
dep10.Name = this.SignDep10.SelectedText;
emp10.Department = dep10;
signtemp10.SignEmployee = emp10;
signtemp10.SignLevel = Convert.ToInt32(this.Sign10Level.SelectedItem.ToString());
tlist.Add(signtemp10);
signtemp11.SignInfo = this.Sign11.Text.ToString();
Employee emp11 = new Employee();
emp11.Name = this.SignPer11.SelectedText;
emp11.Id = Convert.ToInt32(this.SignPer11.SelectedValue.ToString());
Department dep11 = new Department();
dep11.Id = Convert.ToInt32(this.SignDep11.SelectedValue.ToString());
dep11.Name = this.SignDep11.SelectedText;
emp11.Department = dep11;
signtemp11.SignEmployee = emp11;
signtemp11.SignLevel = Convert.ToInt32(this.Sign11Level.SelectedItem.ToString());
tlist.Add(signtemp11);
signtemp12.SignInfo = this.Sign12.Text.ToString();
Employee emp12 = new Employee();
emp12.Name = this.SignPer12.SelectedText;
emp12.Id = Convert.ToInt32(this.SignPer12.SelectedValue.ToString());
Department dep12 = new Department();
dep12.Id = Convert.ToInt32(this.SignDep12.SelectedValue.ToString());
dep12.Name = this.SignDep12.SelectedText;
emp12.Department = dep12;
signtemp12.SignEmployee = emp12;
signtemp12.SignLevel = Convert.ToInt32(this.Sign12Level.SelectedItem.ToString());
tlist.Add(signtemp12);
temp.Type = 21;
temp.SignDatas = tlist;
string result = _sc.AddConTemplete(temp);
if (result == Response.INSERT_CONTRACT_TEMPLATE_SUCCESS.ToString())
{
MessageBox.Show("保存为新模板" + this.ConTempName.Text + "成功！");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("保存为新模板！");
}
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (this.CheckIntegrity() == false)
{
return;
}
Templete temp = new Templete();
SignatureTemplate signtemp1 = new SignatureTemplate();
SignatureTemplate signtemp2 = new SignatureTemplate();
SignatureTemplate signtemp3 = new SignatureTemplate();
SignatureTemplate signtemp4 = new SignatureTemplate();
SignatureTemplate signtemp5 = new SignatureTemplate();
SignatureTemplate signtemp6 = new SignatureTemplate();
SignatureTemplate signtemp7 = new SignatureTemplate();
SignatureTemplate signtemp8 = new SignatureTemplate();
SignatureTemplate signtemp9 = new SignatureTemplate();
SignatureTemplate signtemp10 = new SignatureTemplate();
SignatureTemplate signtemp11 = new SignatureTemplate();
SignatureTemplate signtemp12 = new SignatureTemplate();
List <string> list = new List <string>();
List <SignatureTemplate> tlist = new List <SignatureTemplate>();
temp.Name = this.ConTempName.Text.ToString();
list.Add(this.Column1.Text.ToString());
list.Add(this.Column2.Text.ToString());
list.Add(this.Column3.Text.ToString());
list.Add(this.Column4.Text.ToString());
list.Add(this.Column5.Text.ToString());
temp.ColumnNames = list;
signtemp1.SignInfo = this.Sign1.Text.ToString();
Employee emp1 = new Employee();
emp1.Name = this.SignPer1.SelectedText;
emp1.Id = Convert.ToInt32(this.SignPer1.SelectedValue.ToString());
Department dep1 = new Department();
dep1.Id = Convert.ToInt32(this.SignDep1.SelectedValue.ToString());
dep1.Name = this.SignDep1.SelectedText;
emp1.Department = dep1;
signtemp1.SignEmployee = emp1;
signtemp1.SignLevel = Convert.ToInt32(this.Sign1Level.SelectedItem.ToString());
signtemp1.CanView = this.View1.SelectedIndex;
signtemp1.CanDownload = this.Download1.SelectedIndex;
tlist.Add(signtemp1);
signtemp2.SignInfo = this.Sign2.Text.ToString();
Employee emp2 = new Employee();
emp2.Name = this.SignPer2.SelectedText;
emp2.Id = Convert.ToInt32(this.SignPer2.SelectedValue.ToString());
Department dep2 = new Department();
dep2.Id = Convert.ToInt32(this.SignDep2.SelectedValue.ToString());
dep2.Name = this.SignDep2.SelectedText;
emp2.Department = dep2;
signtemp2.SignEmployee = emp2;
signtemp2.SignLevel = Convert.ToInt32(this.Sign2Level.SelectedItem.ToString());
signtemp2.CanView = this.View2.SelectedIndex;
signtemp2.CanDownload = this.Download2.SelectedIndex;
tlist.Add(signtemp2);
signtemp3.SignInfo = this.Sign3.Text.ToString();
Employee emp3 = new Employee();
emp3.Name = this.SignPer3.SelectedText;
emp3.Id = Convert.ToInt32(this.SignPer3.SelectedValue.ToString());
Department dep3 = new Department();
dep3.Id = Convert.ToInt32(this.SignDep3.SelectedValue.ToString());
dep3.Name = this.SignDep3.SelectedText;
emp3.Department = dep3;
signtemp3.SignEmployee = emp3;
signtemp3.SignLevel = Convert.ToInt32(this.Sign3Level.SelectedItem.ToString());
signtemp3.CanView = this.View3.SelectedIndex;
signtemp3.CanDownload = this.Download3.SelectedIndex;
tlist.Add(signtemp3);
signtemp4.SignInfo = this.Sign4.Text.ToString();
Employee emp4 = new Employee();
emp4.Name = this.SignPer4.SelectedText;
emp4.Id = Convert.ToInt32(this.SignPer4.SelectedValue.ToString());
Department dep4 = new Department();
dep4.Id = Convert.ToInt32(this.SignDep4.SelectedValue.ToString());
dep4.Name = this.SignDep4.SelectedText;
emp4.Department = dep4;
signtemp4.SignEmployee = emp4;
signtemp4.SignLevel = Convert.ToInt32(this.Sign4Level.SelectedItem.ToString());
signtemp4.CanView = this.View4.SelectedIndex;
signtemp4.CanDownload = this.Download4.SelectedIndex;
tlist.Add(signtemp4);
signtemp5.SignInfo = this.Sign5.Text.ToString();
Employee emp5 = new Employee();
emp5.Name = this.SignPer5.SelectedText;
emp5.Id = Convert.ToInt32(this.SignPer5.SelectedValue.ToString());
Department dep5 = new Department();
dep5.Id = Convert.ToInt32(this.SignDep5.SelectedValue.ToString());
dep5.Name = this.SignDep5.SelectedText;
emp5.Department = dep5;
signtemp5.SignEmployee = emp5;
signtemp5.SignLevel = Convert.ToInt32(this.Sign5Level.SelectedItem.ToString());
signtemp5.CanView = this.View5.SelectedIndex;
signtemp5.CanDownload = this.Download5.SelectedIndex;
tlist.Add(signtemp5);
signtemp6.SignInfo = this.Sign6.Text.ToString();
Employee emp6 = new Employee();
emp6.Name = this.SignPer6.SelectedText;
emp6.Id = Convert.ToInt32(this.SignPer6.SelectedValue.ToString());
Department dep6 = new Department();
dep6.Id = Convert.ToInt32(this.SignDep6.SelectedValue.ToString());
dep6.Name = this.SignDep6.SelectedText;
emp6.Department = dep6;
signtemp6.SignEmployee = emp6;
signtemp6.SignLevel = Convert.ToInt32(this.Sign6Level.SelectedItem.ToString());
signtemp6.CanView = this.View6.SelectedIndex;
signtemp6.CanDownload = this.Download6.SelectedIndex;
tlist.Add(signtemp6);
signtemp7.SignInfo = this.Sign7.Text.ToString();
Employee emp7 = new Employee();
emp7.Name = this.SignPer7.SelectedText;
emp7.Id = Convert.ToInt32(this.SignPer7.SelectedValue.ToString());
Department dep7 = new Department();
dep7.Id = Convert.ToInt32(this.SignDep7.SelectedValue.ToString());
dep7.Name = this.SignDep7.SelectedText;
emp7.Department = dep7;
signtemp7.SignEmployee = emp7;
signtemp7.SignLevel = Convert.ToInt32(this.Sign7Level.SelectedItem.ToString());
signtemp7.CanView = this.View7.SelectedIndex;
signtemp7.CanDownload = this.Download7.SelectedIndex;
tlist.Add(signtemp7);
signtemp8.SignInfo = this.Sign8.Text.ToString();
Employee emp8 = new Employee();
emp8.Name = this.SignPer8.SelectedText;
emp8.Id = Convert.ToInt32(this.SignPer8.SelectedValue.ToString());
Department dep8 = new Department();
dep8.Id = Convert.ToInt32(this.SignDep8.SelectedValue.ToString());
dep8.Name = this.SignDep8.SelectedText;
emp8.Department = dep8;
signtemp8.SignEmployee = emp8;
signtemp8.SignLevel = Convert.ToInt32(this.Sign8Level.SelectedItem.ToString());
signtemp8.CanView = this.View8.SelectedIndex;
signtemp8.CanDownload = this.Download8.SelectedIndex;
tlist.Add(signtemp8);
signtemp9.SignInfo = this.Sign9.Text.ToString();
Employee emp9 = new Employee();
emp9.Name = this.SignPer9.SelectedText;
emp9.Id = Convert.ToInt32(this.SignPer9.SelectedValue.ToString());
Department dep9 = new Department();
dep9.Id = Convert.ToInt32(this.SignDep9.SelectedValue.ToString());
dep9.Name = this.SignDep9.SelectedText;
emp9.Department = dep9;
signtemp9.SignEmployee = emp9;
signtemp9.SignLevel = Convert.ToInt32(this.Sign9Level.SelectedItem.ToString());
signtemp9.CanView = this.View9.SelectedIndex;
signtemp9.CanDownload = this.Download9.SelectedIndex;
tlist.Add(signtemp9);
signtemp10.SignInfo = this.Sign10.Text.ToString();
Employee emp10 = new Employee();
emp10.Name = this.SignPer10.SelectedText;
emp10.Id = Convert.ToInt32(this.SignPer10.SelectedValue.ToString());
Department dep10 = new Department();
dep10.Id = Convert.ToInt32(this.SignDep10.SelectedValue.ToString());
dep10.Name = this.SignDep10.SelectedText;
emp10.Department = dep10;
signtemp10.SignEmployee = emp10;
signtemp10.SignLevel = Convert.ToInt32(this.Sign10Level.SelectedItem.ToString());
signtemp10.CanView = this.View10.SelectedIndex;
signtemp10.CanDownload = this.Download10.SelectedIndex;
tlist.Add(signtemp10);
signtemp11.SignInfo = this.Sign11.Text.ToString();
Employee emp11 = new Employee();
emp11.Name = this.SignPer11.SelectedText;
emp11.Id = Convert.ToInt32(this.SignPer11.SelectedValue.ToString());
Department dep11 = new Department();
dep11.Id = Convert.ToInt32(this.SignDep11.SelectedValue.ToString());
dep11.Name = this.SignDep11.SelectedText;
emp11.Department = dep11;
signtemp11.SignEmployee = emp11;
signtemp11.SignLevel = Convert.ToInt32(this.Sign11Level.SelectedItem.ToString());
signtemp11.CanView = this.View11.SelectedIndex;
signtemp11.CanDownload = this.Download11.SelectedIndex;
tlist.Add(signtemp11);
signtemp12.SignInfo = this.Sign12.Text.ToString();
Employee emp12 = new Employee();
emp12.Name = this.SignPer12.SelectedText;
emp12.Id = Convert.ToInt32(this.SignPer12.SelectedValue.ToString());
Department dep12 = new Department();
dep12.Id = Convert.ToInt32(this.SignDep12.SelectedValue.ToString());
dep12.Name = this.SignDep12.SelectedText;
emp12.Department = dep12;
signtemp12.SignEmployee = emp12;
signtemp12.SignLevel = Convert.ToInt32(this.Sign12Level.SelectedItem.ToString());
signtemp12.CanView = this.View12.SelectedIndex;
signtemp12.CanDownload = this.Download12.SelectedIndex;
tlist.Add(signtemp12);
temp.Type = 21;
temp.SignDatas = tlist;
temp.TempId = Id;
string result = _sc.ModifyContractTemplate(temp);
if (result == Response.MODIFY_CONTRACT_TEMPLATE_SUCCESS.ToString())
{
MessageBox.Show("修改模板成功!", "提示", MessageBoxButtons.OK);
this.DialogResult = DialogResult.OK;
}
else if (result == "服务器连接中断")
{
MessageBox.Show("服务器连接中断,修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
this.Close();
}
/// <summary>
/// 获取到名称为conTempName的模版的信息
/// </summary>
/// <param name="conTempName"></param>
/// <returns></returns>
public static ContractTemplate GetContractTemplate(String conTempName)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
ContractTemplate conTemp = null;
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = GET_CONTRACT_TEMPLATE_ID_STR;
cmd.Parameters.AddWithValue("@Name", conTempName); // 员工编号
MySqlDataReader sqlRead = cmd.ExecuteReader();
cmd.Dispose();
if (sqlRead.Read())
{
conTemp = new ContractTemplate();
conTemp.TempId = int.Parse(sqlRead["id"].ToString());
conTemp.Name = sqlRead["name"].ToString();
// 5个栏目信息
// conTemp.ColumnCount = 5;
List <String> columns = new List <String>();
/*
* columns.Add(sqlRead["column1"].ToString());
* columns.Add(sqlRead["column2"].ToString());
* columns.Add(sqlRead["column3"].ToString());
* columns.Add(sqlRead["column4"].ToString());
* columns.Add(sqlRead["column5"].ToString());
*/
for (int cnt = 1; cnt <= 5; cnt++)
{
String strColumn = "column" + cnt.ToString();
columns.Add(sqlRead[strColumn].ToString());
}
conTemp.ColumnNames = columns;
// 8个签字人信息
// conTemp.SignCount = 8;
List <SignatureTemplate> signatures = new List <SignatureTemplate>();
for (int cnt = 1; cnt <= 8; cnt++)
{
String strSignInfo = "signinfo" + cnt.ToString();
String strSignId = "signid" + cnt.ToString();
String strSignName = "signname" + cnt.ToString();
String strDepartmentId = "department" + cnt.ToString();
String strDepartmentName = "department" + cnt.ToString();
String strCanView = "canview" + cnt.ToString();
String strCanDownload = "candownload" + cnt.ToString();
SignatureTemplate signDatas = new SignatureTemplate();
signDatas.SignInfo = sqlRead[strSignInfo].ToString();
Employee employee = new Employee();
employee.Id = int.Parse(sqlRead[strSignId].ToString());
employee.Name = sqlRead[strSignName].ToString();
Department department = new Department();
department.Id = int.Parse(sqlRead[strDepartmentId].ToString());
department.Name = sqlRead[strDepartmentName].ToString();
employee.Department = department;
signDatas.SignEmployee = employee;
signDatas.CanView = int.Parse(sqlRead[strCanView].ToString());
signDatas.CanDownload = int.Parse(sqlRead[strCanDownload].ToString());
signatures.Add(signDatas);
}
conTemp.SignDatas = signatures;
}
con.Close();
con.Dispose();
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(conTemp);
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.CheckIntegrity() == false)
{
return;
}
Templete temp = new Templete();
SignatureTemplate signtemp1 = new SignatureTemplate();
SignatureTemplate signtemp2 = new SignatureTemplate();
SignatureTemplate signtemp3 = new SignatureTemplate();
SignatureTemplate signtemp4 = new SignatureTemplate();
SignatureTemplate signtemp5 = new SignatureTemplate();
SignatureTemplate signtemp6 = new SignatureTemplate();
SignatureTemplate signtemp7 = new SignatureTemplate();
SignatureTemplate signtemp8 = new SignatureTemplate();
SignatureTemplate signtemp9 = new SignatureTemplate();
SignatureTemplate signtemp10 = new SignatureTemplate();
List <string> list = new List <string>();
List <SignatureTemplate> tlist = new List <SignatureTemplate>();
//原来此处有断点
// 会签单的名称
temp.Name = this.ConTempName.Text.ToString();
temp.Type = Type;
// 添加前5行的会签单基本信息
list.Add(this.Column1.Text.ToString());
list.Add(this.Column2.Text.ToString());
list.Add(this.Column3.Text.ToString());
list.Add(this.Column4.Text.ToString());
list.Add(this.Column5.Text.ToString());
list.Add(this.Column6.Text.ToString());
temp.ColumnNames = list;
/// 添加后10个签字人的信息基本信息
signtemp1.SignInfo = this.Sign1.Text.ToString();
Employee emp1 = new Employee();
emp1.Name = this.SignPer1.SelectedText;
emp1.Id = Convert.ToInt32(this.SignPer1.SelectedValue.ToString());
Department dep1 = new Department();
dep1.Id = Convert.ToInt32(this.SignDep1.SelectedValue.ToString());
dep1.Name = this.SignDep1.SelectedText;
emp1.Department = dep1;
signtemp1.SignEmployee = emp1;
signtemp1.SignLevel = Convert.ToInt32(this.Sign1Level.SelectedItem.ToString());
signtemp1.CanView = this.View1.SelectedIndex;
signtemp1.CanDownload = this.Download1.SelectedIndex;
tlist.Add(signtemp1);
signtemp2.SignInfo = this.Sign2.Text.ToString();
Employee emp2 = new Employee();
emp2.Name = this.SignPer2.SelectedText;
emp2.Id = Convert.ToInt32(this.SignPer2.SelectedValue.ToString());
Department dep2 = new Department();
dep2.Id = Convert.ToInt32(this.SignDep2.SelectedValue.ToString());
dep2.Name = this.SignDep2.SelectedText;
emp2.Department = dep2;
signtemp2.SignEmployee = emp2;
signtemp2.SignLevel = Convert.ToInt32(this.Sign2Level.SelectedItem.ToString());
signtemp2.CanView = this.View2.SelectedIndex;
signtemp2.CanDownload = this.Download2.SelectedIndex;
tlist.Add(signtemp2);
signtemp3.SignInfo = this.Sign3.Text.ToString();
Employee emp3 = new Employee();
emp3.Name = this.SignPer3.SelectedText;
emp3.Id = Convert.ToInt32(this.SignPer3.SelectedValue.ToString());
Department dep3 = new Department();
dep3.Id = Convert.ToInt32(this.SignDep3.SelectedValue.ToString());
dep3.Name = this.SignDep3.SelectedText;
emp3.Department = dep3;
signtemp3.SignEmployee = emp3;
signtemp3.SignLevel = Convert.ToInt32(this.Sign3Level.SelectedItem.ToString());
signtemp3.CanView = this.View3.SelectedIndex;
signtemp3.CanDownload = this.Download3.SelectedIndex;
tlist.Add(signtemp3);
signtemp4.SignInfo = this.Sign4.Text.ToString();
Employee emp4 = new Employee();
emp4.Name = this.SignPer4.SelectedText;
emp4.Id = Convert.ToInt32(this.SignPer4.SelectedValue.ToString());
Department dep4 = new Department();
dep4.Id = Convert.ToInt32(this.SignDep4.SelectedValue.ToString());
dep4.Name = this.SignDep4.SelectedText;
emp4.Department = dep4;
signtemp4.SignEmployee = emp4;
signtemp4.SignLevel = Convert.ToInt32(this.Sign4Level.SelectedItem.ToString());
signtemp4.CanView = this.View4.SelectedIndex;
signtemp4.CanDownload = this.Download4.SelectedIndex;
tlist.Add(signtemp4);
signtemp5.SignInfo = this.Sign5.Text.ToString();
Employee emp5 = new Employee();
emp5.Name = this.SignPer5.SelectedText;
emp5.Id = Convert.ToInt32(this.SignPer5.SelectedValue.ToString());
Department dep5 = new Department();
dep5.Id = Convert.ToInt32(this.SignDep5.SelectedValue.ToString());
dep5.Name = this.SignDep5.SelectedText;
emp5.Department = dep5;
signtemp5.SignEmployee = emp5;
signtemp5.SignLevel = Convert.ToInt32(this.Sign5Level.SelectedItem.ToString());
signtemp5.CanView = this.View5.SelectedIndex;
signtemp5.CanDownload = this.Download5.SelectedIndex;
tlist.Add(signtemp5);
signtemp6.SignInfo = this.Sign6.Text.ToString();
Employee emp6 = new Employee();
emp6.Name = this.SignPer6.SelectedText;
emp6.Id = Convert.ToInt32(this.SignPer6.SelectedValue.ToString());
Department dep6 = new Department();
dep6.Id = Convert.ToInt32(this.SignDep6.SelectedValue.ToString());
dep6.Name = this.SignDep6.SelectedText;
emp6.Department = dep6;
signtemp6.SignEmployee = emp6;
signtemp6.SignLevel = Convert.ToInt32(this.Sign6Level.SelectedItem.ToString());
signtemp6.CanView = this.View6.SelectedIndex;
signtemp6.CanDownload = this.Download6.SelectedIndex;
tlist.Add(signtemp6);
signtemp7.SignInfo = this.Sign7.Text.ToString();
Employee emp7 = new Employee();
emp7.Name = this.SignPer7.SelectedText;
emp7.Id = Convert.ToInt32(this.SignPer7.SelectedValue.ToString());
Department dep7 = new Department();
dep7.Id = Convert.ToInt32(this.SignDep7.SelectedValue.ToString());
dep7.Name = this.SignDep7.SelectedText;
emp7.Department = dep7;
signtemp7.SignEmployee = emp7;
signtemp7.SignLevel = Convert.ToInt32(this.Sign7Level.SelectedItem.ToString());
signtemp7.CanView = this.View7.SelectedIndex;
signtemp7.CanDownload = this.Download7.SelectedIndex;
tlist.Add(signtemp7);
signtemp8.SignInfo = this.Sign8.Text.ToString();
Employee emp8 = new Employee();
emp8.Name = this.SignPer8.SelectedText;
emp8.Id = Convert.ToInt32(this.SignPer8.SelectedValue.ToString());
Department dep8 = new Department();
dep8.Id = Convert.ToInt32(this.SignDep8.SelectedValue.ToString());
dep8.Name = this.SignDep8.SelectedText;
emp8.Department = dep8;
signtemp8.SignEmployee = emp8;
signtemp8.SignLevel = Convert.ToInt32(this.Sign8Level.SelectedItem.ToString());
signtemp8.CanView = this.View8.SelectedIndex;
signtemp8.CanDownload = this.Download8.SelectedIndex;
tlist.Add(signtemp8);
signtemp9.SignInfo = this.Sign9.Text.ToString();
Employee emp9 = new Employee();
emp9.Name = this.SignPer9.SelectedText;
emp9.Id = Convert.ToInt32(this.SignPer9.SelectedValue.ToString());
Department dep9 = new Department();
dep9.Id = Convert.ToInt32(this.SignDep9.SelectedValue.ToString());
dep9.Name = this.SignDep9.SelectedText;
emp9.Department = dep9;
signtemp9.SignEmployee = emp9;
signtemp9.SignLevel = Convert.ToInt32(this.Sign9Level.SelectedItem.ToString());
signtemp9.CanView = this.View9.SelectedIndex;
signtemp9.CanDownload = this.Download9.SelectedIndex;
tlist.Add(signtemp9);
signtemp10.SignInfo = this.Sign10.Text.ToString();
Employee emp10 = new Employee();
emp10.Name = this.SignPer10.SelectedText;
emp10.Id = Convert.ToInt32(this.SignPer10.SelectedValue.ToString());
Department dep10 = new Department();
dep10.Id = Convert.ToInt32(this.SignDep10.SelectedValue.ToString());
dep10.Name = this.SignDep10.SelectedText;
emp10.Department = dep10;
signtemp10.SignEmployee = emp10;
signtemp10.SignLevel = Convert.ToInt32(this.Sign10Level.SelectedItem.ToString());
signtemp10.CanView = this.View10.SelectedIndex;
signtemp10.CanDownload = this.Download10.SelectedIndex;
tlist.Add(signtemp10);
temp.SignDatas = tlist;
//原来此处有断点
string result = _sc.AddConTemplete(temp);
if (result == Response.INSERT_CONTRACT_TEMPLATE_SUCCESS.ToString())
{
MessageBox.Show("添加模板" + this.ConTempName.Text + "成功！");
}
else
{
MessageBox.Show("添加模板失败！");
}
this.Close();
}
//保存模版按钮
private void btn_SaveInsideContemp_Click(object sender, EventArgs e)
{
if (this.CheckIntegrity() == false)
{
return;
}
Templete temp = new Templete();
//签字人信息
SignatureTemplate signtemp1 = new SignatureTemplate();
SignatureTemplate signtemp2 = new SignatureTemplate();
SignatureTemplate signtemp3 = new SignatureTemplate();
SignatureTemplate signtemp4 = new SignatureTemplate();
SignatureTemplate signtemp5 = new SignatureTemplate();
SignatureTemplate signtemp6 = new SignatureTemplate();
SignatureTemplate signtemp7 = new SignatureTemplate();
SignatureTemplate signtemp8 = new SignatureTemplate();
//list用于存储6个栏目的信息
List <string> list = new List <string>();
//tlist用于存储8个签字人的信息
List <SignatureTemplate> tlist = new List <SignatureTemplate>();
// 会签单的名称
temp.Name = this.ConTempName.Text.ToString();
//会签单的类型
temp.Type = Type;
// 添加会签单6个栏目基本信息
list.Add(this.Column1.Text.ToString());
list.Add(this.Column2.Text.ToString());
list.Add(this.Column3.Text.ToString());
list.Add(this.Column4.Text.ToString());
list.Add(this.Column5.Text.ToString());
list.Add(this.Column6.Text.ToString());
//存到Templete_Inside的public List<String> ColumnNames集合中
temp.ColumnNames = list;
/// 添加后8行的签字人的信息基本信息
signtemp1.SignInfo = this.Sign1.Text.ToString();
Employee emp1 = new Employee();
emp1.Name = this.SignPer1.SelectedText;
emp1.Id = Convert.ToInt32(this.SignPer1.SelectedValue.ToString());
Department dep1 = new Department();
dep1.Id = Convert.ToInt32(this.SignDep1.SelectedValue.ToString());
dep1.Name = this.SignDep1.SelectedText;
emp1.Department = dep1;
signtemp1.SignEmployee = emp1;
signtemp1.SignLevel = Convert.ToInt32(this.Sign1Level.SelectedItem.ToString());
signtemp1.CanView = this.View1.SelectedIndex;
signtemp1.CanDownload = this.Download1.SelectedIndex;
tlist.Add(signtemp1);
signtemp2.SignInfo = this.Sign2.Text.ToString();
Employee emp2 = new Employee();
emp2.Name = this.SignPer2.SelectedText;
emp2.Id = Convert.ToInt32(this.SignPer2.SelectedValue.ToString());
Department dep2 = new Department();
dep2.Id = Convert.ToInt32(this.SignDep2.SelectedValue.ToString());
dep2.Name = this.SignDep2.SelectedText;
emp2.Department = dep2;
signtemp2.SignEmployee = emp2;
signtemp2.SignLevel = Convert.ToInt32(this.Sign2Level.SelectedItem.ToString());
signtemp2.CanView = this.View2.SelectedIndex;
signtemp2.CanDownload = this.Download2.SelectedIndex;
tlist.Add(signtemp2);
signtemp3.SignInfo = this.Sign3.Text.ToString();
Employee emp3 = new Employee();
emp3.Name = this.SignPer3.SelectedText;
emp3.Id = Convert.ToInt32(this.SignPer3.SelectedValue.ToString());
Department dep3 = new Department();
dep3.Id = Convert.ToInt32(this.SignDep3.SelectedValue.ToString());
dep3.Name = this.SignDep3.SelectedText;
emp3.Department = dep3;
signtemp3.SignEmployee = emp3;
signtemp3.SignLevel = Convert.ToInt32(this.Sign3Level.SelectedItem.ToString());
signtemp3.CanView = this.View3.SelectedIndex;
signtemp3.CanDownload = this.Download3.SelectedIndex;
tlist.Add(signtemp3);
signtemp4.SignInfo = this.Sign4.Text.ToString();
Employee emp4 = new Employee();
emp4.Name = this.SignPer4.SelectedText;
emp4.Id = Convert.ToInt32(this.SignPer4.SelectedValue.ToString());
Department dep4 = new Department();
dep4.Id = Convert.ToInt32(this.SignDep4.SelectedValue.ToString());
dep4.Name = this.SignDep4.SelectedText;
emp4.Department = dep4;
signtemp4.SignEmployee = emp4;
signtemp4.SignLevel = -1;
signtemp4.CanView = this.View4.SelectedIndex;
signtemp4.CanDownload = this.Download4.SelectedIndex;
tlist.Add(signtemp4);
signtemp5.SignInfo = this.Sign5.Text.ToString();
Employee emp5 = new Employee();
emp5.Name = this.SignPer5.SelectedText;
emp5.Id = Convert.ToInt32(this.SignPer5.SelectedValue.ToString());
Department dep5 = new Department();
dep5.Id = Convert.ToInt32(this.SignDep5.SelectedValue.ToString());
dep5.Name = this.SignDep5.SelectedText;
emp5.Department = dep5;
signtemp5.SignEmployee = emp5;
signtemp5.SignLevel = Convert.ToInt32(this.Sign5Level.SelectedItem.ToString());
signtemp5.CanView = this.View5.SelectedIndex;
signtemp5.CanDownload = this.Download5.SelectedIndex;
tlist.Add(signtemp5);
signtemp6.SignInfo = this.Sign6.Text.ToString();
Employee emp6 = new Employee();
emp6.Name = this.SignPer6.SelectedText;
emp6.Id = Convert.ToInt32(this.SignPer6.SelectedValue.ToString());
Department dep6 = new Department();
dep6.Id = Convert.ToInt32(this.SignDep6.SelectedValue.ToString());
dep6.Name = this.SignDep6.SelectedText;
emp6.Department = dep6;
signtemp6.SignEmployee = emp6;
signtemp6.SignLevel = Convert.ToInt32(this.Sign6Level.SelectedItem.ToString());
signtemp6.CanView = this.View6.SelectedIndex;
signtemp6.CanDownload = this.Download6.SelectedIndex;
tlist.Add(signtemp6);
signtemp7.SignInfo = this.Sign7.Text.ToString();
Employee emp7 = new Employee();
emp7.Name = this.SignPer7.SelectedText;
emp7.Id = Convert.ToInt32(this.SignPer7.SelectedValue.ToString());
Department dep7 = new Department();
dep7.Id = Convert.ToInt32(this.SignDep7.SelectedValue.ToString());
dep7.Name = this.SignDep7.SelectedText;
emp7.Department = dep7;
signtemp7.SignEmployee = emp7;
signtemp7.SignLevel = Convert.ToInt32(this.Sign7Level.SelectedItem.ToString());
signtemp7.CanView = this.View7.SelectedIndex;
signtemp7.CanDownload = this.Download7.SelectedIndex;
tlist.Add(signtemp7);
signtemp8.SignInfo = this.Sign8.Text.ToString();
Employee emp8 = new Employee();
emp8.Name = this.SignPer8.SelectedText;
emp8.Id = Convert.ToInt32(this.SignPer8.SelectedValue.ToString());
Department dep8 = new Department();
dep8.Id = Convert.ToInt32(this.SignDep8.SelectedValue.ToString());
dep8.Name = this.SignDep8.SelectedText;
emp8.Department = dep8;
signtemp8.SignEmployee = emp8;
signtemp8.SignLevel = Convert.ToInt32(this.Sign8Level.SelectedItem.ToString());
signtemp8.CanView = this.View8.SelectedIndex;
signtemp8.CanDownload = this.Download8.SelectedIndex;
tlist.Add(signtemp8);
//将签字人信息存在Templete_Inside的public List<SignatureTemplate> SignDatas集合中
temp.SignDatas = tlist;
//将封装好的信息打包发给Socket传给服务器存入数据库
string result = _sc.AddConTemplete(temp);
if (result == Response.INSERT_CONTRACT_TEMPLATE_SUCCESS.ToString())
{
MessageBox.Show("添加内河模板" + this.ConTempName.Text + "成功！");
}
else
{
MessageBox.Show("添加内河模板失败！");
}
this.Close();
}
