//拒绝
private void RefuseConTemp_Click(object sender, EventArgs e)
{
if (this.Reason.Text == "备注：同意时此栏可不填，拒绝时需填写理由" ||
string.IsNullOrEmpty(this.Reason.Text))
{
MessageBox.Show("需填写拒绝理由！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//return;
}
else
{
SignatureDetail sd = new SignatureDetail();
sd.ConId = this.ConTempId.Text;
sd.EmpId = UserHelper.UserInfo.Id;
sd.Remark = this.Reason.Text;
sd.Result = -1;
string result = _sc.SignDetail(sd);
if (result == Response.INSERT_SIGN_DETAIL_SUCCESS.ToString())
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("处理失败，请重新处理！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void AgreeConTemp_Click(object sender, EventArgs e)
{
SignatureDetail sd = new SignatureDetail();
sd.ConId = this.ConTempId.Text;
sd.EmpId = UserHelper.UserInfo.Id;
if (this.Reason.Text == "备注：同意时此栏可不填，拒绝时需填写理由")
{
sd.Remark = "未填";
}
else
{
sd.Remark = this.Reason.Text.Trim();
}
sd.Result = 1;
string result = _sc.SignDetail(sd);
if (result == Response.INSERT_SIGN_DETAIL_SUCCESS.ToString())
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("处理失败，请重新处理！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
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);
}
//同意
private void AgreeConTemp_Click(object sender, EventArgs e)
{
SignatureDetail sd = new SignatureDetail();
sd.ConId = this.ConTempId.Text;
sd.EmpId = UserHelper.UserInfo.Id;
sd.Advice = "0#";
if (UserHelper.UserInfo.Name == signcolumn6)
{
if (this.txtbox_Advice.Text == null)
{
MessageBox.Show("请填写栏目中的主办单位审核意见,不能为空！");
return;
}
else
{
//将主办单位的审核意见写入数据库 1表示有数据 0表示没数据
sd.Advice = "1#" + this.txtbox_Advice.Text;
// MessageBox.Show(sd.Advice);
}
}
if (this.Reason.Text == "备注：同意时此栏可不填，拒绝时需填写理由")
{
sd.Remark = "未填";
}
else
{
sd.Remark = this.Reason.Text.Trim();
}
sd.Result = 1;
//提交个人签字同意信息
string result = _sc.SignDetail(sd);
if (result == Response.INSERT_SIGN_DETAIL_SUCCESS.ToString())
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("处理失败，请重新处理！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 插入签字明细信息
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
///
public static bool InsertSignatureDetail(SignatureDetail detail)
{
bool ifdetailsuccess = false;
bool ifcolumn6success = true;
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlConnection con1 = DBTools.GetMySqlConnection();
MySqlCommand cmd;
MySqlCommand cmd1;
int count = -1; // 受影响行数
int column6 = -1; //栏目6的受影响行数
try
{
//插入dsignatureetail
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("签字明细插入成功");
ifdetailsuccess = true;
}
else
{
Console.WriteLine("签字明细插入失败");
}
//插入hdjcontract 中的column6 主办单位审核意见
//Console.WriteLine(detail.Advice);
string[] Message = Regex.Split(detail.Advice, "#", RegexOptions.IgnoreCase);
//foreach (string item in Message)
//{
// Console.WriteLine(item);
//}
//表示主办单位审核意见有信息 就写入数据库
if (Message[0] == "1")
{
con1.Open();
cmd1 = con1.CreateCommand();
cmd1.CommandText = UPDATE_HDJCONTRACT_COLUMN6_STR;
cmd1.Parameters.AddWithValue("@Advice", Message[1]); // 签字明细
cmd1.Parameters.AddWithValue("@ConId", detail.ConId);
column6 = cmd1.ExecuteNonQuery();
cmd1.Dispose();
con1.Close();
con1.Dispose();
if (column6 == 1) // 插入成功后的受影响行数为1
{
Console.WriteLine("主办单位审核意见插入成功");
//ifcolumn6success = true;
}
else
{
Console.WriteLine("主办单位审核意见插入失败");
ifcolumn6success = false;
}
}
return(ifdetailsuccess && ifcolumn6success);
}
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);
//}
}
}
/// <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);
//}
}
}
