/// <summary> /// 下线界面中确定按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btndone_Click(object sender, EventArgs e) { isExitType = true; Info.exit_date = DateTime.Now; //下线更新pos_rounds表(本地) if (InsertPos_rounds.InitController().Update_Posrounds(Info.exit_date)) { //创建一个线程用于打印下线小票 Thread thread = new Thread(new ThreadStart(Run)); thread.Start(); //删除提单前的空的销售单 ChangeInfo changeinfo = new ChangeInfo(); changeinfo.DelSaletmp00(Info.sale_id); ReadIni readIni = new ReadIni(); readIni.WriteString("RepastErp", "sale_id", ""); //删除本地临时表中符合要求的数据 DelLocalDB dellocaldb = new DelLocalDB(this.mainForm); dellocaldb.DelSaletmp(); this.Dispose(); } //else //{ // MessageBox.Show("下线失败!请在本Pos机上下线。"); //} }
/// <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> public void SetMaxDeal_number() { string str = "select * from sale00 order by sale_id desc"; DataSet ds = base.CreateDataSet(str); string str2 = "select * from saletmp00 order by sale_id desc"; DataSet ds2 = base.CreateDataSet(str2); ReadIni readIni = new ReadIni("Info.ini"); if (ds != null && ds.Tables[0].Rows.Count > 0) { string s = ds.Tables[0].Rows[0]["sale_id"].ToString(); int num = Convert.ToInt32(s.Substring(s.Length - 4, 4)); if (ds2 != null && ds2.Tables[0].Rows.Count > 0) { string s2 = ds2.Tables[0].Rows[0]["sale_id"].ToString(); int num2 = Convert.ToInt32(s2.Substring(s2.Length - 4, 4)); if (num2 > num) { Info.deal_number = num2; readIni.WriteString("RepastErp", "deal_number", num2.ToString()); } else { Info.deal_number = num; readIni.WriteString("RepastErp", "deal_number", num.ToString()); } } else { Info.deal_number = num; readIni.WriteString("RepastErp", "deal_number", num.ToString()); } } }
/// <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> public FrmSearchForm() { InitializeComponent(); ini = new ReadIni(); version = ini.ReadString("version"); //读取所有单位的信息表 a2 = new DataOperation(Application.StartupPath + "\\DB\\DBHBMSU.db"); }
private void ResetConfig_Click(object sender, RoutedEventArgs e) { var iniFile = "BotConfig.ini"; File.Delete(iniFile); WriteIni.WriteConfig(); ReadIni.ReadFile(); UpdateUI(); }
/// <summary> /// 主窗体加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void MainForm_Load(object sender, EventArgs e) { this.Visible = false; ReadIni readIni = new ReadIni(); CreateDB(); Info.printPort = operPara1.GetIniConfig("printPort"); Info.cusShowPort = operPara1.GetIniConfig("cusShowPort"); Info.showPort = operPara1.GetIniConfig("showPort"); Info.ICPort = operPara1.GetIniConfig("ICPort"); #region 生成连接字符串 string localIp = this.operPara1.LocalIp; if (localIp == "") { string strHostName = Dns.GetHostName(); //得到本机的主机名 localIp = Dns.GetHostEntry(strHostName).AddressList[0].ToString(); //取得本机IP } //创建带实例名的连接 Info.Constr = "server=" + localIp + @"\" + this.operPara1.LocalCase + "," + this.operPara1.LocalPort + ";" + "database=" + this.operPara1.LocalDBName + ";" + "uid=" + this.operPara1.LocalUserName + ";pwd=" + "'" + this.operPara1.LocalPassword + "'"; #endregion try { Info.insertSingleProd = new InsertSingleProd(); Info.getProduct = new GetProduct0(); login = new Login(); login.MainForm = this; login.ShowDialog(); this.functionPanel.LoadBtnInfo(Info.emp_id, "", true); if (recoverSucess) { //加载商品类别信息 this.btnPanelKind.LoadInfo(0, true); this.Visible = true; this.recoverSucess = false; //若上次处于结账状态,恢复成功时恢复结账前状态 UpdateSales.InitUpdateSales().DelSalesSucess(); this.orderMenu.LoadInfo(); return; } #region 如果本地数据库中的数据达到一定要求则按条件删除一部分 DelLocalDB del = new DelLocalDB(this); del.DelLocalData(); #endregion //加载商品类别信息 this.btnPanelKind.LoadInfo(0, true); this.Visible = true; } catch { } }
/// <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); }
static void Main() { string strErr = ""; if (ReadIni.ReadAll(ref strErr) == false) { MessageBox.Show(strErr); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new frm_Main()); }
/// <summary> /// 按照要求删除本地数据库中的数据 /// </summary> /// <returns>成功删除返回true</returns> public bool DelLocalData() { DataSet ds = DBSql.SCreateDataSet("select * from pos_transfer where transfer_mode='out' or transfer_mode='shift'"); bool b = false; ReadIni readIni = new ReadIni("config.ini"); int day; try { day = Convert.ToInt32(mainForm.OperPara.GetIniConfig("clearDay")); if (day < 1) { day = 7; } } catch { day = 7; } DateTime d = DateTime.Now; string str; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { //SALE01中没有LAST_UPDATE字段且先执行SALE00的删除操作,再执行SALE01的删除操作 if (ds.Tables[0].Rows[i]["transfer_table"].ToString() == "SALE01") { continue; } else {//删除day天前的数据 str = " delete " + ds.Tables[0].Rows[i]["transfer_table"] + " where DATEDIFF(day,LAST_UPDATE,'" + d + "')>" + day; b = DBSql.SRunSQL(str); } } catch { b = false; } } str = " delete SALE01 where sale_id not in (select sale_id from sale00)"; b = DBSql.SRunSQL(str); str = " delete saletmp00 where DATEDIFF(day,LAST_UPDATE,'" + d + "')>" + day; b = DBSql.SRunSQL(str); str = " delete saletmp01 where sale_id not in (select sale_id from saletmp00)"; b = DBSql.SRunSQL(str); str = " delete saletmp02 where DATEDIFF(day,LAST_UPDATE,'" + d + "')>" + day; b = DBSql.SRunSQL(str); return(b); }
private void Startparameter() { RegistryReader regreader = new RegistryReader(); regreader.SetRoot(RegistryReader.RegistryRoots.LocalMaschine); regreader.RegistryPath = "SYSTEM\\ControlSet001\\Services\\Snackboxx Application"; regreader.OpenRegistry(); string value = regreader.GetValue("ImagePath"); _installpath = value.Substring(0, value.LastIndexOf("\\")).Replace("\"", ""); _inipath = _installpath + "\\Config\\option.ini"; _readini = new ReadIni(_inipath); }
/// <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> 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> /// <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> /// 根据用户名从服务器的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> /// 初始化单位类型 /// </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> /// 用于获得销售收银员目前销售金额 /// </summary> /// <returns>decimal</returns> public decimal GetSaleMoney() { ReadIni readini = new ReadIni(); DateTime dt; dt = Info.login_date; //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)-sum(isnull(back_sales,0)) from sale00 where sale_user='******' and SALE_DATE BETWEEN '" + dt + "' and '" + DateTime.Now + "' GROUP BY sale_user"; return(Convert.ToDecimal(CreateDataSet(sqlstr).Tables[0].Rows[0][1])); }
/// <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"; }
private void UpdateUI() { ConsoleLogBox.Text = $"[{DateTime.Now.ToString("h:mm:ss tt")}] Trying to Connect to server..."; Main.LogConsole("Successfully Connected to Server. Enjoy!"); WriteIni.WriteConfig(); ReadIni.ReadFile(); BossBattle.IsChecked = GlobalVariables.attackSettings.Boss; FriendBattle.IsChecked = GlobalVariables.attackSettings.Friend; GuildBattle.IsChecked = GlobalVariables.attackSettings.Guild; BraveBattle.IsChecked = GlobalVariables.attackSettings.Brave; DoSBattle.IsChecked = GlobalVariables.attackSettings.DoS; ExpeditionBattle.IsChecked = GlobalVariables.attackSettings.Expedition; PlanetTrialBattle.IsChecked = GlobalVariables.attackSettings.PlanetTrial; PlanetTrialRetry.Text = GlobalVariables.attackSettings.PlanetTrialRetryAmount.ToString(); PlanetTrialAutoRetry.IsChecked = GlobalVariables.attackSettings.PlanetTrialAutoRetry; BraveMaxTickets.Text = GlobalVariables.attackSettings.BraveMaxTickets.ToString(); BraveMaxCE.Text = GlobalVariables.attackSettings.BraveMaxCE.ToString(); BraveAttackMore.IsChecked = GlobalVariables.attackSettings.BraveAutoRetry; GuildMax.Text = GlobalVariables.attackSettings.GuildRetryAmount.ToString(); FriendRetry.Text = GlobalVariables.attackSettings.FriendRetryAmount.ToString(); FriendMax.IsChecked = GlobalVariables.attackSettings.FriendMaxOnly; Alchemy.IsChecked = GlobalVariables.dailySettings.Alchemy; SendHearts.IsChecked = GlobalVariables.dailySettings.SendHearts; SpinWheel.IsChecked = GlobalVariables.dailySettings.SpinWheel; CompleteTavern.IsChecked = GlobalVariables.dailySettings.DailyTavern; CombineEquip.IsChecked = GlobalVariables.dailySettings.CombineEquip; PerformCommon.IsChecked = GlobalVariables.dailySettings.CommonSummon; PerformGrand.IsChecked = GlobalVariables.dailySettings.GrandSummon; CompleteBrave.IsChecked = GlobalVariables.dailySettings.DailyBrave; SendFriend.IsChecked = GlobalVariables.dailySettings.DailyBrave; AcceptFriends.IsChecked = GlobalVariables.dailySettings.DailyBrave; DeclineFriends.IsChecked = GlobalVariables.dailySettings.DailyBrave; if (AcceptFriends.IsChecked == true && DeclineFriends.IsChecked == true) { AcceptFriends.IsChecked = false; } //DailyBag.IsChecked = GlobalVariables.dailySettings.DailyBrave; PurchaseDoS.IsChecked = GlobalVariables.dailySettings.DailyBrave; DeleteMail.IsChecked = GlobalVariables.dailySettings.DailyBrave; }
private void Snackboxx_Load(object sender, EventArgs e) { _iniObj = new IniObj(); _userrights = new List <UserRight>(); _wrini = new WriteIni(); try { FileInfo fi = new FileInfo(IniFilePath); if (!fi.Exists) { fi.Create(); } else { _ini = new ReadIni(IniFilePath); _iniObj = _ini.GetIni(); } logfilename = DateTime.Now.Year + "" + DateTime.Now.Month + "" + DateTime.Now.Day; _iniObj.LogFilename = logfilename; if (string.IsNullOrEmpty(_iniObj.ScanLogPath)) { _iniObj.ScanLogPath = Environment.CurrentDirectory + "\\ScanLog\\"; } Config = new Config(_iniObj, this, _dbConn); _dbConn = Config.DBConn; tssinfoFOUR.Text = _dbConn.GetState.ToString(); //after correct connection... _input = new Input(_iniObj, this, _dbConn, _userrights); this.ShowControl(_input); new UnknownCodeSchemaUpdater(_dbConn, _input.WriteInfoLog); } catch (Exception exp) { MessageBox.Show(exp.Message); userToolStripMenuItem.Enabled = false; inputToolStripMenuItem.Enabled = false; } }
/// <summary> /// 确定按钮点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btndone_Click(object sender, EventArgs e) { try { Info.cashier_sum = Convert.ToDecimal(cashier_sum.Text); } catch { Info.cashier_sum = 0; } Info.remain_sum = Info.cashier_sum; readIni = new ReadIni("Info.ini"); readIni.WriteString("RepastErp", "cashier_sum", Convert.ToString(Info.cashier_sum)); readIni.WriteString("RepastErp", "remain_sum", Convert.ToString(Info.remain_sum)); //上线时往pos_rounds表中插入相关数据 InsertPos_rounds insertPos_rounds = InsertPos_rounds.InitController(); insertPos_rounds.InsertPosrounds(Info.shop_id, Info.pos_id, Info.login_date, Info.cashier_sum, Info.emp_id, "0", Info.shift_num, DateTime.Now); this.Visible = false; }
/// <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="path"></param> private void run1(Object path)//子线程运行的方法 { ReadIni readIni = new ReadIni(); UnitOperation unitOperation = new UnitOperation(); //在指定位置创建DB文件 string filepath = path.ToString(); DataOperation dataOperation = new DataOperation(filepath); dataOperation.CreatDB(filepath); readIni.WriteString("filepath", filepath); //在系统创建的TB_LocalUnit表中插入单位(在上报端这个表中只有一条记录,在上报端它存储本系统所在单位和导入的单位) DataOperation dataOperation1 = new DataOperation(Application.StartupPath + "\\DB\\DBHBMSU.db"); DataTable dt = dataOperation1.GetOneDataTable_sql("select * from TB_Unit where unitName='" + label_showUnit.Text + "'and unitClass='" + comboBox_select.Text.ToString() + "'"); //目的是:提取注册时间 //获取所创建的数据文件的路径。 unitOperation.Filepath = filepath; //向数据文件中插入单位信息。 unitOperation.insterNewUnit(dt.Rows[0]["unitName"].ToString(), dt.Rows[0]["registTime"].ToString(), dt.Rows[0]["unitClass"].ToString()); MessageBox.Show("创建成功!", "提示"); }
/// <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 FrmLogin() { InitializeComponent(); readIni = new ReadIni(); filePath = readIni.ReadString("filePath"); }
public Config(string configFileName, List <string> last_ok_hosts) { ReadIni ini = new ReadIni(configFileName, true); TcpListen = (int)ini["TcpListen"].IntValue; SmtpServerName = ini["SmtpServerName"].StrValue; SmtpPort = (int)ini["SmtpPort"].IntValue; if (SmtpPort == 0) { SmtpPort = 25; } SmtpNumTry = (int)ini["SmtpNumTry"].IntValue; if (SmtpNumTry == 0) { SmtpNumTry = 1; } SmtpUsername = ini["SmtpUsername"].StrValue; SmtpPassword = ini["SmtpPassword"].StrValue; SmtpServerName2 = ini["SmtpServerName2"].StrValue; SmtpPort2 = (int)ini["SmtpPort2"].IntValue; if (SmtpPort2 == 0) { SmtpPort2 = 25; } SmtpNumTry2 = (int)ini["SmtpNumTry2"].IntValue; if (SmtpNumTry2 == 0) { SmtpNumTry2 = 1; } SmtpUsername2 = ini["SmtpUsername2"].StrValue; SmtpPassword2 = ini["SmtpPassword2"].StrValue; SmtpFrom = ini["SmtpFrom"].StrValue; SmtpFromAlive = ini["SmtpFromAlive"].StrValue; SubjectPrefix = ini["SubjectPrefix"].StrValue; DnsServer = ini["DnsServer"].StrValue; string s = ini["SmtpTo"].StrValue; SmtpToList = new StrToken(s).Tokens; SaveLog = ini["SaveLog"].BoolValue; SendAliveMessage = ini["SendAliveMessage"].BoolValue; TcpSendData = ini["TcpSendData"].BoolValue; Interval = Math.Max(MinInterval, (int)ini["Interval"].IntValue * 1000); Timeout = Math.Max(MinTimeout, (int)ini["Timeout"].IntValue * 1000); NumErrors = Math.Max(1, (int)ini["NumErrors"].IntValue); DefaultOptions = ini["DefaultOptions"].StrValue; Footer = ini["Footer"].StrValue; string[] keys = ini.GetKeys(); List <Target> o = new List <Target>(); List <Target> last_ok = new List <Target>(); List <Target> last_ng = new List <Target>(); foreach (string key in keys) { if (key.StartsWith("Target", StringComparison.CurrentCultureIgnoreCase)) { string str = ini[key].StrValue; Target t = new Target(str); o.Add(t); bool last_ok_flag = false; if (last_ok_hosts != null) { if (last_ok_hosts.Contains(t.HostName)) { last_ok_flag = true; } } if (last_ok_flag == false) { last_ng.Add(t); } else { last_ok.Add(t); } } if (key.StartsWith("SuffixReplace", StringComparison.CurrentCultureIgnoreCase)) { string str = ini[key].StrValue; char[] sps = { ' ', '\t' }; string[] tokens = str.Split(sps, StringSplitOptions.RemoveEmptyEntries); if (tokens.Length == 2) { this.SuffixReplaceList.Add(new KeyValuePair <string, string>(tokens[0], tokens[1])); } } } TargetList = o.ToArray(); TargetListLastOkHost = last_ok.ToArray(); TargetListLastNgHost = last_ng.ToArray(); }
/// <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("该用户不存在!"); } }
/// <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> 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 { } } }