public static List<SignatureDetail> QuerySignatureDetail(int empId, String conId)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
List<SignatureDetail> details = new List<SignatureDetail>();
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = QUERY_SIGNATURE_DETAIL_EMP_CON_STR;
cmd.Parameters.AddWithValue("@Empid", empId);
cmd.Parameters.AddWithValue("@ConId", conId);
MySqlDataReader sqlRead = cmd.ExecuteReader();
cmd.Dispose();
while (sqlRead.Read())
{
SignatureDetail detail = new SignatureDetail();
//detail.Id = sqlRead["id"].ToString();
detail.Date = sqlRead["date"].ToString();
detail.EmpId = int.Parse(sqlRead["empid"].ToString());
detail.ConId = sqlRead["conid"].ToString();
detail.Result = int.Parse(sqlRead["result"].ToString());
detail.Remark = sqlRead["remark"].ToString();
details.Add(detail);
}
con.Close();
con.Dispose();
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return details;
}
/// <summary>
/// 插入签字明细信息
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
///
public static bool InsertSignatureDetail(SignatureDetail detail)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
int count = -1; // 受影响行数
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = INSERT_SIGNATURE_DETAIL_STR;
//cmd.Parameters.AddWithValue("@Id", System.DateTime.Now.ToString("yyyyMMddHHmmss"));
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now); // 签字明细职位
cmd.Parameters.AddWithValue("@EmpId", detail.EmpId);
cmd.Parameters.AddWithValue("@ConId", detail.ConId);
cmd.Parameters.AddWithValue("@Result", detail.Result);
cmd.Parameters.AddWithValue("@Remark", detail.Remark);
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();
}
// 每次进行签字以后需要判断一下当前阶段是否走完，如果完结则阶段 [计数器 + 1]
DALSignatureDetail.SetSignatureCurrLevelTrigger(detail.ConId);
//// 会签单信息已经完成，直接生成会签单信息
//if (dalsignaturedetail.iscontractagree(detail.conid) == true)
//{
// // 创建后台线程生成会签单信息
// parameterizedthreadstart pts = new parameterizedthreadstart(createhdjcontracttrigger);
// thread thradrecmsg = new thread(pts);
// thradrecmsg.isbackground = true;
// thradrecmsg.start(detail.conid);
//}
}
}
