/// <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;
}
// keyi
//public static HDJContract ViewHDJContract(String contractId)
//{
// DALHDJContract.GetHDJContactRefuse(contractId);
//}
public static HDJContract GetHDJContactRefuse(String contractId)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
HDJContract contract = new HDJContract();
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = GET_HDJCONTRACT_REFUSE_STR;
cmd.Parameters.AddWithValue("@Id", contractId);
MySqlDataReader sqlRead = cmd.ExecuteReader();
cmd.Dispose();
while (sqlRead.Read())
{
contract.Id = sqlRead["id"].ToString();
contract.Name = sqlRead["name"].ToString();
ContractTemplate conTemp = new ContractTemplate();
conTemp.TempId = int.Parse(sqlRead["contempid"].ToString());
conTemp.Name = sqlRead["contempname"].ToString();
// 5个栏目信息
// conTemp.ColumnCount = 5;
List<String> columnnames = new List<String>();
List<String> columndatas = new List<String>();
for (int cnt = 1; cnt <= 5; cnt++)
{
String strColumnname = "columnname" + cnt.ToString();
String strColumnData = "columndata" + cnt.ToString();
columnnames.Add(sqlRead[strColumnname].ToString());
columndatas.Add(sqlRead[strColumnData].ToString());
}
conTemp.ColumnNames = columnnames;
contract.ColumnDatas = columndatas;
// 8个签字人信息
// conTemp.SignCount = 8;
List<SignatureTemplate> signatures = new List<SignatureTemplate>();
List<int> signResults = new List<int>();
List<String > signRemarks = new List<String>();
for (int cnt = 1; cnt <= 8; cnt++)
{
String strSignInfo = "signinfo" + cnt.ToString();
String strSignId = "signid" + cnt.ToString();
String strSignName = "signname" + cnt.ToString();
String strDepartmentId = "departmentid" + cnt.ToString();
String strDepartmentName = "departmentname" + cnt.ToString();
String strSignLevel = "signlevel" + cnt.ToString();
String strCanView = "canview" + cnt.ToString();
String strCanDownload = "candownload" + cnt.ToString();
String strSignResult = "result" + cnt.ToString();
String strSignRemark = "remark" + cnt.ToString();
SignatureTemplate signDatas = new SignatureTemplate();
signDatas.SignInfo = sqlRead[strSignInfo].ToString();
signDatas.SignLevel = int.Parse(sqlRead[strSignLevel].ToString());
signDatas.CanView = int.Parse(sqlRead[strCanView].ToString());
signDatas.CanDownload = int.Parse(sqlRead[strCanDownload].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;
// 8个人的签字结果
signResults.Add(int.Parse(sqlRead[strSignResult].ToString()));
signRemarks.Add(sqlRead[strSignRemark].ToString());
signatures.Add(signDatas);
}
conTemp.SignDatas = signatures;
contract.ConTemp = conTemp;
contract.SignResults = signResults;
contract.SignRemarks = signRemarks;
}
con.Close();
con.Dispose();
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return contract;
}
