private void btn_transmit_Click(object sender, EventArgs e)
{
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
if (this.dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True")
{
if (this.dataGridView1.Rows[i].Cells[7].Value.ToString() == "新增" ||
this.dataGridView1.Rows[i].Cells[7].Value.ToString() == "不通过")
{
if (this.usrKind != "业务员")
{
MessageBox.Show("用户权限不够！", "提示");
return;
}
String qStr = "update WeekPlanning set status = '待初审' where ID = '" + this.dataGridView1.Rows[i].Cells["ID"].Value.ToString() + "'";
SQLquery query = new SQLquery(qStr);
if (query.doModify())
{
MessageBox.Show("周计划提交成功！", "提示");
updateDataGridView();
}
else
{
MessageBox.Show("周计划提交失败！", "提示");
}
}
else
{
MessageBox.Show("该周计划不可提交！", "提示");
}
}
}
}
private void btn_transmit_Click(object sender, EventArgs e)
{
if (this.xd)
{
MessageBox.Show("您刚已下达了调度令！", "提示");
return;
}
if (this.txt_zlzt.Text == "" || this.txt_qfr.Text == "" || this.txt_jsrxm.Text == "" || this.cb_jb.Text == "")
{
MessageBox.Show("必填项(带*号)不能为空！", "提示");
return;
}
if (!isNum(this.txt_flrczdh.Text) || !isNum(this.txt_jsrczdh.Text))
{
MessageBox.Show("传真电话格式错误！", "提示");
return;
}
String qStr = "select status from " + knd + "Planning where ID = '" + this.id + "'";
SQLquery query = new SQLquery(qStr);
DataTable dt = query.doSelect();
if (dt != null)
{
if (dt.Rows[0][0].ToString() != "未下达")
{
MessageBox.Show("该计划调度令已下达！", "提示");
return;
}
}
String qStr0 = "insert into TransportSchedule values('" + this.txt_flsj.Text + "','" + this.txt_qfr.Text
+ "','" + this.txt_zlzt.Text + "','" + this.cb_jb.Text + "','" + this.txt_jsrxm.Text + "','" + this.txt_jsrczdh.Text
+ "','" + this.txt_flr.Text + "','" + this.txt_flrczdh.Text + "','" + this.id + "')";
SQLquery query0 = new SQLquery(qStr0);
if (query0.doModify())
{
String qStr1 = "update " + knd + "Planning set status = '已下达', attachment = '" + this.txt_fj.Text + "' where ID = '" + this.id + "'";
SQLquery query1 = new SQLquery(qStr1);
if (query1.doModify())
{
MessageBox.Show("下达调度令成功！", "提示");
this.xd = true;
}
else
{
MessageBox.Show("下达调度令失败！", "提示");
}
}
else
{
MessageBox.Show("下达调度令失败！", "提示");
}
}
private bool deleteSPD()
{
String qStr3 = "delete from Approval where planID = '" + id + "'";
SQLquery query3 = new SQLquery(qStr3);
bool b3 = query3.doModify();
if (b3)
{
return(true);
}
else
{
return(false);
}
}
private bool deleteJHMX()
{
//删除对应计划明细
String qStr1 = "delete from PlanningDetail where planID = '" + id + "'";
SQLquery query1 = new SQLquery(qStr1);
bool b1 = query1.doModify();
if (b1)
{
return(true);
}
else
{
return(false);
}
}
private bool deleteDDL()
{
//删除对应调度令
String qStr2 = "delete from Schedule where planID = '" + id + "'";
SQLquery query2 = new SQLquery(qStr2);
bool b2 = query2.doModify();
if (b2)
{
return(true);
}
else
{
return(false);
}
}
private bool deleteP()
{
//删除计划
String qStr = "delete from " + kind + "Planning where ID = '" + id + "'";
SQLquery query = new SQLquery(qStr);
bool b = query.doModify();
if (b)
{
return(true);
}
else
{
return(false);
}
}
private void btn_r_Click(object sender, EventArgs e)
{
if (this.txt_zh.Text == "" || this.txt_mm.Text == "" || this.txt_qrmm.Text == "" || this.cb_kind.Text == "")
{
MessageBox.Show("账号、密码或用户类型不能为空！", "错误");
return;
}
if (this.txt_mm.Text != this.txt_qrmm.Text)
{
MessageBox.Show("确认密码不一致！", "错误");
this.txt_qrmm.Text = "";
return;
}
String qStr = "select * from Usr where account = '" + this.txt_zh.Text + "'";
SQLquery query = new SQLquery(qStr);
DataTable dt = query.doSelect();
if (dt != null)
{
MessageBox.Show("账号已存在！", "错误");
this.txt_zh.Text = "";
this.txt_mm.Text = "";
this.txt_qrmm.Text = "";
this.cb_kind.SelectedIndex = -1;
return;
}
String qStr1 = "insert into Usr values('" + this.txt_zh.Text + "','" +
this.txt_mm.Text + "','" + this.cb_kind.Text + "')";
SQLquery query1 = new SQLquery(qStr1);
if (query1.doModify())
{
MessageBox.Show("用户注册成功！", "提示");
this.txt_zh.Text = "";
this.txt_mm.Text = "";
this.txt_qrmm.Text = "";
this.cb_kind.SelectedIndex = -1;
this.Close();
}
else
{
MessageBox.Show("用户注册失败！", "提示");
}
}
private void btn_approve_Click(object sender, EventArgs e)
{
if (this.sp)
{
MessageBox.Show("该年计划已被审批过了！", "提示");
return;
}
if (txt_pfyj.Text == "")
{
MessageBox.Show("请填写批复意见", "提示");
return;
}
string decision = "通过";
if (this.rb_no.Checked)
{
decision = "不通过";
}
String qStr = "insert into Approval values('" + this.txt_pfr.Text + "','" + this.txt_pfrq.Text +
"','" + decision + "','" + this.txt_pfyj.Text + "','" + this.id + "')";
SQLquery query = new SQLquery(qStr);
bool b = query.doModify();
String qStr1 = "update " + knd + "Planning set status = '" + decision + "' where ID = '" + this.id + "'";
SQLquery query1 = new SQLquery(qStr1);
bool b1 = query1.doModify();
if (b && b1)
{
MessageBox.Show("审批完成！", "提示");
this.sp = true;
}
else
{
MessageBox.Show("审批失败！", "提示");
}
}
private void btn_transmit_Click(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count < 1 || this.txt_cmp.Text == "" || this.txt_year.Text == "" || this.cb_zs.Text == "")
{
MessageBox.Show("必填项(带*号)不能为空！", "提示");
}
else
{
//判断日期选择是否在范围内
int pdyear = Convert.ToInt16(this.txt_year.Text);
int pdmonth= Convert.ToInt16(this.txt_syue.Text);
if (this.dateTimePicker1.Value.Year != pdyear || this.dateTimePicker1.Value.Month != pdmonth)
{
MessageBox.Show("起始年月不在范围内！", "错误");
return;
}
if (this.dateTimePicker2.Value.Year != pdyear || this.dateTimePicker2.Value.Month != pdmonth)
{
MessageBox.Show("结束年月不在范围内！", "错误");
return;
}
if (this.dateTimePicker1.Value.Day >= this.dateTimePicker2.Value.Day)
{
MessageBox.Show("日期段异常！", "错误");
return;
}
int tag = 0;
string type;
if (this.rb_g.Checked)
{
type = "普通";
}
else
{
type = "追加";
}
double amount = 0;
Guid u = System.Guid.NewGuid();
string id = "Z-" + u;
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
String detail = "";
amount += Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString());
for (int j = 0; j < 5; j++)
{
detail += "'" + this.dataGridView1.Rows[i].Cells[j].Value.ToString() + "',";
}
detail += this.dataGridView1.Rows[i].Cells[5].Value.ToString();
String qStr = "insert into PlanningDetail values(" + detail + ",'" + id + "')";
SQLquery query = new SQLquery(qStr);
if (query.doModify())
{
if (i == this.dataGridView1.Rows.Count - 1)
{
tag += 1;
this.dataGridView1.Rows.Clear();
}
}
}
string statues;
if (kind == "下达")
{
statues = "未下达";
}
else
{
statues = "新增";
}
string sday = this.dateTimePicker1.Value.Day.ToString();
if (this.dateTimePicker1.Value.Day < 10)
{
sday = "0" + sday;
}
string eday = this.dateTimePicker2.Value.Day.ToString();
if (this.dateTimePicker1.Value.Day < 10)
{
eday = "0" + eday;
}
string sj = this.txt_year.Text + this.txt_syue.Text + sday + this.txt_syue.Text + eday;
String qStr1 = "insert into WeekPlanning values('" + id + "','" + this.txt_cmp.Text + "','" + sj
+ "','" + type + "','" + statues + "'," + amount + ",'" + this.txt_cjr.Text + "','" + this.txt_time.Text + "','" + this.txt_bz.Text
+ "','" + this.txt_fj.Text + "','" + this.yid + "',"+ this.cb_zs.Text +")";
SQLquery query1 = new SQLquery(qStr1);
if (query1.doModify())
{
tag += 1;
}
if (tag == 2)
{
MessageBox.Show("录入周计划成功！", "提示");
this.txt_cjr.Text = "系统管理员";
this.txt_bz.Text = "";
this.txt_fj.Text = "";
this.cb_zs.SelectedIndex = -1;
this.hjtxt = 0;
this.txt_hj.Text = "";
this.txt_time.Text = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd hh:mm:ss");
total -= amount;
}
else
{
MessageBox.Show("录入周计划失败！", "提示");
}
}
}
private void btn_transmit_Click(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count < 1 || this.txt_cmp.Text == "" || this.txt_year.Text == "")
{
MessageBox.Show("必填项(带*号)不能为空！", "提示");
}
else
{
if (!yearValid(this.txt_year.Text))
{
MessageBox.Show("输入年份无效！", "错误");
this.txt_year.Text = "";
return;
}
this.txt_year.Text = Itrim(this.txt_year.Text);
int tag = 0;
string type;
if (this.rb_g.Checked)
{
type = "普通";
}
else
{
type = "追加";
}
double amount = 0;
Guid u = System.Guid.NewGuid();
string id = "N-" + u;
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
String detail = "";
amount += Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString());
for (int j = 0; j < 5; j++)
{
detail += "'" + this.dataGridView1.Rows[i].Cells[j].Value.ToString() + "',";
}
detail += this.dataGridView1.Rows[i].Cells[5].Value.ToString();
String qStr = "insert into PlanningDetail values(" + detail + ",'" + id + "')";
SQLquery query = new SQLquery(qStr);
if (query.doModify())
{
if (i == this.dataGridView1.Rows.Count - 1)
{
tag += 1;
this.dataGridView1.Rows.Clear();
}
}
}
string statues;
if (kind == "下达")
{
statues = "未下达";
}
else
{
statues = "新增";
}
string sj = this.txt_year.Text + "01011231";
String qStr1 = "insert into YearPlanning values('" + id + "','" + this.txt_cmp.Text + "','" + sj
+ "','" + type + "','" + statues + "'," + amount + ",'" + this.txt_cjr.Text + "','" + this.txt_time.Text + "','" + this.txt_bz.Text
+ "','" + this.txt_fj.Text + "')";
SQLquery query1 = new SQLquery(qStr1);
if (query1.doModify())
{
tag += 1;
}
if (tag == 2)
{
MessageBox.Show("录入年计划成功！", "提示");
this.txt_cmp.Text = "";
this.txt_year.Text = "";
this.txt_cjr.Text = "系统管理员";
this.txt_bz.Text = "";
this.txt_fj.Text = "";
this.hjtxt = 0;
this.txt_hj.Text = "";
this.txt_time.Text = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd hh:mm:ss");
}
else
{
MessageBox.Show("录入年计划失败！", "提示");
}
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
//判定计划量是否超出
double tmpJHL = 0;
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
tmpJHL += Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString());
}
if (this.kind == "年")
{
if ((totalMin * 10) > (tmpJHL * 10))
{
MessageBox.Show("运输计划量低于其下月计划总量，请修改明细！", "错误");
return;
}
}
else if (this.kind == "月")
{
if ((totalUp * 10) < (tmpJHL * 10))
{
MessageBox.Show("运输计划量高于年计划剩余计划量，请修改明细！", "错误");
return;
}
if ((totalMin * 10) > (tmpJHL * 10))
{
MessageBox.Show("运输计划量低于其下周计划总量，请修改明细！", "错误");
return;
}
}
else if (this.kind == "周")
{
if ((totalUp * 10) < (tmpJHL * 10))
{
MessageBox.Show("计划量不足，请修改明细！", "错误");
return;
}
}
string fjhl = tmpJHL.ToString("0.0");
bool b3 = false;
bool b4 = false;
//修改计划
String qStr1 = "update " + knd + "Planning set amount = " + fjhl + ", creator = '" + this.txt_cjr.Text + "', remark = '" + this.txt_bz.Text
+ "', attachment = '" + this.txt_fj.Text + "' where ID = '" + id + "'";
SQLquery query1 = new SQLquery(qStr1);
bool b1 = query1.doModify();
//删除计划明细
String lid = "";
for (int i = 0; i < ld.Count - 1; i++)
{
lid += ("'" + ld[i] + "' or ID = ");
}
lid += ("'" + ld[ld.Count - 1] + "'");
String qStr2 = "delete from PlanningDetail where ID = " + lid;
SQLquery query2 = new SQLquery(qStr2);
bool b2 = query2.doModify();
//修改计划明细
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
string itid = this.dataGridView1.Rows[i].Cells["_ID"].Value.ToString();
if (lm.Contains(itid))
{
String qStr4 = "update PlanningDetail set forwarding_unit = '" + this.dataGridView1.Rows[i].Cells[0].Value.ToString()
+ "', transportation = '" + this.dataGridView1.Rows[i].Cells[1].Value.ToString() + "', consignee = '" +
this.dataGridView1.Rows[i].Cells[2].Value.ToString() + "', receiptPlace = '" + this.dataGridView1.Rows[i].Cells[3].Value.ToString()
+ "', address = '" + this.dataGridView1.Rows[i].Cells[4].Value.ToString() + "', amount = " +
this.dataGridView1.Rows[i].Cells[5].Value.ToString() + " where ID = '" + itid + "'";
SQLquery query4 = new SQLquery(qStr4);
b4 = query4.doModify();
}
}
//新增计划明细
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
if (this.dataGridView1.Rows[i].Cells["_ID"].Value.ToString() == "")
{
String detail = "";
for (int j = 0; j < 5; j++)
{
detail += "'" + this.dataGridView1.Rows[i].Cells[j].Value + "',";
}
detail += this.dataGridView1.Rows[i].Cells[5].Value;
String qStr3 = "insert into PlanningDetail values(" + detail + ",'" + this.id + "')";
SQLquery query3 = new SQLquery(qStr3);
b3 = query3.doModify();
}
}
if (b1 || b2 || b3 || b4)
{
MessageBox.Show("修改" + kind + "计划成功！", "提示");
}
else if (!b1 && !b2 && !b3 && !b4)
{
MessageBox.Show("未修改" + kind + "计划！", "提示");
}
else
{
MessageBox.Show("修改" + kind + "计划失败！", "提示");
}
}