/// <summary>
/// 请求审核或审核（按图纸号）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void requestbtn_Click(object sender, EventArgs e)
{
object pid = this.PIDcomboBox.SelectedItem;
object drawno = this.DRAWINGNOcomboBox.SelectedItem;
string btntext = this.requestbtn.Text.ToString();
switch (btntext)
{
case "请求审核":
if (pid == null || drawno == null)
{
return;
}
else
{
string sql = "select count(*) from projectapprove where PROJECTID = '" + pid.ToString() + "'";
object count = User.GetScalar1(sql, DataAccess.OIDSConnStr);
if (Convert.ToInt16(count) == 0)
{
MessageBox.Show("请与系统数据维护人员联系添加项目审核人！");
return;
}
else
{
AssessorForm asform = new AssessorForm();
asform.pid = this.PIDcomboBox.SelectedItem.ToString();
asform.ShowDialog();
if (asform.DialogResult == DialogResult.OK)
{
string[] person = asform.personstr.Split(new char[] { ',' });
int num = person.Length - 1;
if (num < 0)
{
MessageBox.Show("请与系统维护人员联系添加项目审核人！");
return;
}
string[] assesor = new string[num];
for (int n = 0; n < num; n++)
{
assesor[n] = person[n];
}
char[] flag = new char[num];
flag[0] = 'Y';
for (int m = 1; m < num; m++)
{
flag[m] = 'N';
}
for (int k = 1; k <= num; k++)
{
DBConnection.InsertPipeApproveTab(pid.ToString(), drawno.ToString(), k, assesor[k - 1], 0, flag[k - 1]);
if (k == num)
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.待审, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.待审, pid.ToString(), drawno.ToString());
ClearControls();
MessageBox.Show("等待审核通过");
return;
}
}
}
}
}
break;
case "同意":
if (pid == null || drawno == null)
{
return;
}
else
{
string sql1 = "UPDATE PIPEAPPROVE_TAB SET STATE = 1, APPROVENEEDFLAG = 'N' WHERE INDEX_ID =(SELECT INDEX_ID FROM PIPEAPPROVE_TAB WHERE ASSESOR ='" + User.cur_user + "' AND APPROVENEEDFLAG = 'Y' AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "') AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "'";
User.UpdateCon(sql1, DataAccess.OIDSConnStr);
string sql2 = "UPDATE PIPEAPPROVE_TAB SET APPROVENEEDFLAG = 'Y' WHERE STATE = 0 AND INDEX_ID =((SELECT INDEX_ID FROM PIPEAPPROVE_TAB WHERE ASSESOR ='" + User.cur_user + "' AND APPROVENEEDFLAG = 'N' AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "')+1) AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "' ";
User.UpdateCon(sql2, DataAccess.OIDSConnStr);
DataSet ds = new DataSet();
string sqlcount = "SELECT COUNT(*) FROM PROJECTAPPROVE WHERE PROJECTID = '" + this.PIDcomboBox.SelectedItem + "'";
User.DataBaseConnect(sqlcount, ds);
int countvalue = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
ds.Dispose();
DataSet ds1 = new DataSet();
string sql3 = "SELECT DISTINCT INDEX_ID FROM PIPEAPPROVE_TAB WHERE ASSESOR = '" + User.cur_user + "' AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "' ";
User.DataBaseConnect(sql3, ds1);
if (Convert.ToInt32(ds1.Tables[0].Rows[0][0]) == countvalue)
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.审核通过, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.审核通过, pid.ToString(), drawno.ToString());
ClearControls();
}
else
{
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.待审, pid.ToString(), drawno.ToString());
ClearControls();
}
ds1.Dispose();
}
break;
case "发往生产":
if (pid == null || drawno == null)
{
return;
}
else
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.待分配, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.待分配, pid.ToString(), drawno.ToString());
ClearControls();
}
break;
case "处理":
if (pid == null || drawno == null)
{
return;
}
else
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.处理审核反馈, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.处理审核反馈, pid.ToString(), drawno.ToString());
ClearControls();
}
break;
default:
break;
}
}
/// <summary>
/// ������˻���ˣ���ͼֽ�ţ�
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void requestbtn_Click(object sender, EventArgs e)
{
object pid = this.PIDcomboBox.SelectedItem;
object drawno = this.DRAWINGNOcomboBox.SelectedItem;
string btntext = this.requestbtn.Text.ToString();
switch (btntext)
{
case "�������":
if (pid == null || drawno == null)
{
return;
}
else
{
string sql = "select count(*) from projectapprove where PROJECTID = '" + pid.ToString() + "'";
object count = User.GetScalar1(sql, DataAccess.OIDSConnStr);
if (Convert.ToInt16(count) == 0)
{
MessageBox.Show("����ϵͳ����ά����Ա��ϵ�����Ŀ����ˣ�");
return;
}
else
{
AssessorForm asform = new AssessorForm();
asform.pid = this.PIDcomboBox.SelectedItem.ToString();
asform.ShowDialog();
if (asform.DialogResult == DialogResult.OK)
{
string[] person = asform.personstr.Split(new char[] { ',' });
int num = person.Length - 1;
if (num < 0)
{
MessageBox.Show("����ϵͳά����Ա��ϵ�����Ŀ����ˣ�");
return;
}
string[] assesor = new string[num];
for (int n = 0; n < num; n++)
{
assesor[n] = person[n];
}
char[] flag = new char[num];
flag[0] = 'Y';
for (int m = 1; m < num; m++)
{
flag[m] = 'N';
}
for (int k = 1; k <= num; k++)
{
DBConnection.InsertPipeApproveTab(pid.ToString(), drawno.ToString(), k, assesor[k - 1], 0, flag[k - 1]);
if (k == num)
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.����, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.����, pid.ToString(), drawno.ToString());
ClearControls();
MessageBox.Show("�ȴ����ͨ��");
return;
}
}
}
}
}
break;
case "ͬ��":
if (pid == null || drawno == null)
{
return;
}
else
{
string sql1 = "UPDATE PIPEAPPROVE_TAB SET STATE = 1, APPROVENEEDFLAG = 'N' WHERE INDEX_ID =(SELECT INDEX_ID FROM PIPEAPPROVE_TAB WHERE ASSESOR ='" + User.cur_user + "' AND APPROVENEEDFLAG = 'Y' AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "') AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "'";
User.UpdateCon(sql1, DataAccess.OIDSConnStr);
string sql2 = "UPDATE PIPEAPPROVE_TAB SET APPROVENEEDFLAG = 'Y' WHERE STATE = 0 AND INDEX_ID =((SELECT INDEX_ID FROM PIPEAPPROVE_TAB WHERE ASSESOR ='" + User.cur_user + "' AND APPROVENEEDFLAG = 'N' AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "')+1) AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "' ";
User.UpdateCon(sql2, DataAccess.OIDSConnStr);
DataSet ds = new DataSet();
string sqlcount = "SELECT COUNT(*) FROM PROJECTAPPROVE WHERE PROJECTID = '" + this.PIDcomboBox.SelectedItem + "'";
User.DataBaseConnect(sqlcount, ds);
int countvalue = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
ds.Dispose();
DataSet ds1 = new DataSet();
string sql3 = "SELECT DISTINCT INDEX_ID FROM PIPEAPPROVE_TAB WHERE ASSESOR = '" + User.cur_user + "' AND PROJECTID = '" + this.PIDcomboBox.SelectedItem + "' AND DRAWINGNO = '" + this.DRAWINGNOcomboBox.SelectedItem + "' ";
User.DataBaseConnect(sql3, ds1);
if (Convert.ToInt32(ds1.Tables[0].Rows[0][0]) == countvalue)
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.���ͨ��, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.���ͨ��, pid.ToString(), drawno.ToString());
ClearControls();
}
else
{
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.����, pid.ToString(), drawno.ToString());
ClearControls();
}
ds1.Dispose();
}
break;
case "��������":
if (pid == null || drawno == null)
{
return;
}
else
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.������, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.������, pid.ToString(), drawno.ToString());
ClearControls();
}
break;
case "����":
if (pid == null || drawno == null)
{
return;
}
else
{
DBConnection.UpdateSpoolTabWithDrawingNo((int)FlowState.������˷���, pid.ToString(), drawno.ToString());
DBConnection.InsertApproveIntoFlowLog(User.cur_user, (int)FlowState.������˷���, pid.ToString(), drawno.ToString());
ClearControls();
}
break;
default:
break;
}
}
