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); //} } }