/// <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 { }
}
}
