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);
}
