private void button1_Click(object sender, EventArgs e)
{
if (TbUserName.Text.Trim() == "" || TbPWS.Text.Trim() == "")
{
MessageBox.Show("请正确输入账号和密码");
return;
}
List <SqlParameter> sqlList = new List <SqlParameter>()
{
GuGuGuHelper.CreatePara("@EmployeeID", SqlDbType.Char, ParameterDirection.Input, TbUserName.Text.Trim(), 10),
GuGuGuHelper.CreatePara("@password", SqlDbType.Char, ParameterDirection.Input, TbPWS.Text.Trim(), 16),
GuGuGuHelper.CreatePara("@returnValue", SqlDbType.Int, ParameterDirection.ReturnValue),
};
GuGuGuHelper.ExecuteNonQuery("prcLogin", sqlList, CommandType.StoredProcedure);
int returnValue = Convert.ToInt32(sqlList.ElementAt(2).Value);
if (returnValue == 1)
{
MessageBox.Show("登陆成功!");
GuGuGu fm = new GuGuGu(TbUserName.Text.Trim());
Hide();
fm.ShowDialog();
Close();
}
else
{
MessageBox.Show("登陆失败!");
}
}
private void BtnChangePassWord_Click(object sender, EventArgs e)
{
if (TbxNewPassword.Text.Trim() == "" || TbxPassWord.Text.Trim() == "")
{
MessageBox.Show("密码不能为空！！");
return;
}
if (TbxPassWord.Text.Trim() == TbxNewPassword.Text.Trim())
{
string sql = "Update Login set Password = '******' where EmployeeID = '" + TbxEmployeeID.Text.Trim() + "'";
sql = string.Format(sql, this.TbxNewPassword.Text);
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("修改失败");
}
}
else
{
MessageBox.Show("两次输入的密码不一致，请重新输入");
}
}
private void Delete()
{
if (GuGuGuHelper.IsInDataGridView(selectRow, DGVCategories))
{
string id = DGVCategories.Rows[selectRow].Cells["商品类别编号"].Value.ToString();
{
string sql = "select * from Products where CategoryID = " + id + "'";
if (GuGuGuHelper.ExcuteExist(sql))
{
MessageBox.Show("该类别下含有商品，禁止删除！");
return;
}
}
{
string sql = "delete from Categories where CategoryID = '" + id + "'";
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("删除成功");
}
else
{
MessageBox.Show("删除失败");
}
CateRefresh();
}
}
else
{
MessageBox.Show("请选择正确的行");
}
}
private void Updates()
{
string sql = @"update dbo.Customers set CustomerName='{0}',Address='{1}',Phone='{2}',Credits='{3}',Notes='{4}' where CustomerID='{5}'";
sql = string.Format(sql, TbCustomerID.Text.Trim(), TbCustomerName.Text.Trim(), TbCustomerAddr.Text.Trim(), TbCustomerTel.Text.Trim(), TbCustomerCre.Text.Trim(), TbCustomerNote.Text.Trim());
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
MessageBox.Show((cnt >= 1) ? "修改成功" : "修改失败");
}
private void Insert()
{
string sql = @"INSERT INTO dbo.Customers VALUES( '{0}','{1}','{2}','{3}','{4}','{5}')";
sql = string.Format(sql, TbCustomerID.Text.Trim(), TbCustomerName.Text.Trim(), TbCustomerAddr.Text.Trim(), TbCustomerTel.Text.Trim(), TbCustomerCre.Text.Trim(), TbCustomerNote.Text.Trim());
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
MessageBox.Show((cnt >= 1) ? "添加成功" : "添加失败");
}
private new void Update()
{
string sql = string.Format("update Products set ThrValue = '{0}' where ProductID = '{1}'", TbThrValue.Text.Trim(), TbProID.Text.Trim());
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("修改失败");
}
}
private void Insert()
{
string sql = string.Format("insert into Categories values('{0}','{1}','{2}')", TbID.Text.Trim(), TbName.Text.Trim(), TbDe.Text);
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("插入成功");
}
else
{
MessageBox.Show("插入失败");
}
TbID.Text = GuGuGuHelper.GetCategoryID();
CateRefresh();
}
private void Delete()
{
if (GuGuGuHelper.IsInDataGridView(selectRow, CustomerMain))
{
string id = CustomerMain.Rows[selectRow].Cells["客户编号"].Value.ToString();
string sql = "delete from Customers where CustomerID = '" + id + "'";
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("删除成功");
}
else
{
MessageBox.Show("删除失败，该用户存在订单或者其他未知错误");
}
}
else
{
MessageBox.Show("请选择正确的行");
}
}
private void Updates()
{
if (GuGuGuHelper.IsInDataGridView(selectRow, DGVProduct))
{
string sql = "Update Products set ProductName = '" + TbProductName.Text.Trim() + "',SupplierID = '" + CbxCompanyName.SelectedValue + "',CategoryID = '" + CbxCategoryName.SelectedValue + "',UnitPrice = '" + TbUnitPrice.Text.Trim() + "', ThrValue = '" + TbValue.Text + "', Discont = '" + RbOK.Checked + "' where ProductID = '" + TbProductID.Text.Trim() + "'";
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("修改失败");
}
ProRefresh();
}
else
{
MessageBox.Show("请选择正确的行");
}
}
private void Updates()
{
if (GuGuGuHelper.IsInDataGridView(selectRow, DGVCategories))
{
string id = DGVCategories.Rows[selectRow].Cells["商品类别编号"].Value.ToString();
string sql = "update Categories set CategoryName = '" + TbName.Text.Trim() + "',Description = '" + TbDe.Text.Trim() + "' where CategoryID = '" + id + "'";
int cnt = GuGuGuHelper.ExecuteNonQuery(sql);
if (cnt >= 1)
{
MessageBox.Show("更新成功");
}
else
{
MessageBox.Show("更新失败");
}
CateRefresh();
}
else
{
MessageBox.Show("请选择正确的行");
}
}