private void toolStripButton2_Click(object sender, EventArgs e)
{
SelectDetails us = new SelectDetails(); //用户控件
this.panelMain.Controls.Clear(); //先清空主面板
us.Dock = DockStyle.Fill; //将用户控件全部填充到主面板上
this.panelMain.Controls.Add(us);
}
private void FrmMian_Load(object sender, EventArgs e)
{
//窗体加载
SelectDetails us = new SelectDetails(); //用户控件
this.panelMain.Controls.Clear(); //先清空主面板
us.Dock = DockStyle.Fill; //将用户控件全部填充到主面板上
this.panelMain.Controls.Add(us);
}
private void btnSave_Click(object sender, EventArgs e)
{
//名称
string name = this.txtName.Text.Trim();
if (name == string.Empty)
{
MessageBox.Show("名称不能为空");
this.txtName.Focus();
return;
}
//单价
string price = this.txtPrice.Text.Trim();
if (price == string.Empty)
{
MessageBox.Show("单价不能为空");
this.txtPrice.Focus();
return;
}
Regex dj = new Regex("^[0-9]{1,8}([.][0-9]{1,5})?$"); //定义正则表达式
if (dj.IsMatch(price) == false) //判断，如果不满足正则表达式(结果为flase)，给出提示
{
MessageBox.Show("单价只能输入整数或小数");
this.txtPrice.Focus();
return;
}
if (Convert.ToDouble(price) <= 0)
{
MessageBox.Show("单价必须大于0");
this.txtPrice.Focus();
return;
}
//数量
string num = this.txtNum.Text.Trim();
if (num == string.Empty)
{
num = "1"; //用户没有输入时，默认为1
}
Regex sz = new Regex("^[0-9]{1,8}([.][0-9]{1,5})?$"); //定义正则表达式
if (sz.IsMatch(num) == false) //判断，如果不满足正则表达式(结果为flase)，给出提示
{
MessageBox.Show("数量只能输入整数或小数");
this.txtNum.Focus();
return;
}
//总计
string sumPrice = this.txtSumPrice.Text.Trim();
if (sumPrice == string.Empty)
{
MessageBox.Show("总计不能为空");
this.txtSumPrice.Focus();
return;
}
Regex zj = new Regex("^[0-9]{1,8}([.][0-9]{1,5})?$"); //定义正则表达式
if (zj.IsMatch(sumPrice) == false) //判断，如果不满足正则表达式(结果为flase)，给出提示
{
MessageBox.Show("总计只能输入整数或小数");
this.txtSumPrice.Focus();
return;
}
if (Convert.ToDouble(sumPrice) < 0)
{
MessageBox.Show("总计不能小于0");
this.txtPrice.Focus();
return;
}
//类型
string type = this.cmbType.Text.Trim();
int typeId = 0;//默认给0,类型为空时，插入0
if (type != string.Empty)
{
typeId = db.GetTypeIdByName(type);
}
//店铺
string store = this.txtStore.Text.Trim();
//地址
string address = this.txtAddress.Text.Trim();
//联系人
string user = this.txtUser.Text.Trim();
//电话
string phone = this.txtPhone.Text.Trim();
//日期
string date = this.dateTimePicker1.Value.ToString();
if (uid != "")
{
if (db.UpdateDetails(name, Convert.ToDouble(price), Convert.ToDouble(num), Convert.ToDouble(sumPrice), typeId, store, address, user, phone, date, Convert.ToInt32(uid)) == true)
{
MessageBox.Show("修改成功！");
////清空
//this.txtName.Text = "";
//this.txtPrice.Text = "";
//this.txtNum.Text = "";
//this.txtSumPrice.Text = "";
//this.txtStore.Text = "";
//this.txtAddress.Text = "";
//this.txtUser.Text = "";
//this.txtPhone.Text = "";
//this.cmbType.Text = "";
//重新加载查询窗体
Common.sd.ShowDetails();
}
else
{
MessageBox.Show("修改失败！");
}
}
else
{
if (db.AddDetails(name, Convert.ToDouble(price), Convert.ToDouble(num), Convert.ToDouble(sumPrice), typeId, store, address, user, phone, date) == true)
{
MessageBox.Show("添加成功！");
////清空
//this.txtName.Text = "";
//this.txtPrice.Text = "";
//this.txtNum.Text = "";
//this.txtSumPrice.Text = "";
//this.txtStore.Text = "";
//this.txtAddress.Text = "";
//this.txtUser.Text = "";
//this.txtPhone.Text = "";
//this.cmbType.Text = "";
//重新加载查询窗体
SelectDetails us = new SelectDetails(); //用户控件
Common.fm.panelMain.Controls.Clear(); //先清空主面板
us.Dock = DockStyle.Fill; //将用户控件全部填充到主面板上
Common.fm.panelMain.Controls.Add(us);
}
else
{
MessageBox.Show("添加失败！");
}
}
}
