/// <summary> /// 用于更新sale00相应产品使用退货的功能 /// </summary> /// <param name="sale_id">销售单号</param> /// <param name="totmoney">总退货额</param> /// <param name="qty">总退货数量</param> /// <returns>bool</returns> public bool UpdateSale00(string sale_id, decimal totmoney, double qty) { bool a = false; DateTime datetime = DateTime.Now; try { string sql = "UPDATE sale00 SET BACK_SALES=" + totmoney + ", BACK_QUAN=" + qty + ", LAST_UPDATE='" + datetime + "' ,STATUS_ID='3',transfer_status='0' WHERE SALE_ID='" + sale_id + "'"; a = base.RunSQL(sql); } catch { string da = datetime.ToString("yyyy-MM-dd HH:mm:ss"); string sql = "UPDATE sale00 SET BACK_SALES=" + totmoney + ", BACK_QUAN=" + qty + ", LAST_UPDATE='" + da + "' ,STATUS_ID='3',transfer_status='0' WHERE SALE_ID='" + sale_id + "'"; a = base.RunSQL(sql); } if (a) { try { ReadIni readIni = new ReadIni("config.ini"); string srvIp = readIni.ReadString("RepastErp", "txtServerIP"); string srvPort = readIni.ReadString("RepastErp", "txtPort"); string srvDBName = readIni.ReadString("RepastErp", "txtIPdataname"); string srvUserName = readIni.ReadString("RepastErp", "txtFTPuser"); string srvPassword = readIni.ReadString("RepastErp", "txtFTPpassword"); string sql = "begin " + "UPDATE sale01 SET transfer_status='0' WHERE SALE_ID='" + sale_id + "';" + "UPDATE sale02 SET transfer_status='0' WHERE SALE_ID='" + sale_id + "';" + "delete from OPENDATASOURCE('SQLOLEDB','Data Source=" + srvIp + "," + srvPort + ";User ID=" + srvUserName + ";Password="******"' )." + srvDBName + ".dbo.sale00 where shop_id='" + Info.shop_id + "' and sale_id='" + sale_id + "';end"; DBSql.SRunSQL(sql); } catch { } } return(a); }
/// <summary> /// 基本分析窗体初始化 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Analyze_Load(object sender, EventArgs e) { ini = new ReadIni(); data3 = new DataOperation(ini.ReadString("filePath")); filepath = ini.ReadString("fielPath"); data2 = new DataOperation(); //获取当前时间 System.DateTime dateTimes = System.DateTime.Now; Time_LS.Text = dateTimes.ToString("yyyy-MM-dd"); button_search_Click(0); }
/// <summary> /// 构造方法 /// </summary> public FrmMain() { InitializeComponent(); this.Width = (Screen.PrimaryScreen.WorkingArea.Width) * 6 / 7; this.Height = (Screen.PrimaryScreen.WorkingArea.Height) * 18 / 19; ReadIni ini = new ReadIni(); string version = ini.ReadString("version"); if (version == "") { version = ini.ReadString("tempversion"); } this.Text = "干部信息管理系统(" + version + "---上报端)"; }
/// <summary> /// 窗体关闭时所进行的操作,程序退出。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UnitForm_FormClosing(object sender, FormClosingEventArgs e) { if (!LoginMain) { ReadIni readIni = new ReadIni(); if (readIni.ReadString("version") == "") { Application.Exit(); } string filePath1 = readIni.ReadString("filePath"); if (filePath1.Equals("") || System.IO.File.Exists(filePath1) == false) { Application.Exit(); } } }
/// <summary> /// 修改密码的确定键 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { ReadIni readIni = new ReadIni(); if (readIni.ReadString("password").Equals(oldPassWord.Text)) { if (newPassWord.Text.Equals(confirm.Text)) { readIni.WriteString("password", newPassWord.Text); MessageBox.Show("密码修改成功!", "提示"); this.Close(); } else { MessageBox.Show("新密码与确认密码不一致!", "提示"); oldPassWord.Text = ""; newPassWord.Text = ""; confirm.Text = ""; } } else { MessageBox.Show("原始密码不正确!", "提示"); oldPassWord.Text = ""; newPassWord.Text = ""; confirm.Text = ""; } }
/// <summary> /// 设置单位类别 /// </summary> private void SetUnitClass() { ReadIni readIni = new ReadIni(); string tempversion = readIni.ReadString("tempversion"); if (tempversion.Equals("")) { tempversion = readIni.ReadString("version"); } DataTable dt = dataOperation.GetOneDataTable_sql("select unitClass from TB_GradeUnitClass where version='" + tempversion + "'"); for (int i = 0; i < dt.Rows.Count; i++) { comboBox_select.Items.Add(dt.Rows[i]["unitClass"].ToString()); } }
/// <summary> /// 构造方法 /// </summary> public FrmSearchForm() { InitializeComponent(); ini = new ReadIni(); version = ini.ReadString("version"); //读取所有单位的信息表 a2 = new DataOperation(Application.StartupPath + "\\DB\\DBHBMSU.db"); }
/// <summary> /// 初始化单位类型 /// </summary> private void SetUnitClass() { DataOperation dataOperation = new DataOperation(Application.StartupPath + "\\DB\\DBHBMSU.db"); ReadIni readIni = new ReadIni(); string tempversion = readIni.ReadString("tempversion"); if (tempversion == "") { tempversion = readIni.ReadString("version"); } DataTable dt = dataOperation.GetOneDataTable_sql("select unitClass from TB_GradeUnitClass where version='" + tempversion + "'"); for (int i = 0; i < dt.Rows.Count; i++) { comboBox_unitKind.Items.Add(dt.Rows[i]["unitClass"].ToString()); } }
/// <summary> /// 根据用户名从服务器的pos_rounds表中获取登录有关的信息 /// </summary> /// <param name="userName">用户名</param> /// <returns>DataSet</returns> public DataSet GetOnlineInfo(string userName) { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@USER_ID", SqlDbType.NVarChar); para[0].Value = userName; ReadIni readIni = new ReadIni("config.ini"); string srvIp = readIni.ReadString("RepastErp", "txtServerIP"); string srvPort = readIni.ReadString("RepastErp", "txtPort"); string srvDBName = readIni.ReadString("RepastErp", "txtIPdataname"); string srvUserName = readIni.ReadString("RepastErp", "txtFTPuser"); string srvPassword = readIni.ReadString("RepastErp", "txtFTPpassword"); string str = " select * from OPENDATASOURCE('SQLOLEDB','Data Source=" + srvIp + "," + srvPort + ";User ID=" + srvUserName + ";Password="******"' )." + srvDBName + ".dbo.POS_ROUNDS where user_id=@USER_ID and exit_date is null"; return(DBSql.SCreateDataSet(str, para)); }
/// <summary> /// 读取info.ini信息 /// </summary> /// <param name="key">关键字</param> /// <returns>关键字对应的值(读取失败返回空字符串)</returns> public string GetIniInfo(string key) { try { return(readIniInfo.ReadString("RepastErp", key)); } catch { return(""); } }
/// <summary> /// 关闭本窗体 /// </summary> public void CloseCurrentWindow() { ReadIni readIni = new ReadIni(); if (System.IO.File.Exists(readIni.ReadString("filePath"))) { if (ci != null) { ci.nowUnit.Text = readIni.ReadString("unitName"); ci.listView.Items.Clear(); ci.insertPanel.Visible = true; } } else { readIni.WriteString("filePath", "");//清空ini文件中的路径信息 Application.Exit(); } this.Close(); }
/// <summary> /// 综合管理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click_Insert(object sender, EventArgs e) { if (controlMain.nowUnit.Text.Equals("")) { MessageBox.Show("请先创建数据文件!", "提示"); return; } ReadIni readIni = new ReadIni(); cp.Visible = false; if (readIni.ReadString("filePath").Equals(Application.StartupPath + "\\DB\\Default.db")) { controlMain.listView.Items.Clear(); } controlMain.Visible = true; controlMain.tabControl1.TabPages[0].Text = "录入管理"; controlMain.reservenamesheet_pB.Visible = true; controlMain.regist_pB.Visible = false; controlMain.talk_pB.Visible = true; controlMain.Meeting_pB.Visible = true; controlMain.All_pB.Visible = true; controlMain.All_pB.BackgroundImage = Properties.Resources.AllPeoplein; controlMain.reservenamesheet_pB.BackgroundImage = Properties.Resources.NameSheet; controlMain.regist_pB.BackgroundImage = Properties.Resources.SituationRegiste; controlMain.talk_pB.BackgroundImage = Properties.Resources.Dialog; //另存为 controlMain.Meeting_pB.BackgroundImage = Properties.Resources.meeting; //关闭 controlMain.reservenamesheet_pB.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Zoom; controlMain.regist_pB.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Zoom; controlMain.talk_pB.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Zoom; controlMain.Meeting_pB.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Zoom; controlMain.allpeople_Lb.Visible = true; controlMain.label_meeting.Visible = true; controlMain.label_talk.Visible = true; controlMain.label_name_sheet.Visible = true; controlMain.label_regist.Visible = false; controlMain.allpeople_Lb.Text = "基本信息采集"; controlMain.label_meeting.Text = "简要情况登记"; controlMain.label_talk.Text = "其他信息采集"; controlMain.label_name_sheet.Text = "考察材料"; controlMain.panelStyle = "insert"; }
/// <summary> /// 窗体加载事件处理,判断用户是否已经选择版本号. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmLogin_Load(object sender, EventArgs e) { if (readIni.ReadString("version") != "" && File.Exists(readIni.ReadString("filepath"))) { this.Text = this.Text + "(" + readIni.ReadString("version") + "---上报端)"; radioButton1.Visible = false; radioButton2.Visible = false; radioButton3.Visible = false; } else { this.Text = this.Text + "(上报端)"; string tempversion = readIni.ReadString("version"); if (tempversion != "") { this.Text = this.Text + "(" + readIni.ReadString("version") + "---上报端)"; radioButton1.Visible = true; radioButton2.Visible = true; radioButton3.Visible = true; switch (tempversion) { case "市(厅)级": radioButton1.Checked = true; break; case "县(处)级": radioButton2.Checked = true; break; case "乡(科)级": radioButton3.Checked = true; break; } } } }
/// <summary> /// 点击创建数据文件的事件的处理,创建数据文件。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_sure_Click(object sender, EventArgs e) { try { ReadIni readini = new ReadIni(); if (!label_showUnit.Text.Equals("") && !label_showUnit.Text.Equals(string.Empty)) { saveFileDialog1.Filter = ".hbs文件|*.hbs"; string newPath = "C:\\HBGB"; if (!Directory.Exists(newPath)) { Directory.CreateDirectory(newPath); } saveFileDialog1.InitialDirectory = newPath; saveFileDialog1.FileName = label_showUnit.Text; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { this.ControlBox = false; button_sure.Enabled = false; button_regist.Enabled = false; comboBox_select.Enabled = false; listView1.Enabled = false; string filepath = saveFileDialog1.FileName.ToString(); Object path = (Object)filepath;//把filePath转换为object的对象 run1(path); readini.WriteString("unitName", label_showUnit.Text); readini.WriteString("unitClass", comboBox_select.Text.ToString()); string s = readini.ReadString("tempversion"); if (s != "") { //记录版本 readini.WriteString("version", s); readini.WriteString("tempversion", ""); } if (!LoginMain) { frmlogin.IsSuccessful = true; } if (System.IO.File.Exists(readini.ReadString("filePath"))) { if (ci != null) { ci.nowUnit.Text = label_showUnit.Text; ci.listView.Items.Clear(); ci.insertPanel.Visible = true; } } else { readini.WriteString("filePath", "");//清空ini文件中的路径信息 Application.Exit(); } this.Close(); } } else { MessageBox.Show("单位选择不能为空", "提示"); } } catch (Exception) { } }
/// <summary> /// 查询读取收银员帐 /// </summary> /// <returns>DataSet</returns> public DataSet Cashier(int select) { #region//查询收银员的总营业额 if (select == 0) { sqlstr = "Select SALE_USER, SUM(TOT_SALES) from SALE00 where SALE_USER ="******" GROUP BY sale_user "; return(base.CreateDataSet(sqlstr)); } #endregion #region//查询收银员的本月营业额 else if (select == 1) { string monthstr0 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-1 0:0:0"; string monthstr1 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day + 1).ToString() + " 0:0:0"; sqlstr = "select SALE_USER ,sum(tot_sales) from sale00 where sale_user='******' and SALE_DATE BETWEEN '" + monthstr0 + "' and '" + monthstr1 + "' GROUP BY sale_user"; return(base.CreateDataSet(sqlstr)); } #endregion #region//查询收营员的本周营业额 else if (select == 2) { string weekstr = ""; int week = Convert.ToInt32(DateTime.Now.DayOfWeek); if (DateTime.Now.Day - week > 0) { weekstr = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day - week).ToString() + " 0:0:0"; } else if (DateTime.Now.Day - week <= 0) { switch (DateTime.Now.Month - 1) { case 1: weekstr = DateTime.Now.Year.ToString() + "-" + "1-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 3: weekstr = DateTime.Now.Year.ToString() + "-" + "3-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 5: weekstr = DateTime.Now.Year.ToString() + "-" + "5-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 7: weekstr = DateTime.Now.Year.ToString() + "-" + "7-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 8: weekstr = DateTime.Now.Year.ToString() + "-" + "8-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 10: weekstr = DateTime.Now.Year.ToString() + "-" + "10-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 4: weekstr = DateTime.Now.Year.ToString() + "-" + "4-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 6: weekstr = DateTime.Now.Year.ToString() + "-" + "6-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 9: weekstr = DateTime.Now.Year.ToString() + "-" + "9-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 11: weekstr = DateTime.Now.Year.ToString() + "-" + "11-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 2: if ((DateTime.Now.Year % 4 == 0 && DateTime.Now.Year % 100 != 0) || DateTime.Now.Year % 400 == 0) { weekstr = DateTime.Now.Year.ToString() + "-" + "2-" + (29 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; } else { weekstr = DateTime.Now.Year.ToString() + "-" + "2-" + (28 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; } default: weekstr = (DateTime.Now.Year - 1).ToString() + "-" + "12-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; } } string weekstr1 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day + 1).ToString() + " 0:0:0"; sqlstr = "select SALE_USER ,sum(tot_sales) from sale00 where sale_user='******' and SALE_DATE BETWEEN '" + weekstr + "' and '" + weekstr1 + "' GROUP BY sale_user"; return(base.CreateDataSet(sqlstr)); } #endregion #region//查询收银员的今日营业额 else { ReadIni readini = new ReadIni(); DateTime dt; try { dt = Convert.ToDateTime(readini.ReadString("RepastErp", "changeWorkTime")); } catch { dt = Convert.ToDateTime(DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " 0:0:0"); } string daystr0 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " " + dt.Hour.ToString() + ":" + dt.Minute.ToString() + ":" + dt.Second.ToString(); // " 0:0:0"; string daystr1 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day + 1).ToString() + " " + dt.Hour.ToString() + ":" + dt.Minute.ToString() + ":" + dt.Second.ToString(); // " 0:0:0"; sqlstr = "select SALE_USER ,sum(tot_sales) from sale00 where sale_user='******' and SALE_DATE BETWEEN '" + daystr0 + "' and '" + daystr1 + "' GROUP BY sale_user"; return(base.CreateDataSet(sqlstr)); } #endregion }
/// <summary> /// 查询本店营业额 /// </summary> /// <returns>DataSet</returns> public DataSet ShopTur(int select) { //后台服务器信息 ReadIni readIni = new ReadIni("config.ini"); string srvIp = readIni.ReadString("RepastErp", "txtServerIP"); string srvPort = readIni.ReadString("RepastErp", "txtPort"); string srvDBName = readIni.ReadString("RepastErp", "txtIPdataname"); string srvUserName = readIni.ReadString("RepastErp", "txtFTPuser"); string srvPassword = readIni.ReadString("RepastErp", "txtFTPpassword"); string str = "OPENDATASOURCE('SQLOLEDB','Data Source=" + srvIp + "," + srvPort + ";User ID=" + srvUserName + ";Password="******"' )." + srvDBName + ".dbo."; //#region//查询本店的总营业额 //if (select == 0) //{ // sqlstr = " Select shop_id, SUM(TOT_SALES) from SALE00 where shop_id = '" + Info.shop_id + "' GROUP BY shop_id"; // return base.CreateDataSet(sqlstr); //} //#endregion #endregion #region//查询本店当月营业额 if (select == 1) { string monthstr0 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-1 0:0:0"; string monthstr1 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day + 1).ToString() + " 0:0:0"; sqlstr = "select shop_id ,sum(tot_sales) from " + str + "sale00 where shop_id='" + Info.shop_id + "' and SALE_DATE BETWEEN '" + monthstr0 + "' and '" + monthstr1 + "' GROUP BY shop_id"; return(base.CreateDataSet(sqlstr)); } #endregion #region //查询本店本周营业额 else if (select == 2) { string weekstr = ""; int week = Convert.ToInt32(DateTime.Now.DayOfWeek); if (DateTime.Now.Day - week > 0) { weekstr = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day - week).ToString() + " 0:0:0"; } else if (DateTime.Now.Day - week <= 0) { switch (DateTime.Now.Month - 1) { case 1: weekstr = DateTime.Now.Year.ToString() + "-" + "1-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 3: weekstr = DateTime.Now.Year.ToString() + "-" + "3-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 5: weekstr = DateTime.Now.Year.ToString() + "-" + "5-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 7: weekstr = DateTime.Now.Year.ToString() + "-" + "7-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 8: weekstr = DateTime.Now.Year.ToString() + "-" + "8-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 10: weekstr = DateTime.Now.Year.ToString() + "-" + "10-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 4: weekstr = DateTime.Now.Year.ToString() + "-" + "4-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 6: weekstr = DateTime.Now.Year.ToString() + "-" + "6-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 9: weekstr = DateTime.Now.Year.ToString() + "-" + "9-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 11: weekstr = DateTime.Now.Year.ToString() + "-" + "11-" + (30 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; case 2: if ((DateTime.Now.Year % 4 == 0 && DateTime.Now.Year % 100 != 0) || DateTime.Now.Year % 400 == 0) { weekstr = DateTime.Now.Year.ToString() + "-" + "2-" + (29 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; } else { weekstr = DateTime.Now.Year.ToString() + "-" + "2-" + (28 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; } default: weekstr = (DateTime.Now.Year - 1).ToString() + "-" + "12-" + (31 + DateTime.Now.Day - week).ToString() + " 0:0:0"; break; } } string weekstr1 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day + 1).ToString() + " 0:0:0"; sqlstr = "select shop_id ,sum(tot_sales) from " + str + " sale00 where shop_id='" + Info.shop_id + "' and SALE_DATE BETWEEN '" + weekstr + "' and '" + weekstr1 + "' GROUP BY shop_id"; return(base.CreateDataSet(sqlstr)); } #endregion #region//查询本店的当日营业额 else { string daystr0 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " 0:0:0"; string daystr1 = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + (DateTime.Now.Day + 1).ToString() + " 0:0:0"; sqlstr = "select shop_id ,sum(tot_sales) from " + str + " sale00 where shop_id='" + Info.shop_id + "' and SALE_DATE BETWEEN '" + daystr0 + "' and '" + daystr1 + "' GROUP BY shop_id"; return(base.CreateDataSet(sqlstr)); } #endregion }
/// <summary> /// 如果满足条件,清空交班点时间 /// </summary> public void ClearTime() { //交班点 int timePoint; //上次上线时间 DateTime preLoginTime; //交班时间 DateTime changeWorkTime; //本次登录时间 DateTime nowLoginTime = DateTime.Now; try { preLoginTime = Convert.ToDateTime(readIni.ReadString("RepastErp", "preLoginTime")); //changeWorkTime = Convert.ToDateTime(readIni.ReadString("RepastErp", "changeWorkTime")); //timePoint = Convert.ToInt32(changeWorkTime.Hour); } catch { return; } //截取空格后的字符串 // string s1 = changeWorkTime.ToString(); //string s2 = s1.Substring(s1.IndexOf(" ") + 1); string s2 = readIni.ReadString("RepastErp", "changeWorkTime"); timePoint = Convert.ToInt32(s2.Substring(0, 2)); if (timePoint >= 0 && timePoint <= 6) { //截取空格前的字符串 string s3 = nowLoginTime.ToString(); string s4 = s3.Substring(0, s3.IndexOf(" ")); string s = s2 + " " + s4; //若交班时间是凌晨以后,则交班时间的年月日跟当前时间相同 changeWorkTime = Convert.ToDateTime(s); } else { //截取空格前的字符串 string s3 = preLoginTime.ToString(); string s4 = s3.Substring(0, s3.IndexOf(" ")); string s = s2 + " " + s4; //若交班时间是凌晨以前,则交班时间的年月日跟上次登录时间相同 changeWorkTime = Convert.ToDateTime(s); } //如第二次上线时间大于交班时间 if (DateTime.Compare(nowLoginTime, changeWorkTime) >= 0 && DateTime.Compare(changeWorkTime, preLoginTime) >= 0) { //清空配置文件config.ini中的班次 readIni.WriteString("RepastErp", "workNumber", "0"); //清空Info.ini配置文件中的交易号 ReadIni readIni1 = new ReadIni("Info.ini"); readIni1.WriteString("RepastErp", "deal_number", "1"); ReadIni readIniInfo = new ReadIni("Info.ini"); readIniInfo.WriteString("RepastErp", "isNormalOff", "true"); string oldSaleId = readIniInfo.ReadString("RepastErp", "sale_id"); try { DBSql.SRunSQL("delete saletmp00 where sale_id=" + oldSaleId + ""); DBSql.SRunSQL("delete saletmp01 where sale_id=" + oldSaleId + ""); DBSql.SRunSQL("delete saletmp02 where sale_id=" + oldSaleId + ""); } catch { } } }
/// <summary> /// 构造函数 /// </summary> public FrmLogin() { InitializeComponent(); readIni = new ReadIni(); filePath = readIni.ReadString("filePath"); }
/// <summary> /// 确定按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string str = "select * from employee where emp_id =" + Info.emp_id; DataSet ds = DBSql.SCreateDataSet(str); if (ds != null && ds.Tables[0].Rows.Count > 0) { string md5PassDB = ds.Tables[0].Rows[0]["PASSWORD"].ToString(); string oldmd5PassInput = InfoToMD5(oldPassWord.Text); string newMD5Pass = InfoToMD5(newPassWord.Text); if (md5PassDB.Equals(oldmd5PassInput)) { if (newPassWord.Text.Equals(confirm.Text)) { if (newPassWord.Text.Trim() == "") { MessageBox.Show("密码不可为空", "消息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //往服务器中插入交班信息 ReadIni readIni = new ReadIni("config.ini"); string srvIp = readIni.ReadString("RepastErp", "txtServerIP"); string srvPort = readIni.ReadString("RepastErp", "txtPort"); string srvDBName = readIni.ReadString("RepastErp", "txtIPdataname"); string srvUserName = readIni.ReadString("RepastErp", "txtFTPuser"); string srvPassword = readIni.ReadString("RepastErp", "txtFTPpassword"); string sql = "update OPENDATASOURCE('SQLOLEDB','Data Source=" + srvIp + "," + srvPort + ";User ID=" + srvUserName + ";Password="******"' )." + srvDBName + ".dbo.employee set PASSWORD='******' where emp_id=" + Info.emp_id; string sql2 = "update employee set PASSWORD='******' where emp_id=" + Info.emp_id; bool b = DBSql.SRunSQL(sql2); b = DBSql.SRunSQL(sql); if (b) { MessageBox.Show("密码修改成功!"); } else { MessageBox.Show("密码修改失败!"); } oldPassWord.Text = ""; newPassWord.Text = ""; confirm.Text = ""; this.Dispose(); } else { MessageBox.Show("新密码与确认密码不一致!"); oldPassWord.Text = ""; newPassWord.Text = ""; confirm.Text = ""; } } else { MessageBox.Show("原始密码不正确!"); oldPassWord.Text = ""; newPassWord.Text = ""; confirm.Text = ""; } } else { MessageBox.Show("该用户不存在!"); } }