private void CheckPower()
{
if (!ClsBLL.IsPower(button1.Text))
{
button1.Enabled = false;
}
if (!ClsBLL.IsPower(button2.Text))
{
button2.Enabled = false;
}
if (!ClsBLL.IsPower("删除预约"))
{
除预约ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("取消预约"))
{
取消预约ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("预约转正式"))
{
转为正式预约ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("更改预约时间"))
{
更改预约时间ToolStripMenuItem.Visible = false;
}
}
private void frmCarStateBoad_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
labDateTime.Text = DateTime.Today.ToString("yyyy年MM月dd日");
ClsBLL.IniCombox(comboBox1, "中断原因");
dataGridView1.Rows.Add((dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / dataGridView1.RowTemplate.Height);
string sqlstring = "Select Items from SysDictionary where ItemName='SA'";
DataTable Dt2 = SQLDbHelper.Query(sqlstring).Tables[0];
cmbReceiver.Items.Add("--全部--");
foreach (DataRow dr in Dt2.Rows)
{
cmbReceiver.Items.Add(dr[0].ToString());
}
ShowGrid(string.Empty);
//dataGridView1.BackgroundColor = Color.PaleTurquoise;
dataGridView1.ClearSelection();
int Interval = int.Parse(ClsBLL.GetSet("txtSet5"));
timer1.Interval = Interval * 1000 * 60;
timer1.Enabled = true;
if (!ClsBLL.IsPower(btnToday.Text))
{
btnToday.Enabled = false;
}
if (!ClsBLL.IsPower(btnMonth.Text))
{
btnMonth.Enabled = false;
}
pn0.Left = (dataGridView1.Columns[0].Width - pn0.Width) / 2;
pn1.Left = (dataGridView1.Columns[1].Width - pn1.Width) / 2 + dataGridView1.Columns[0].Width * 1;
pn2.Left = (dataGridView1.Columns[2].Width - pn2.Width) / 2 + dataGridView1.Columns[0].Width * 2;
pn3.Left = (dataGridView1.Columns[3].Width - pn3.Width) / 2 + dataGridView1.Columns[0].Width * 3;
pn4.Left = (dataGridView1.Columns[4].Width - pn4.Width) / 2 + dataGridView1.Columns[0].Width * 4;
pn0.Controls.Add(pic0Down);
pic0Down.Top = pic0Up.Top;
if (!ClsBLL.IsPower("追加项目"))
{
追加项目ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("返修"))
{
返修ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("修改状态"))
{
修改状态ToolStripMenuItem.Visible = false;
}
}
private void CheckPower()
{
if (!ClsBLL.IsPower(btnWork.Text))
{
btnWork.Enabled = false;
}
if (!ClsBLL.IsPower(btnCarState.Text))
{
btnCarState.Enabled = false;
}
}
private void bt_DoubleClick(object sender, EventArgs e)
{
if (!ClsBLL.IsPower("查看维修信息"))
{
MessageBox.Show("你没有权限查看维修信息！");
return;
}
DoubleClickButton bt = (DoubleClickButton)((Control)sender);
frmBookLook fbn = new frmBookLook(int.Parse(bt.Name));
fbn.ShowDialog();
}
private void wbt_DoubleClick(object sender, EventArgs e)
{
if (!ClsBLL.IsPower("分单"))
{
return;
}
DoubleClickButton bt = (DoubleClickButton)((Control)sender);
frmServiceItem fsi = new frmServiceItem(int.Parse(bt.Name));
if (fsi.ShowDialog() == DialogResult.OK)
{
刷新ToolStripMenuItem_Click(null, null);
}
}
private void frmReport_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
sqlstring = @"select distinct cast(datepart(yy,EndServiceTime) as nvarchar(50)) + '年'+ cast(datepart(MM,EndServiceTime) as nvarchar(50)) + '月' as 年月 from Booking
where EndServiceTime is not null order by 年月 desc";
CmbDt = SQLDbHelper.Query(sqlstring).Tables[0];
foreach (Control ct in this.panel2.Controls)
{
if (ct.Name.StartsWith("btnRt"))
{
if (!ClsBLL.IsPower(ct.Text))
{
ct.Enabled = false;
}
}
}
if (!ClsBLL.IsPower("工单明细"))
{
btnQuery.Enabled = false;
button10.Enabled = false;
button20.Enabled = false;
button21.Enabled = false;
button22.Enabled = false;
button23.Enabled = false;
}
if (!ClsBLL.IsPower("异常单查询"))
{
button20.Enabled = false;
}
if (!ClsBLL.IsPower("修改状态"))
{
button21.Enabled = false;
}
if (!ClsBLL.IsPower("操作日志"))
{
button22.Enabled = false;
}
if (!ClsBLL.IsPower("删除工单"))
{
button23.Enabled = false;
}
}
//双击新增预约
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (!ClsBLL.IsPower("新增预约"))
{
MessageBox.Show("你没有权限新增预约！");
return;
}
Colindex = e.ColumnIndex;
Rowindex = e.RowIndex;
if (e.RowIndex < 1)
{
return;
}
DateTime Date1 = DateTime.Parse(label1.Text);
DateTime Date2;
string cellval = dataGridView1.Rows[Rowindex].Cells[0].Value.ToString();
//if (Rowindex == dataGridView1.Rows.Count)
//{
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval).AddMinutes(30);
//}
//else
//{
// if (dataGridView1.Rows[Rowindex - 1].Cells[0].Value.ToString() == cellval)
// {
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval).AddMinutes(30);
// }
// else
// {
Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval);
// }
//}
if (Date2.CompareTo(DateTime.Now) > 0)
{
frmBookNew fm3 = new frmBookNew(Date2, dataGridView1.Columns[e.ColumnIndex].HeaderText);
fm3.AddCarHandle += new frmBookNew.AddCar(AddCarCard);
fm3.UpdateCardHoursdHandle += new frmBookNew.UpdateCardHours(SumWorkHours);
fm3.Show();
}
else
{
MessageBox.Show("选择的预约时间不能小于当前时间！");
}
}
//双击新增预约
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 1 || e.ColumnIndex == 0)
{
return;
}
if (!ClsBLL.IsPower("新增预约"))
{
MessageBox.Show("你没有权限新增预约！");
return;
}
Colindex = e.ColumnIndex;
Rowindex = e.RowIndex;
if (e.RowIndex < 1)
{
return;
}
DateTime Date1 = DateTime.Parse(labDateTime.Text);
DateTime Date2;
string cellval = dataGridView1.Rows[Rowindex].Cells[0].Value.ToString();
Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval);
if (!ClsBLL.CheckFormIsOpen("frmBookNew"))
{
string servicetype = "机电维修";
if (Colindex == 2)
{
servicetype = "车身维修";
}
frmBookNew fm3 = new frmBookNew(Date2, servicetype);
fm3.AddCarHandle += new frmBookNew.AddCar(AddCarCardNew);
if (fm3.ShowDialog() == DialogResult.OK)
{
刷新ToolStripMenuItem_Click(null, null);
}
}
else
{
Form frm = Application.OpenForms["frmBookNew"];
frm.Focus();
}
}
private void CheckPower()
{
if (!ClsBLL.IsPower(btnBooking.Text))
{
btnBooking.Enabled = false;
}
if (!ClsBLL.IsPower(btnCarStae.Text))
{
btnCarStae.Enabled = false;
}
if (!ClsBLL.IsPower(btnClearCar.Text))
{
btnClearCar.Enabled = false;
洗车ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower(btnComplete.Text))
{
btnComplete.Enabled = false;
完工ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower(btnPause.Text))
{
btnPause.Enabled = false;
中断ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower(btnDelay.Text))
{
btnDelay.Enabled = false;
延时ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("分单"))
{
分单ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("返修"))
{
返修ToolStripMenuItem.Visible = false;
}
}
private void frmSysSet_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
LoadTree();
LoadGridView1();
if (!ClsBLL.IsPower("用户管理"))
{
btnUserSet.Enabled = false;
}
if (!ClsBLL.IsPower("词典定义"))
{
btnSysDictionary.Enabled = false;
}
if (!ClsBLL.IsPower("参数设置"))
{
btnSet.Enabled = false;
}
if (!ClsBLL.IsPower("新增用户"))
{
btnSaveUser.Enabled = false;
}
if (!ClsBLL.IsPower("删除用户"))
{
除用户ToolStripMenuItem.Enabled = false;
}
if (!ClsBLL.IsPower("新增工人"))
{
btnNewWorker.Enabled = false;
}
if (!ClsBLL.IsPower("工作排班"))
{
btnWorkerSche.Enabled = false;
dataGridView1.ReadOnly = true;
}
}
private void frmWorkerSit_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
for (int i = 1; i < 32; i++)
{
DataGridViewTextBoxColumn dgcbc = new DataGridViewTextBoxColumn();
dgcbc.HeaderText = i.ToString() + "日";
dgcbc.Tag = i;
dgcbc.SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns.Add(dgcbc);
}
string sqlstring = "Select WorkerName,WorkerCode from Worker";
try
{
DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0];
dataGridView1.Rows.Add(Dt.Rows.Count);
for (int i = 0; i < Dt.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = Dt.Rows[i]["WorkerName"].ToString();
dataGridView1.Rows[i].Cells[0].Tag = Dt.Rows[i]["WorkerCode"].ToString();
dataGridView1.Rows[i].Height = (dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / Dt.Rows.Count;
}
nUDMonth.Value = DateTime.Today.Month;
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
}
if (!ClsBLL.IsPower("新增工人"))
{
btnMonth.Enabled = false;
}
}
private void timer1_Tick(object sender, EventArgs e)
{
timer1.Enabled = false;
frmLogin fl = new frmLogin();
fl.Left = button1.Left + panel1.Left;
fl.Width = button4.Left + button4.Width - button1.Left;
fl.Height = button5.Top + button5.Height - button1.Top;
fl.Top = button1.Top + panel1.Top;
if (fl.ShowDialog() == DialogResult.Cancel)
{
this.Close();
}
foreach (Control ct in panel1.Controls)
{
if (ct.Name.StartsWith("but"))
{
if (!ClsBLL.IsPower(ct.Text))
{
ct.Enabled = false;
}
}
}
}
private void bt_MouseUp(object sender, MouseEventArgs e)
{
if (!ClsBLL.IsPower("更改预约时间"))
{
MessageBox.Show("你没有权限更改预约时间！");
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
if (((Control)sender).Tag.ToString() != "预约" && ((Control)sender).Tag.ToString() != "失约")
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
if (IsMove)
{
decimal top = decimal.Parse(Convert.ToString(((Control)sender).Top - dataGridView1.ColumnHeadersHeight));
decimal height = decimal.Parse(dataGridView1.Rows[0].Height.ToString());
Rowindex = int.Parse(decimal.Round(top / height, 0).ToString());
if (Rowindex == -1)
{
Rowindex = 0;
}
((Control)sender).Top = Rowindex * dataGridView1.Rows[0].Height + dataGridView1.ColumnHeadersHeight;
try
{
if (Rowindex > -1)
{
//拖动完成之后更改数据库
int cols = 0;
string servicetype = string.Empty;
if (((Control)sender).Left >= dataGridView1.Columns[0].Width + dataGridView1.Columns[1].Width)
{
cols = 2;
servicetype = "车身维修";
((Control)sender).Left = dataGridView1.Columns[0].Width + dataGridView1.Columns[1].Width + Cards[Rowindex, cols] * ((Control)sender).Width;
}
else
{
cols = 1;
servicetype = "机电维修";
((Control)sender).Left = dataGridView1.Columns[0].Width + Cards[Rowindex, cols] * ((Control)sender).Width;
}
if (PcStartCol == cols && PcStartRow == Rowindex) //如果移动有效
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
}
else
{
DateTime Date1 = DateTime.Parse(labDateTime.Text);
DateTime Date2;
string cellval = dataGridView1.Rows[Rowindex].Cells[0].Value.ToString();
Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval);
if (Date2.CompareTo(DateTime.Now) < 0) //拖动之后的时间小于当前时间，不能拖动
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
Cards[Rowindex, cols] = Cards[Rowindex, cols] + 1;
Cards[PcStartRow, PcStartCol] = Cards[PcStartRow, PcStartCol] - 1;
if (((Control)sender).Name != string.Empty)
{
int recordid = int.Parse(((Control)sender).Name);
string sqlstring = "Update Booking Set BookTime='" + Date2.ToString() + "', ServiceType='" + servicetype + "',State='预约' where ID=" + recordid; //,DelayBook='延迟预约'
SQLDbHelper.ExecuteSql(sqlstring);
((Control)sender).BackColor = Color.Yellow;
((Control)sender).Tag = "预约";
}
Button bt = (Button)((Control)sender);
ToolTip tt = new ToolTip();
tt.SetToolTip(bt, bt.ImageKey);
}
}
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
}
}
IsMove = false;
}
private void wbt_MouseUp(object sender, MouseEventArgs e)
{
if (!ClsBLL.IsPower("派工"))
{
MessageBox.Show("你没有权限派工！");
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
if (IsMove)
{
decimal top = decimal.Parse(Convert.ToString(((Control)sender).Top - dataGridView1.ColumnHeadersHeight));
decimal height = decimal.Parse(dataGridView1.Rows[0].Height.ToString());
Rowindex = int.Parse(decimal.Round(top / height, 0).ToString());
int left = ((Control)sender).Left;
int startleft = dataGridView1.Columns[0].Width + dataGridView1.Columns[1].Width;
Colindex = (left - startleft) / dataGridView1.Columns[2].Width;
Colindex = Colindex + 2;
if (top == 0 || left < dataGridView1.Columns[0].Width)
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
if (Rowindex == -1)
{
Rowindex = 0;
}
((Control)sender).Top = Rowindex * dataGridView1.Rows[0].Height + dataGridView1.ColumnHeadersHeight;
((Control)sender).Left = (Colindex - 2) * dataGridView1.Columns[2].Width + startleft;
try
{
if (Rowindex > -1)
{
if (((Control)sender).Name != string.Empty)
{
string sqlstring = string.Empty;
DoubleClickButton bt = (DoubleClickButton)((Control)sender);
//记录ID
int recordid = int.Parse(bt.Name);
string[] strinfo = bt.ImageKey.Split(new Char[] { ',' });
if (strinfo[1] == "延时到明天")
{
//延时到明天的单，第二天派工时确认追加工时，预计完成时间是当前时间加上追加工时
if (ClsBLL.GetFendanNum(recordid) > 1)
{ //如果有两张同时延时到明天的单，则进入分单界面。
frmServiceItem fsi = new frmServiceItem(recordid);
if (fsi.ShowDialog() == DialogResult.OK)
{
刷新ToolStripMenuItem_Click(null, null);
}
else
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
}
else
{
frmAddHour2Day frmaddhour = new frmAddHour2Day(recordid);
if (frmaddhour.ShowDialog() == DialogResult.OK)
{
ClsBLL.AddMsg(recordid, "车牌号码:" + strinfo[2] + ",派工给" + ClsBLL.GetWorker(recordid));
刷新ToolStripMenuItem_Click(null, null);
}
else
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
}
}
else
{
//维修工时
decimal servicehours = ClsBLL.GetServiceHour(recordid);
//维修工人
string serviceworker = dataGridView1.Rows[Rowindex].Cells[1].Value.ToString();
DateTime DtPlanComplete = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60)));
sqlstring = "Update Booking Set AssignTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', StartServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',PlanCompleteTime='" + DtPlanComplete + "', Worker='" + serviceworker + "',State='维修进行中' where ID=" + recordid;
if (SQLDbHelper.ExecuteSql(sqlstring) > 0)
{
ClsBLL.AddMsg(recordid, "车牌号码:" + strinfo[2] + ",派工给" + serviceworker);
ClsBLL.ServicePauseStart(recordid);
刷新ToolStripMenuItem_Click(null, null);
}
}
}
}
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
}
}
IsMove = false;
}
private void bt_MouseUp(object sender, MouseEventArgs e)
{
if (!ClsBLL.IsPower("更改预约时间"))
{
MessageBox.Show("你没有权限更改预约时间！");
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
if (((Control)sender).Tag.ToString() != "预约" && ((Control)sender).Tag.ToString() != "失约")
{
//MessageBox.Show("改预约状态为“" + ((Control)sender).Tag.ToString() + "”,不能移动。");
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
return;
}
if (IsMove)
{
//decimal top = decimal.Parse(Convert.ToString(((Control)sender).Top - PcStartTop));
//decimal height = decimal.Parse(dataGridView1.Rows[0].Height.ToString());
//Rowindex += int.Parse(decimal.Round(top / height, 0).ToString());
decimal top = decimal.Parse(Convert.ToString(((Control)sender).Top - dataGridView1.ColumnHeadersHeight));
decimal height = decimal.Parse(dataGridView1.Rows[0].Height.ToString());
Rowindex = int.Parse(decimal.Round(top / height, 0).ToString());
if (top == 0)//Math.Abs(top - height) <(height * 3/4) ||
{
return;
}
if (Rowindex == -1)
{
Rowindex = 0;
}
((Control)sender).Top = Rowindex * dataGridView1.Rows[0].Height + dataGridView1.ColumnHeadersHeight;
try
{
if (Rowindex > 0)
{
//拖动完成之后更改数据库
int cols = (((Control)sender).Left - dataGridView1.Columns[0].Width) / dataGridView1.Columns[1].Width + 1;
DateTime Date1 = DateTime.Parse(label1.Text);
DateTime Date2;
string cellval = dataGridView1.Rows[Rowindex].Cells[0].Value.ToString();
Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval);
//if (Rowindex == dataGridView1.Rows.Count)
//{
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval).AddMinutes(30);
//}
//else
//{
// if (dataGridView1.Rows[Rowindex + 1].Cells[0].Value.ToString() == cellval)
// {
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval);
// }
// else
// {
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval).AddMinutes(30);
// }
//}
if (Date2.CompareTo(DateTime.Now) < 0) //拖动之后的时间小于当前时间，不能拖动
{
((Control)sender).Top = PcStartTop;
((Control)sender).Left = PcStartLeft;
}
string servicetype = dataGridView1.Columns[cols].HeaderText;
if (((Control)sender).Name != string.Empty)
{
int recordid = int.Parse(((Control)sender).Name);
string sqlstring = "Update Booking Set BookTime='" + Date2.ToString() + "', ServiceType='" + servicetype + "',State='预约',DelayBook='延迟预约' where ID=" + recordid;
SQLDbHelper.ExecuteSql(sqlstring);
((Control)sender).BackColor = Color.Yellow;
((Control)sender).Tag = "预约";
}
Button bt = (Button)((Control)sender);
ToolTip tt = new ToolTip();
tt.SetToolTip(bt, bt.ImageKey);
}
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
}
}
IsMove = false;
}
