/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Maticsoft.Model.sysUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sysUser(");
strSql.Append("UserID,UserName,Password,Workstation,Privilege,ID_Key");
strSql.Append(") values (");
strSql.Append("@UserID,@UserName,@Password,@Workstation,@Privilege,@ID_Key");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 15),
new SqlParameter("@UserName", SqlDbType.VarChar, 15),
new SqlParameter("@Password", SqlDbType.VarChar, 15),
new SqlParameter("@Workstation", SqlDbType.VarChar, 15),
new SqlParameter("@Privilege", SqlDbType.VarChar, 15),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.Workstation;
parameters[4].Value = model.Privilege;
parameters[5].Value = model.ID_Key;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.sysUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sysUser(");
strSql.Append("UserID,UserName,Password,Workstation,Privilege,ID_Key)");
strSql.Append(" values (");
strSql.Append("@UserID,@UserName,@Password,@Workstation,@Privilege,@ID_Key)");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 15),
new SqlParameter("@UserName", SqlDbType.VarChar, 15),
new SqlParameter("@Password", SqlDbType.VarChar, 15),
new SqlParameter("@Workstation", SqlDbType.VarChar, 15),
new SqlParameter("@Privilege", SqlDbType.VarChar, 15),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.Workstation;
parameters[4].Value = model.Privilege;
parameters[5].Value = model.ID_Key;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.sysUser DataRowToModel(DataRow row)
{
Maticsoft.Model.sysUser model = new Maticsoft.Model.sysUser();
if (row != null)
{
if (row["UserID"] != null)
{
model.UserID = row["UserID"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["Password"] != null)
{
model.Password = row["Password"].ToString();
}
if (row["Workstation"] != null)
{
model.Workstation = row["Workstation"].ToString();
}
if (row["Privilege"] != null)
{
model.Privilege = row["Privilege"].ToString();
}
if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
{
model.ID_Key = decimal.Parse(row["ID_Key"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.sysUser GetModel(string UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserID,UserName,Password,Workstation,Privilege,ID_Key from sysUser ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 15)
};
parameters[0].Value = UserID;
Maticsoft.Model.sysUser model = new Maticsoft.Model.sysUser();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
My_MessageBox.My_MessageBox_Message("未找到该工号：" + UserID + " 的用户！");
return(null);
}
}
//
// 添加
//
private void btn_Add_Click(object sender, RoutedEventArgs e)
{
if (_WTT_Workstation != null && txb_Password.Text != "" && txb_JobNum.Text != "" && txb_UserName.Text != "" && cmb_Privilege.Text != "")
{
_WTT_User = new Maticsoft.Model.sysUser()
{
Workstation = _WTT_Workstation.Wo_ID.ToString(),
UserName = txb_UserName.Text,
UserID = txb_JobNum.Text,
Password = txb_Password.Text,
Privilege = cmb_Privilege.Text
};
if (_M_User.Add(_WTT_User))
{
My_MessageBox.My_MessageBox_Message("添加成功！");
dgv_Source.ItemsSource = _M_User.GetModelList("");
}
else
{
My_MessageBox.My_MessageBox_Message("添加失败！");
}
}
else
{
My_MessageBox.My_MessageBox_Message("信息不完整！不能进行添加!");
}
}
private void ShowInfo(string UserID)
{
Maticsoft.BLL.sysUser bll = new Maticsoft.BLL.sysUser();
Maticsoft.Model.sysUser model = bll.GetModel(UserID);
this.lblUserID.Text = model.UserID;
this.lblUserName.Text = model.UserName;
this.lblPassword.Text = model.Password;
this.lblWorkstation.Text = model.Workstation;
this.lblPrivilege.Text = model.Privilege;
this.lblID_Key.Text = model.ID_Key.ToString();
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtUserID.Text.Trim().Length == 0)
{
strErr += "UserID不能为空！\\n";
}
if (this.txtUserName.Text.Trim().Length == 0)
{
strErr += "UserName不能为空！\\n";
}
if (this.txtPassword.Text.Trim().Length == 0)
{
strErr += "Password不能为空！\\n";
}
if (this.txtWorkstation.Text.Trim().Length == 0)
{
strErr += "Workstation不能为空！\\n";
}
if (this.txtPrivilege.Text.Trim().Length == 0)
{
strErr += "Privilege不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtID_Key.Text))
{
strErr += "ID_Key格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string UserID = this.txtUserID.Text;
string UserName = this.txtUserName.Text;
string Password = this.txtPassword.Text;
string Workstation = this.txtWorkstation.Text;
string Privilege = this.txtPrivilege.Text;
decimal ID_Key = decimal.Parse(this.txtID_Key.Text);
Maticsoft.Model.sysUser model = new Maticsoft.Model.sysUser();
model.UserID = UserID;
model.UserName = UserName;
model.Password = Password;
model.Workstation = Workstation;
model.Privilege = Privilege;
model.ID_Key = ID_Key;
Maticsoft.BLL.sysUser bll = new Maticsoft.BLL.sysUser();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
//
//用户列表
//
private void dgv_Source_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dgv_Source.SelectedItem != null)
{
_WTT_User = (Maticsoft.Model.sysUser)dgv_Source.SelectedItem;
//
txb_Password.Text = _WTT_User.Password;
txb_JobNum.Text = _WTT_User.UserID;
txb_UserName.Text = _WTT_User.UserName;
cmb_Privilege.Text = _WTT_User.Privilege;
//
decimal _WK_ID = 0;
if (decimal.TryParse(_WTT_User.Workstation, out _WK_ID))
{
_WTT_Workstation = _M_Workstation.GetModel(_WK_ID);
cmb_Workstation.Text = _WTT_Workstation.Workstation;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.sysUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sysUser set ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" UserName = @UserName , ");
strSql.Append(" Password = @Password , ");
strSql.Append(" Workstation = @Workstation , ");
strSql.Append(" Privilege = @Privilege , ");
strSql.Append(" ID_Key = @ID_Key ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 15),
new SqlParameter("@UserName", SqlDbType.VarChar, 15),
new SqlParameter("@Password", SqlDbType.VarChar, 15),
new SqlParameter("@Workstation", SqlDbType.VarChar, 15),
new SqlParameter("@Privilege", SqlDbType.VarChar, 15),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.Workstation;
parameters[4].Value = model.Privilege;
parameters[5].Value = model.ID_Key;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//开始验证
private void btn_OK_Click(object sender, RoutedEventArgs e)
{
if (txb_UserID.Text == "")
{
My_MessageBox.My_MessageBox_Message("用户名不能为空");
}
else if (txb_Password.Password == "")
{
My_MessageBox.My_MessageBox_Message("密码不能为空");
}
else if (_Method_SysUser.Exists(txb_UserID.Text, txb_Password.Password))
{
_SysUser = _Method_SysUser.GetModel(txb_UserID.Text);
_TemResult_InspectUser = true;
this.Close();
}
else
{
_TemResult_InspectUser = false; this.Close();
}
}
//
//领料—工号
//
private void txb_JobNumber_Receive_KeyUp(object sender, KeyEventArgs e)
{
Maticsoft.BLL.sysUser _M_User = new Maticsoft.BLL.sysUser();
if (e.Key == Key.Enter && txb_JobNumber_Receive.IsFocused == true && txb_JobNumber_Receive.Text != "" &&
txb_JobNumber_Receive.Text != "002222")
{
_WTT_User_Receive = _M_User.GetModel(txb_JobNumber_Receive.Text.Trim());
if (_WTT_User_Receive != null)
{
int tem = -1; int.TryParse(_WTT_User_Receive.Workstation, out tem);
if (tem > -1)
{
cmb_Workstation_Receive.SelectedIndex = tem - 1;
_WTT_WK = (Maticsoft.Model.WorkStation)cmb_Workstation_Receive.SelectedItem;
}
txb_UserName_Receive.Text = _WTT_User_Receive.UserName;
}
else
{
txb_JobNumber_Receive.SelectAll();
}
}
}
//
//领料—工号
//
private void txb_JobNumber_Receive_KeyUp(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter && txb_JobNumber_Receive.IsFocused == true && txb_JobNumber_Receive.Text != "" &&
txb_JobNumber_Receive.Text != "002222")
{
_WTT_UserRcecive = MCP_CS._M_User.GetModel(txb_JobNumber_Receive.Text.Trim());
if (_WTT_UserRcecive != null)
{
int tem = -1;
int.TryParse(_WTT_UserRcecive.Workstation, out tem);
if (tem > -1)
{
cmb_Workstation_Receive.SelectedIndex = tem - 1;
}
txb_UserName_Receive.Text = _WTT_UserRcecive.UserName;
txb_OrderID.Focus();
}
else
{
txb_JobNumber_Receive.SelectAll();
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.sysUser GetModel(string UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserID, UserName, Password, Workstation, Privilege, ID_Key ");
strSql.Append(" from sysUser ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 15)
};
parameters[0].Value = UserID;
Maticsoft.Model.sysUser model = new Maticsoft.Model.sysUser();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString();
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
model.Workstation = ds.Tables[0].Rows[0]["Workstation"].ToString();
model.Privilege = ds.Tables[0].Rows[0]["Privilege"].ToString();
if (ds.Tables[0].Rows[0]["ID_Key"].ToString() != "")
{
model.ID_Key = decimal.Parse(ds.Tables[0].Rows[0]["ID_Key"].ToString());
}
return(model);
}
else
{
return(null);
}
}
//
//编辑
//
private void btn_Edit_Click(object sender, RoutedEventArgs e)
{
txb_JobNumber_Receive.Text = "";
_WTT_User_Receive = null;
isEn(true, true);
}
