private void okBtn_Click(object sender, EventArgs e)
{
mode.shop = shopTxt.Text;
mode.phone = phoneTxt.Text;
mode.money = moneyTxt.Text;
mode.time = DateTime.Parse(timeTxt.Text);
mode.mark = markTxt.Text;
if (act == "新增")
{
if (YctOrm.insertYctMode(mode) == 1)
{
Const.info = "添加成功！ " + Const.info;
}
else
{
Const.info = "添加失败!" + Const.info;
}
}
else
{
if (YctOrm.updateYctMode(mode) == 1)
{
Const.info = "修改成功！ " + Const.info;
}
else
{
Const.info = "修改失败!" + Const.info;
}
}
this.Close();
this.Dispose();
}
private void searchBtn_Click(object sender, EventArgs e)
{
string sql = "select [id] as 编号,[shop] as 商户,[phone] as 电话,[money] as 金额,[time] as 时间, [mark] as 备注 from yct ";
if (startTimeTxt.Text != "" || endTimeTxt.Text != "")
{
sql += " where ";
if (startTimeTxt.Text != "")
{
sql += " [time] > #" + startTimeTxt.Text + "#";
if (endTimeTxt.Text != "")
{
sql += " and [time] < #" + endTimeTxt.Text + "#";
}
}
else if (endTimeTxt.Text != "")
{
sql += " [time] < #" + endTimeTxt.Text + "#";
}
}
DataTable dt = YctOrm.getDataTable(sql);
dataGridView.DataSource = dt;
showStatus(Const.info);
}
public static bool logIn(string usr, string pwd)
{
usr = usr.Replace("'", "__").Replace("◇", "'");
pwd = pwd.Replace("'", "__").Replace("◇", "'");
string sql = "select * from log where [user] = '" + usr + "' and [pwd] = '" + pwd + "'";
logOk = false;
if (YctOrm.getRsCount(sql) > 0)
{
logOk = true;
}
return(logOk);
}
public static void updatePwd(string usr, string pwd)
{
usr = usr.Replace("'", "__").Replace("◇", "'");
pwd = pwd.Replace("'", "__").Replace("◇", "'");
string sql = "update log set [pwd] = '" + pwd + "', [time] = #" + DateTime.Now.ToString() + "# where [user] = '" + usr + "'";
if (YctOrm.exeSql(sql) > 0)
{
Const.info = "修改密码成功";
}
else
{
Const.info = "修改密码失败";
}
}
public static void insertPwd(string usr, string pwd)
{
usr = usr.Replace("'", "__").Replace("◇", "'");
pwd = pwd.Replace("'", "__").Replace("◇", "'");
string sql = "insert into log([user], [pwd], [time]) values('" + usr + "','" + pwd + "',#" + DateTime.Now.ToString() + "#)";
if (YctOrm.exeSql(sql) > 0)
{
Const.info = "新增用户成功";
}
else
{
Const.info = "新增用户失败";
}
}
private void delToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("删除后不可恢复，确定删除？", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
YctMode mode = getModeFromNowRow();
if (mode == null)
{
MessageBox.Show("请选中一行进行删除操作。");
return;
}
string sql = "delete * from yct where id = " + mode.id;
YctOrm.exeSql(sql);
showStatus(Const.info);
}
}
