public FormCashBookMenu()
{
InitializeComponent();
objConn.CreateSqliteDBFile(); // 创建数据库文件
objConn.ConnectionToSqliteDB(); // 连接数据库
sql_getUID = string.Format("select uid from t_users where acc='{0}'", frm.GetAccount());
objConn.SelectDataFromSqlite(sql_getUID, UID, 1);
TableCashBookInfo = string.Format("t_cashbook_info_{0}", UID[0]);
sql_create_t_cashbook_info = string.Format("CREATE TABLE {0} (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,UID INTEGER NOT NULL,DateTime TEXT(20) NOT NULL,TallyType TEXT(50) NOT NULL,BudgetType TEXT(50) NOT NULL,Amount INTEGER NOT NULL,InOutProject TEXT(50) NOT NULL,Income DOUBLE NOT NULL DEFAULT 0.00,PayOut DOUBLE NOT NULL DEFAULT 0.00,Total DOUBLE NOT NULL DEFAULT 0.00,PayMode TEXT(20) NOT NULL,RecordUser TEXT(20) NOT NULL,Remark TEXT)", TableCashBookInfo);
// 建用户数据表t_cashbook_info
objConn.CreateTableToSqlite(TableCashBookInfo, sql_create_t_cashbook_info);
SetWindowsFormTitle(); // 设置窗体标题
// 将用书设置的皮肤保存至配置文件中
string skinName = CashBookConfig.GetAppConfig("Skin");
if (string.IsNullOrEmpty(skinName))
{
CashBookConfig.UpdateAppConfig("Skin", "DefaultSkin");
}
SetStyles();
}
private void AddNewBillRecord()
{
string strDateTime = dateTimePicker_AddDate.Text; // 入账时间
string strTallyType = skinTextBox_Type.Text; // 账单类型
string strBudgetType = skinComboBox_BudgetType.Text; // 收支类型
string strInOutProject = skinComboBox_InOutProject.Text; // 收支项目
string strPayMode = comboBox_PayMode.Text; // 支付方式
string strIncome = skinTextBox_Income.Text; // 收入金额
string strPayOut = skinTextBox_PayOut.Text; // 支出金额
string strAmount = skinTextBox_Amount.Text; // 数量
string strRecordUser = skinTextBox_RecordUser.Text; // 记账人
string strRemark = skinTextBox_Remark.Text; // 备注
if (string.IsNullOrEmpty(strTallyType))
{
MessageBox.Show("亲，账单类型不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strBudgetType))
{
MessageBox.Show("亲，收支类型不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strAmount))
{
MessageBox.Show("亲，数量不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strInOutProject))
{
MessageBox.Show("亲，收支项目不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strIncome))
{
MessageBox.Show("亲，收入金额不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strPayOut))
{
MessageBox.Show("亲，支出金额不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strPayMode))
{
MessageBox.Show("亲，支付方式不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strRecordUser))
{
MessageBox.Show("亲，记账人不能为空！", "警示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strRemark))
{
strRemark = "常规记账";
}
string TableCashBookInfo = FormCashBookMenu.TableCashBookInfo;
string TableUsers = "t_users";
string sql_insert_t_cashbook_info = string.Format("INSERT INTO {0}(UID,DateTime,TallyType,BudgetType,Amount,InOutProject,Income,PayOut,Total,PayMode,RecordUser,Remark) SELECT UID,'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}' FROM {12} WHERE ACC='{13}'", TableCashBookInfo, strDateTime, strTallyType, strBudgetType, strAmount, strInOutProject, strIncome, strPayOut, skinTextBox_Total.Text, strPayMode, strRecordUser, strRemark, TableUsers, frmLogin.GetAccount());
conn.ExecuteSql(sql_insert_t_cashbook_info);
MessageBox.Show("添加成功！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
private void Btn_ModifyOK_Click(object sender, EventArgs e)
{
MyMd5 md5 = new MyMd5();
string strModPasswd1 = md5.Md5Encrypt(textBox_ModPasswd1.Text);
string strModPasswd2 = md5.Md5Encrypt(textBox_ModPasswd2.Text);
if (string.IsNullOrEmpty(strModPasswd1))
{
MessageBox.Show("亲，新密码不能为空哈！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (strModPasswd1.Length < 6)
{
MessageBox.Show("亲，新密码不能少于6位！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (string.IsNullOrEmpty(strModPasswd2))
{
MessageBox.Show("亲，确认密码不能为空！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (strModPasswd2.Length < 6)
{
MessageBox.Show("亲，确认密码不能少于6位！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (!string.Equals(strModPasswd1, strModPasswd2))
{
MessageBox.Show("亲，两次输入的密码不一致！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
const string TableUsers = "t_users";
string sql_update_t_users = string.Format("UPDATE {0} SET PWD='{1}' WHERE ACC='{2}'", TableUsers, strModPasswd1, frm.GetAccount());
sqlOper.ExecuteSql(sql_update_t_users);
MessageBox.Show("恭喜！密码修改成功", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
