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; }