public HDJContract(HDJContract contract)
{
this.m_name = contract.m_name;
this.m_submitDate = contract.m_submitDate;
this.m_id = contract.m_id;
this.m_columnDatas = contract.m_columnDatas;
this.m_submitEmployee = contract.m_submitEmployee;
this.m_conTemp = contract.m_conTemp;
this.m_currLevel = contract.m_currLevel;
this.m_maxLevel = contract.m_maxLevel;
this.m_signResults = contract.m_signResults;
this.m_signRemarks = contract.m_signRemarks;
}
public HDJContractWithWorkload(HDJContract contract)
: base(contract)
{
this.WorkLoads = new List <ContractWorkload>();
}
public static List<HDJContract> QueryHDJContract()
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
List<HDJContract> contracts = new List<HDJContract>();
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = QUERY_HDJCONTRACT_STR;
MySqlDataReader sqlRead = cmd.ExecuteReader();
cmd.Dispose();
while (sqlRead.Read())
{
HDJContract contract = new HDJContract();
}
con.Close();
con.Dispose();
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return contracts;
}
public static bool ModifyHDJContract(HDJContract contract)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
int count = -1;
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = MODIFY_HDJCONTRACT_STR;
cmd.Parameters.AddWithValue("@Id", contract.Id);
//cmd.Parameters.AddWithValue("@Name", contract.Name);
//cmd.Parameters.AddWithValue("@TempId", contract.ConTemp.TempId);
//cmd.Parameters.AddWithValue("@SubEmpId", contract.SubmitEmployee.Id);
cmd.Parameters.AddWithValue("@SubmitDate", System.DateTime.Now);
/// 5个栏目信息
for (int cnt = 0; cnt < 5; cnt++)
{
String strColumn = "@ColumnData_" + (cnt + 1).ToString();
cmd.Parameters.AddWithValue(strColumn, contract.ColumnDatas[cnt]);
}
count = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
if (count == 1)
{
Console.WriteLine("修改会签单信息" + contract.Id.ToString() + "成功");
return true;
}
else
{
Console.WriteLine("修改会签单信息" + contract.Id.ToString() + "失败");
return false;
}
}
public static bool InsertHDJContract(HDJContract contract)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
int count = -1; // 受影响行数
// 当天的会签单的数目
int currDayConCount = DALHDJContract.GetDayHDJContractCount(System.DateTime.Now.Date);
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = INSERT_HDJCONTRACT_STR;
/// 修改编号的设置
/// 目前编号设置[前缀串 年4位 + 月2位 + 日2位 + 编号6位]
//////////////////////////////////////////////////////////////////////
// modify by gatieme 2015-07-10 14Label2
/// 修改ID为手动填写
if (contract.Id == "")
{
contract.Id += System.DateTime.Now.ToString("yyyyMMdd") + (currDayConCount + 1).ToString().PadLeft(6, '0');
}
//////////////////////////////////////////////////////////////////////
cmd.Parameters.AddWithValue("@Id", contract.Id);
cmd.Parameters.AddWithValue("@Name", contract.Name);
cmd.Parameters.AddWithValue("@ConTempId", contract.ConTemp.TempId);
cmd.Parameters.AddWithValue("@SubEmpId", contract.SubmitEmployee.Id);
cmd.Parameters.AddWithValue("@SubmitDate", System.DateTime.Now);
/// 5个栏目信息
for (int cnt = 0; cnt < 5; cnt++)
{
String strColumn = "@ColumnData_" + (cnt + 1).ToString();
cmd.Parameters.AddWithValue(strColumn, contract.ColumnDatas[cnt]);
}
count = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
if (count == 1) // 插入成功后的受影响行数为1
{
Console.WriteLine("插入会签单成功");
///////////////////////////////////////////////////////////
// 此处应该判断如果提交人和申请人的第一个人的同一个个人的话，直接同意
// 但是暂时不予考虑，应该自己的确需要签字审核
///////////////////////////////////////////////////////////
return true;
}
else
{
Console.WriteLine("插入会签单失败");
return false;
}
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
// 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;
}
