private void SaveProductType() { TSM.Model.pms_User_Info modelpms_User_Info = new TSM.Model.pms_User_Info(); modelpms_User_Info.UserName = tbxName.Text.Trim(); modelpms_User_Info.CompanyInfoID = int.Parse(ddlCompany.SelectedValue); modelpms_User_Info.DeptInfoID = int.Parse(ddlDept.SelectedValue); modelpms_User_Info.UserMail = tbxMail.Text.Trim(); modelpms_User_Info.PermissionInfoID = int.Parse(ddlPermission.SelectedValue); modelpms_User_Info.UserPhone = tbxPhone.Text.Trim(); modelpms_User_Info.UserTel = tbxTel.Text.Trim(); modelpms_User_Info.Pwd = tbxPwd.Text.Trim(); m_bllpms_User_Info.Add(modelpms_User_Info); }
/// <summary> /// 得到一个对象实体(登录名,密码) /// </summary> public TSM.Model.pms_User_Info GetModel(string sUserName, string sPassword) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserInfoID,UserName,Pwd,CompanyInfoID,DeptInfoID,PermissionInfoID,UserTel,UserPhone,UserMail from pms_User_Info "); strSql.Append("where UserName=@UserName and Pwd=@Password"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 64), new SqlParameter("@Password", SqlDbType.VarChar, 64) }; parameters[0].Value = sUserName; parameters[1].Value = sPassword; TSM.Model.pms_User_Info model = new TSM.Model.pms_User_Info(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UserInfoID"].ToString() != "") { model.UserInfoID = int.Parse(ds.Tables[0].Rows[0]["UserInfoID"].ToString()); } model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); model.Pwd = ds.Tables[0].Rows[0]["Pwd"].ToString(); if (ds.Tables[0].Rows[0]["CompanyInfoID"].ToString() != "") { model.CompanyInfoID = int.Parse(ds.Tables[0].Rows[0]["CompanyInfoID"].ToString()); } if (ds.Tables[0].Rows[0]["DeptInfoID"].ToString() != "") { model.DeptInfoID = int.Parse(ds.Tables[0].Rows[0]["DeptInfoID"].ToString()); } if (ds.Tables[0].Rows[0]["PermissionInfoID"].ToString() != "") { model.PermissionInfoID = int.Parse(ds.Tables[0].Rows[0]["PermissionInfoID"].ToString()); } model.UserTel = ds.Tables[0].Rows[0]["UserTel"].ToString(); model.UserPhone = ds.Tables[0].Rows[0]["UserPhone"].ToString(); model.UserMail = ds.Tables[0].Rows[0]["UserMail"].ToString(); return(model); } else { return(null); } }
protected void btnSaveClose_Click(object sender, EventArgs e) { int id = GetQueryIntValue("id"); TSM.Model.pms_User_Info modelpms_User_Info = m_bllpms_User_Info.GetModel(id); modelpms_User_Info.UserName = tbxName.Text.Trim(); modelpms_User_Info.CompanyInfoID = int.Parse(ddlCompany.SelectedValue); modelpms_User_Info.DeptInfoID = int.Parse(ddlDept.SelectedValue); modelpms_User_Info.UserMail = tbxMail.Text.Trim(); modelpms_User_Info.PermissionInfoID = int.Parse(ddlPermission.SelectedValue); modelpms_User_Info.UserPhone = tbxPhone.Text.Trim(); modelpms_User_Info.UserTel = tbxTel.Text.Trim(); modelpms_User_Info.Pwd = tbxPwd.Text.Trim(); m_bllpms_User_Info.Update(modelpms_User_Info); FineUI.Alert.Show("保存成功!", String.Empty, FineUI.Alert.DefaultMessageBoxIcon, FineUI.ActiveWindow.GetHidePostBackReference()); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
private void LoadData() { btnClose.OnClientClick = ActiveWindow.GetHideReference(); DataSet dsCom = m_bllpms_Company_Info.GetList(""); DataSet dsDept = m_bllpms_Dept_Info_Info.GetList(""); DataSet dsPerm = m_bllpms_Permission_Info.GetList(""); ddlCompany.DataValueField = "CompanyInfoID"; ddlCompany.DataTextField = "CompanyName"; ddlCompany.DataSource = dsCom.Tables[0]; ddlCompany.DataBind(); ddlPermission.DataValueField = "PermissionInfoID"; ddlPermission.DataTextField = "Permission"; ddlPermission.DataSource = dsPerm.Tables[0]; ddlPermission.DataBind(); ddlDept.DataValueField = "DeptInfoID"; ddlDept.DataTextField = "DeptName"; ddlDept.DataSource = dsDept.Tables[0]; ddlDept.DataBind(); int id = GetQueryIntValue("id"); TSM.Model.pms_User_Info modelpms_User_Info = m_bllpms_User_Info.GetModel(id); if (modelpms_User_Info == null) { // 参数错误,首先弹出Alert对话框然后关闭弹出窗口 Alert.Show("参数错误!", String.Empty, ActiveWindow.GetHideReference()); return; } ddlCompany.SelectedValue = modelpms_User_Info.CompanyInfoID.ToString(); ddlDept.SelectedValue = modelpms_User_Info.DeptInfoID.ToString(); ddlPermission.SelectedValue = modelpms_User_Info.PermissionInfoID.ToString(); tbxName.Text = modelpms_User_Info.UserName; tbxMail.Text = modelpms_User_Info.UserMail; tbxPhone.Text = modelpms_User_Info.UserPhone; tbxTel.Text = modelpms_User_Info.UserTel; tbxPwd.Text = modelpms_User_Info.Pwd; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TSM.Model.pms_User_Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into pms_User_Info("); strSql.Append("UserName,Pwd,CompanyInfoID,DeptInfoID,PermissionInfoID,UserTel,UserPhone,UserMail)"); strSql.Append(" values ("); strSql.Append("@UserName,@Pwd,@CompanyInfoID,@DeptInfoID,@PermissionInfoID,@UserTel,@UserPhone,@UserMail)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 64), new SqlParameter("@Pwd", SqlDbType.VarChar, 64), new SqlParameter("@CompanyInfoID", SqlDbType.Int, 4), new SqlParameter("@DeptInfoID", SqlDbType.Int, 4), new SqlParameter("@PermissionInfoID", SqlDbType.Int, 4), new SqlParameter("@UserTel", SqlDbType.VarChar, 64), new SqlParameter("@UserPhone", SqlDbType.VarChar, 64), new SqlParameter("@UserMail", SqlDbType.VarChar, 64) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Pwd; parameters[2].Value = model.CompanyInfoID; parameters[3].Value = model.DeptInfoID; parameters[4].Value = model.PermissionInfoID; parameters[5].Value = model.UserTel; parameters[6].Value = model.UserPhone; parameters[7].Value = model.UserMail; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TSM.Model.pms_User_Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update pms_User_Info set "); strSql.Append("UserName=@UserName,"); strSql.Append("Pwd=@Pwd,"); strSql.Append("CompanyInfoID=@CompanyInfoID,"); strSql.Append("DeptInfoID=@DeptInfoID,"); strSql.Append("PermissionInfoID=@PermissionInfoID,"); strSql.Append("UserTel=@UserTel,"); strSql.Append("UserPhone=@UserPhone,"); strSql.Append("UserMail=@UserMail"); strSql.Append(" where UserInfoID=@UserInfoID "); SqlParameter[] parameters = { new SqlParameter("@UserInfoID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 64), new SqlParameter("@Pwd", SqlDbType.VarChar, 64), new SqlParameter("@CompanyInfoID", SqlDbType.Int, 4), new SqlParameter("@DeptInfoID", SqlDbType.Int, 4), new SqlParameter("@PermissionInfoID", SqlDbType.Int, 4), new SqlParameter("@UserTel", SqlDbType.VarChar, 64), new SqlParameter("@UserPhone", SqlDbType.VarChar, 64), new SqlParameter("@UserMail", SqlDbType.VarChar, 64) }; parameters[0].Value = model.UserInfoID; parameters[1].Value = model.UserName; parameters[2].Value = model.Pwd; parameters[3].Value = model.CompanyInfoID; parameters[4].Value = model.DeptInfoID; parameters[5].Value = model.PermissionInfoID; parameters[6].Value = model.UserTel; parameters[7].Value = model.UserPhone; parameters[8].Value = model.UserMail; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }