void getValue(FishEntity.ReviewEntity model)
{
model.programId = this.programId;
model.Numbering = model.code = this.oddNum;
model.content = richOpinion.Text;
model.createMan = model.modifyMan = FishEntity.Variable.User.username;
model.userName = FishEntity.Variable.User.username;
model.SingleNumber = Number;
if (rabExamine.Checked == true)
{
model.state = rabExamine.Text;
}
//else if (rabReview.Checked == true)
// model.state = rabReview.Text;
//else if (rabReject.Checked == true)
// model.state = rabReject.Text;
else if (radioAdopt.Checked == true)
{
model.state = radioAdopt.Text;
}
else if (radioInform.Checked == true)
{
model.state = radioInform.Text;
}
}
public FishEntity.ReviewEntity UserName(string Numbering)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select b.userName from t_salesorder a inner join t_review b on a.Numbering=b.Numbering where programId='FormSalesRContract'and state='提交' ");
strSql.Append("and a.Numbering='" + Numbering + "'");
DataSet ds = MySqlHelper.Query(strSql.ToString());
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
FishEntity.ReviewEntity model = new FishEntity.ReviewEntity(); DataRow row = ds.Tables[0].Rows[0];
if (row != null)
{
if (row["userName"] != null)
{
model.userName = row["userName"].ToString();
}
}
return(model);
}
else
{
return(null);
}
}
public FishEntity.ReviewEntity getM(DataRow row)
{
FishEntity.ReviewEntity model = new FishEntity.ReviewEntity();
if (row != null)
{
if (row["userName"] != null)
{
model.userName = row["userName"].ToString();
}
if (row["realname"] != null)
{
model.realName = row["realName"].ToString();
}
if (row["programId"] != null)
{
model.programId = row["programId"].ToString();
}
if (row["programName"] != null)
{
model.programName = row["programName"].ToString();
}
if (row["code"] != null)
{
model.code = row["code"].ToString();
}
if (row["date"] != null && row["date"].ToString() != "")
{
model.date = DateTime.Parse(row["date"].ToString());
}
if (row["content"] != null)
{
model.content = row["content"].ToString();
}
if (row["state"] != null)
{
model.state = row["state"].ToString();
}
if (row["Numbering"] != null)
{
model.Numbering = row["Numbering"].ToString();
}
}
return(model);
}
private void btnOk_Click(object sender, System.EventArgs e)
{
//if (rabReview.Checked == false && rabReject.Checked == false && rabExamine.Checked == false && radioAdopt.Checked == false && radioInform.Checked == false)
//{
// MessageBox.Show("请选择");
// return;
//}
if (rabExamine.Checked == false && string.IsNullOrEmpty(texReview.Text))
{
MessageBox.Show("请选择送审对象");
return;
}
List <FishEntity.ReviewEntity> modelList = new List <FishEntity.ReviewEntity>();
string[] strUser;
if (texReview.Text.Contains("|"))
{
string[] strSplit = texReview.Text.Split('|');
foreach (string s in strSplit)
{
model = new FishEntity.ReviewEntity();
strUser = s.Trim().Split(' ');
if (strUser.Length >= 2)
{
getValue(model);
model.userNameReview = strUser[0];
modelList.Add(model);
}
}
}
else if (!string.IsNullOrEmpty(texReview.Text))
{
strUser = texReview.Text.Trim().Split(' ');
if (strUser.Length >= 2)
{
model = new FishEntity.ReviewEntity();
getValue(model);
model.userNameReview = strUser[0];
modelList.Add(model);
}
}
else
{
model = new FishEntity.ReviewEntity();
getValue(model);
model.userNameReview = string.Empty;
modelList.Add(model);
}
if (model.state.Equals("撤审") == false)
{
bool result = _bll.Review(modelList);
if (result == true)
{
MessageBox.Show("送审成功");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("送审失败");
}
}
else if (model.state.Equals("撤审") == true)
{
if (_bll.examine_1(model.Numbering, model.programId, Number) == true)
{
MessageBox.Show("撤审成功");
this.DialogResult = DialogResult.OK;
}
else
{
if (_bll.examine(model.Numbering, model.programId) == true)
{
MessageBox.Show("撤审成功");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("撤审失败");
}
}
}
}
void getValue(int i, FishEntity.ProcessStateEntity _list)
{
int idx = dataGridView1.Rows.Add();
DataGridViewRow row = dataGridView1.Rows[idx];
row.Cells["id"].Value = _list.id;
row.Cells["code"].Value = _list.code;
row.Cells["Numbering"].Value = _list.Numbering;
switch (_list.Effect)
{
case "有效": row.Cells["effect"].Value = false; break;
case "无效": row.Cells["effect"].Value = true; break;
default: row.Cells["effect"].Value = false; break;
}
_createmanSet = _createmanGet.createmanGet(_list.Numbering);
if (_createmanSet != null)
{
row.Cells["xssqBool"].Value = _createmanSet.createman.ToString();
row.Cells["demand"].Value = _createmanSet.demand.ToString();
row.Cells["Signdate"].Value = _createmanSet.Signdate.ToString();
row.Cells["Purchasecontractnumber"].Value = _createmanSet.Purchasecontractnumber.ToString();
}
row.Cells["xssqExBool"].Value = string.Empty;
//送审提交Name
_ReviewModel = _Reviewbll.UserName(_list.Numbering);
if (_ReviewModel != null)
{
row.Cells["xshtBool"].Value = _ReviewModel.userName.ToString();
}
row.Cells["xshtExBool"].Value = string.Empty;
row.Cells["fksqBool"].Value = string.Empty;
row.Cells["fksqExBool"].Value = string.Empty;
row.Cells["thdCode"].Value = _list.ThdCode;
row.Cells["thdBool"].Value = string.Empty;
row.Cells["bdCode"].Value = _list.BdCode;
row.Cells["bdBool"].Value = string.Empty;
row.Cells["bdExBool"].Value = string.Empty;
row.Cells["hwfkCode"].Value = _list.HwfkCode;
row.Cells["hwfkBool"].Value = string.Empty;
row.Cells["hwfkExBool"].Value = string.Empty;
row.Cells["wtfkCode"].Value = _list.WtfkCode;
row.Cells["wtfkBool"].Value = string.Empty;
row.Cells["wtfkExBool"].Value = string.Empty;
row.Cells["skjlBool"].Value = string.Empty;
row.Cells["skjlExBool"].Value = string.Empty;
row.Cells["tchsBool"].Value = string.Empty;
row.Cells["tchsExBool"].Value = string.Empty;
if (_list.xssqBool == true)
{
dataGridView1.Rows[i].Cells["xssqBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["xssqBool"].Style.BackColor = Color.FromName("Blue");
}
if (_list.xssqExBool == true)
{
dataGridView1.Rows[i].Cells["xssqExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["xssqExBool"].Style.BackColor = Color.FromName("Blue");
}
if (_list.xshtBool == true)
{
dataGridView1.Rows[i].Cells["xshtBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["xshtBool"].Style.BackColor = Color.FromName("Blue");
}
if (_list.xshtExBool == true)
{
dataGridView1.Rows[i].Cells["xshtExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["xshtExBool"].Style.BackColor = Color.FromName("Blue");
}
switch (_list.fksqBool)
{
case '1': dataGridView1.Rows[i].Cells["fksqBool"].Style.BackColor = Color.FromName("Red"); break;
case '2': dataGridView1.Rows[i].Cells["fksqBool"].Style.BackColor = Color.FromName("yellow"); break;
case '0': dataGridView1.Rows[i].Cells["fksqBool"].Style.BackColor = Color.FromName("Blue"); break;
case '3': dataGridView1.Rows[i].Cells["fksqBool"].Style.BackColor = Color.FromName("green"); break;
default:
/// <summary>
/// null
/// </summary>
dataGridView1.Rows[i].Cells["fksqBool"].Style.BackColor = Color.FromName("Blue");
break;
}
if (_list.fksqExBool == true)
{
dataGridView1.Rows[i].Cells["fksqExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["fksqExBool"].Style.BackColor = Color.FromName("Blue");
}
switch (_list.thdBool)
{
case '1': dataGridView1.Rows[i].Cells["thdBool"].Style.BackColor = Color.FromName("Red"); break;
case '2': dataGridView1.Rows[i].Cells["thdBool"].Style.BackColor = Color.FromName("yellow"); break;
case '0': dataGridView1.Rows[i].Cells["thdBool"].Style.BackColor = Color.FromName("Blue"); break;
default:
/// <summary>
/// null
/// </summary>
dataGridView1.Rows[i].Cells["thdBool"].Style.BackColor = Color.FromName("Blue");
break;
}
switch (_list.bdBool)
{
case '1': dataGridView1.Rows[i].Cells["bdBool"].Style.BackColor = Color.FromName("Red"); break;
case '2': dataGridView1.Rows[i].Cells["bdBool"].Style.BackColor = Color.FromName("yellow"); break;
case '0': dataGridView1.Rows[i].Cells["bdBool"].Style.BackColor = Color.FromName("Blue"); break;
default:
/// <summary>
/// null
/// </summary>
dataGridView1.Rows[i].Cells["bdBool"].Style.BackColor = Color.FromName("Blue");
break;
}
if (_list.bdExBool == true)
{
dataGridView1.Rows[i].Cells["bdExBool"].Style.BackColor = Color.FromName("Red");
dataGridView1.Rows[i].Cells["bdBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["bdExBool"].Style.BackColor = Color.FromName("Blue");
}
switch (_list.hwfkBool)
{
case '1': dataGridView1.Rows[i].Cells["hwfkBool"].Style.BackColor = Color.FromName("Red"); break;
case '2': dataGridView1.Rows[i].Cells["hwfkBool"].Style.BackColor = Color.FromName("yellow"); break;
case '0': dataGridView1.Rows[i].Cells["hwfkBool"].Style.BackColor = Color.FromName("Blue"); break;
default:
/// <summary>
/// null
/// </summary>
dataGridView1.Rows[i].Cells["hwfkBool"].Style.BackColor = Color.FromName("Blue");
break;
}
if (_list.hwfkExBool == true)
{
dataGridView1.Rows[i].Cells["hwfkExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["hwfkExBool"].Style.BackColor = Color.FromName("Blue");
}
switch (_list.wtfkBool)
{
case '1': dataGridView1.Rows[i].Cells["wtfkBool"].Style.BackColor = Color.FromName("Red"); break;
case '2': dataGridView1.Rows[i].Cells["wtfkBool"].Style.BackColor = Color.FromName("yellow"); break;
case '0': dataGridView1.Rows[i].Cells["wtfkBool"].Style.BackColor = Color.FromName("Blue"); break;
default:
/// <summary>
/// null
/// </summary>
dataGridView1.Rows[i].Cells["wtfkBool"].Style.BackColor = Color.FromName("Blue");
break;
}
if (_list.wtfkExBool == true)
{
dataGridView1.Rows[i].Cells["wtfkExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["wtfkExBool"].Style.BackColor = Color.FromName("Blue");
}
switch (_list.skjlBool)
{
case '1': dataGridView1.Rows[i].Cells["skjlBool"].Style.BackColor = Color.FromName("Red"); break;
case '2': dataGridView1.Rows[i].Cells["skjlBool"].Style.BackColor = Color.FromName("yellow"); break;
case '0': dataGridView1.Rows[i].Cells["skjlBool"].Style.BackColor = Color.FromName("Blue"); break;
default:
/// <summary>
/// null
/// </summary>
dataGridView1.Rows[i].Cells["skjlBool"].Style.BackColor = Color.FromName("Blue");
break;
}
if (_list.skjlExBool == true)
{
dataGridView1.Rows[i].Cells["skjlExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["skjlExBool"].Style.BackColor = Color.FromName("Blue");
}
if (_list.tchsBool == true)
{
dataGridView1.Rows[i].Cells["tchsBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["tchsBool"].Style.BackColor = Color.FromName("Blue");
}
if (_list.tchsExBool == true)
{
dataGridView1.Rows[i].Cells["tchsExBool"].Style.BackColor = Color.FromName("Red");
}
else
{
dataGridView1.Rows[i].Cells["tchsExBool"].Style.BackColor = Color.FromName("Blue");
}
}
