/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(sys_UserTable ut)
{
#region "显示数据"
U_LoginName_Value.Text = ut.U_LoginName;
U_Password_Value.Text = "******";
U_Type_Value.Text = BusinessFacade.sys_UserType(ut.U_Type);
U_Status_Value.Text = ut.U_Status == 0 ? "正常" : "禁止";
U_UserNO_Value.Text = ut.U_UserNO;
U_CName_Value.Text = ut.U_CName;
U_EName_Value.Text = ut.U_EName;
U_GroupID_Value.Text = BusinessFacade.sys_GroupDisp(ut.U_GroupID).G_CName;
U_Sex_Value.Text = ut.U_Sex == 0 ? "女" : "男";
U_BirthDay_Value.Text = Common.ConvertDate(ut.U_BirthDay);
U_Title_Value.Text = BusinessFacade.sys_FieldValueDisp(ut.U_Title).V_Text;
U_IDCard_Value.Text = ut.U_IDCard;
U_HomeTel_Value.Text = ut.U_HomeTel;
U_MobileNo_Value.Text = ut.U_MobileNo;
U_CompanyMail_Value.Text = ut.U_CompanyMail;
U_Email_Value.Text = ut.U_Email;
U_Extension_Value.Text = ut.U_Extension;
U_WorkStartDate_Value.Text = Common.ConvertDate(ut.U_WorkStartDate);
U_Remark_Value.Text = ut.U_Remark;
if ((ut.U_PhotoUrl + "").Trim() != "")
{
U_PhotoUrl_Value.ImageUrl = Common.BuildDownFileUrl("UserPhoto/s_" + ut.U_PhotoUrl);
MaxImgUrl = Common.BuildDownFileUrl("UserPhoto/" + ut.U_PhotoUrl);
}
else
U_PhotoUrl_Value.Visible = false;
U_LastIP_Value.Text = Common.GetIPLookUrl(ut.U_LastIP);
U_LastDateTime_Value.Text = ut.U_LastDateTime.ToString();
#endregion
#region "输入数据"
U_LoginName.Text = ut.U_LoginName;
U_Password.Attributes["value"] = ut.U_Password;
ListItem li = U_Type.Items.FindByValue(ut.U_Type.ToString());
if (li != null)
li.Selected = true;
ListItem li1 = U_Status.Items.FindByValue(ut.U_Status.ToString());
if (li1 != null)
li1.Selected = true;
U_UserNO.Text = ut.U_UserNO;
U_CName.Text = ut.U_CName;
U_EName.Text = ut.U_EName;
U_GroupID.Value = ut.U_GroupID.ToString();
U_GroupID_Txt.Value = BusinessFacade.sys_GroupDisp(ut.U_GroupID).G_CName;
ListItem li2 = U_Sex.Items.FindByValue(ut.U_Sex.ToString());
if (li2 != null)
li2.Selected = true;
U_BirthDay.Text = Common.ConvertDate(ut.U_BirthDay);
FieldWebControls1.Field_Value = ut.U_Title.ToString();
U_IDCard.Text = ut.U_IDCard;
U_HomeTel.Text = ut.U_HomeTel;
U_MobileNo.Text = ut.U_MobileNo;
U_CompanyMail.Text = ut.U_CompanyMail;
U_Email.Text = ut.U_Email;
U_Extension.Text = ut.U_Extension;
U_WorkStartDate.Text = Common.ConvertDate(ut.U_WorkStartDate);
U_Remark.Text = ut.U_Remark;
//if ((ut.U_PhotoUrl + "").Trim() != "")
//{
// U_PhotoUrl_Value.ImageUrl = Common.BuildDownFileUrl("UserPhoto/s_" + ut.U_PhotoUrl);
//}
//else
// U_PhotoUrl_Value.Visible = false;
#endregion
}
/// <summary>
/// 新增/删除/修改 sys_User
/// </summary>
/// <param name="fam">sys_UserTable实体类</param>
/// <returns>返回0操正常</returns>
public override int sys_UserInsertUpdate(sys_UserTable fam)
{
int rInt = 0;
using (SqlConnection Conn = GetSqlConnection())
{
SqlCommand cmd = new SqlCommand("sys_UserInsertUpdateDelete", Conn);
cmd.CommandType = CommandType.StoredProcedure;
//设置参数
cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录
cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = fam.UserID; //用户ID号
cmd.Parameters.Add("@U_LoginName", SqlDbType.NVarChar).Value = fam.U_LoginName; //登陆名
cmd.Parameters.Add("@U_Password", SqlDbType.VarChar).Value = fam.U_Password; //密码md5加密字符
cmd.Parameters.Add("@U_CName", SqlDbType.NVarChar).Value = fam.U_CName; //中文姓名
cmd.Parameters.Add("@U_EName", SqlDbType.VarChar).Value = fam.U_EName; //英文名
cmd.Parameters.Add("@U_GroupID", SqlDbType.Int).Value = fam.U_GroupID; //部门ID号与sys_Group表中GroupID关联
cmd.Parameters.Add("@U_Email", SqlDbType.VarChar).Value = fam.U_Email; //电子邮件
cmd.Parameters.Add("@U_Type", SqlDbType.Int).Value = fam.U_Type; //用户类型0:超级用户1:普通用户
cmd.Parameters.Add("@U_Status", SqlDbType.Int).Value = fam.U_Status; //当前状态0:正常 1:禁止
cmd.Parameters.Add("@U_Licence", SqlDbType.VarChar).Value = fam.U_Licence; //用户序列号
cmd.Parameters.Add("@U_Mac", SqlDbType.VarChar).Value = fam.U_Mac; //锁定机器硬件地址
cmd.Parameters.Add("@U_Remark", SqlDbType.NVarChar).Value = fam.U_Remark; //备注说明
cmd.Parameters.Add("@U_IDCard", SqlDbType.VarChar).Value = fam.U_IDCard; //身份证号码
cmd.Parameters.Add("@U_Sex", SqlDbType.Int).Value = fam.U_Sex; //性别1:男0:女
if (fam.U_BirthDay.HasValue)
cmd.Parameters.Add("@U_BirthDay", SqlDbType.DateTime).Value = fam.U_BirthDay; //出生日期
else
cmd.Parameters.Add("@U_BirthDay", SqlDbType.DateTime).Value = DBNull.Value; //出生日期
cmd.Parameters.Add("@U_MobileNo", SqlDbType.VarChar).Value = fam.U_MobileNo; //手机号
cmd.Parameters.Add("@U_UserNO", SqlDbType.VarChar).Value = fam.U_UserNO; //员工编号
if (fam.U_WorkStartDate.HasValue)
cmd.Parameters.Add("@U_WorkStartDate", SqlDbType.DateTime).Value = fam.U_WorkStartDate; //到职日期
else
cmd.Parameters.Add("@U_WorkStartDate", SqlDbType.DateTime).Value = DBNull.Value; //到职日期
if (fam.U_WorkEndDate.HasValue)
cmd.Parameters.Add("@U_WorkEndDate", SqlDbType.DateTime).Value = fam.U_WorkEndDate; //离职日期
else
cmd.Parameters.Add("@U_WorkEndDate", SqlDbType.DateTime).Value = DBNull.Value; //离职日期
cmd.Parameters.Add("@U_CompanyMail", SqlDbType.VarChar).Value = fam.U_CompanyMail; //公司邮件地址
cmd.Parameters.Add("@U_Title", SqlDbType.Int).Value = fam.U_Title; //职称与应用字段关联
cmd.Parameters.Add("@U_Extension", SqlDbType.VarChar).Value = fam.U_Extension; //分机号
cmd.Parameters.Add("@U_HomeTel", SqlDbType.VarChar).Value = fam.U_HomeTel; //家中电话
cmd.Parameters.Add("@U_PhotoUrl", SqlDbType.NVarChar).Value = fam.U_PhotoUrl; //用户照片网址
cmd.Parameters.Add("@U_DateTime", SqlDbType.DateTime).Value = fam.U_DateTime; //操作时间
cmd.Parameters.Add("@U_LastIP", SqlDbType.VarChar).Value = fam.U_LastIP; //最后访问IP
cmd.Parameters.Add("@U_LastDateTime", SqlDbType.DateTime).Value = fam.U_LastDateTime; //最后访问时间
cmd.Parameters.Add("@U_ExtendField", SqlDbType.NText).Value = fam.U_ExtendField; //扩展字段
Conn.Open();
rInt = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
Conn.Dispose();
Conn.Close();
}
return rInt;
}
/// <summary>
/// 将记录集转为sys_UserTable实体类
/// </summary>
/// <param name="dr">记录集</param>
/// <returns>sys_UserTable</returns>
protected object Populatesys_User(IDataReader dr)
{
sys_UserTable nc = new sys_UserTable();
if (!Convert.IsDBNull(dr["UserID"])) nc.UserID = Convert.ToInt32(dr["UserID"]); // 用户ID号
if (!Convert.IsDBNull(dr["U_LoginName"])) nc.U_LoginName = Convert.ToString(dr["U_LoginName"]).Trim(); // 登陆名
if (!Convert.IsDBNull(dr["U_Password"])) nc.U_Password = Convert.ToString(dr["U_Password"]).Trim(); // 密码md5加密字符
if (!Convert.IsDBNull(dr["U_CName"])) nc.U_CName = Convert.ToString(dr["U_CName"]).Trim(); // 中文姓名
if (!Convert.IsDBNull(dr["U_EName"])) nc.U_EName = Convert.ToString(dr["U_EName"]).Trim(); // 英文名
if (!Convert.IsDBNull(dr["U_GroupID"])) nc.U_GroupID = Convert.ToInt32(dr["U_GroupID"]); // 部门ID号与sys_Group表中GroupID关联
if (!Convert.IsDBNull(dr["U_Email"])) nc.U_Email = Convert.ToString(dr["U_Email"]).Trim(); // 电子邮件
if (!Convert.IsDBNull(dr["U_Type"])) nc.U_Type = Convert.ToInt32(dr["U_Type"]); // 用户类型0:超级用户1:普通用户
if (!Convert.IsDBNull(dr["U_Status"])) nc.U_Status = Convert.ToInt32(dr["U_Status"]); // 当前状态0:正常 1:禁止
if (!Convert.IsDBNull(dr["U_Licence"])) nc.U_Licence = Convert.ToString(dr["U_Licence"]).Trim(); // 用户序列号
if (!Convert.IsDBNull(dr["U_Mac"])) nc.U_Mac = Convert.ToString(dr["U_Mac"]).Trim(); // 锁定机器硬件地址
if (!Convert.IsDBNull(dr["U_Remark"])) nc.U_Remark = Convert.ToString(dr["U_Remark"]).Trim(); // 备注说明
if (!Convert.IsDBNull(dr["U_IDCard"])) nc.U_IDCard = Convert.ToString(dr["U_IDCard"]).Trim(); // 身份证号码
if (!Convert.IsDBNull(dr["U_Sex"])) nc.U_Sex = Convert.ToInt32(dr["U_Sex"]); // 性别1:男0:女
if (!Convert.IsDBNull(dr["U_BirthDay"])) nc.U_BirthDay = Convert.ToDateTime(dr["U_BirthDay"]); // 出生日期
if (!Convert.IsDBNull(dr["U_MobileNo"])) nc.U_MobileNo = Convert.ToString(dr["U_MobileNo"]).Trim(); // 手机号
if (!Convert.IsDBNull(dr["U_UserNO"])) nc.U_UserNO = Convert.ToString(dr["U_UserNO"]).Trim(); // 员工编号
if (!Convert.IsDBNull(dr["U_WorkStartDate"])) nc.U_WorkStartDate = Convert.ToDateTime(dr["U_WorkStartDate"]); // 到职日期
if (!Convert.IsDBNull(dr["U_WorkEndDate"])) nc.U_WorkEndDate = Convert.ToDateTime(dr["U_WorkEndDate"]); // 离职日期
if (!Convert.IsDBNull(dr["U_CompanyMail"])) nc.U_CompanyMail = Convert.ToString(dr["U_CompanyMail"]).Trim(); // 公司邮件地址
if (!Convert.IsDBNull(dr["U_Title"])) nc.U_Title = Convert.ToInt32(dr["U_Title"]); // 职称与应用字段关联
if (!Convert.IsDBNull(dr["U_Extension"])) nc.U_Extension = Convert.ToString(dr["U_Extension"]).Trim(); // 分机号
if (!Convert.IsDBNull(dr["U_HomeTel"])) nc.U_HomeTel = Convert.ToString(dr["U_HomeTel"]).Trim(); // 家中电话
if (!Convert.IsDBNull(dr["U_PhotoUrl"])) nc.U_PhotoUrl = Convert.ToString(dr["U_PhotoUrl"]).Trim(); // 用户照片网址
if (!Convert.IsDBNull(dr["U_DateTime"])) nc.U_DateTime = Convert.ToDateTime(dr["U_DateTime"]); // 操作时间
if (!Convert.IsDBNull(dr["U_LastIP"])) nc.U_LastIP = Convert.ToString(dr["U_LastIP"]).Trim(); // 最后访问IP
if (!Convert.IsDBNull(dr["U_LastDateTime"])) nc.U_LastDateTime = Convert.ToDateTime(dr["U_LastDateTime"]); // 最后访问时间
if (!Convert.IsDBNull(dr["U_ExtendField"])) nc.U_ExtendField = Convert.ToString(dr["U_ExtendField"]).Trim(); // 扩展字段
return nc;
}
/// <summary> /// 新增/删除/修改 sys_User /// </summary> /// <param name="fam">sys_UserTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_UserInsertUpdate(sys_UserTable fam);
/// <summary>
/// 检测是否违反sys_User表的PK值
/// </summary>
/// <param name="fam">sys_UserTable类</param>
/// <param name="pt">PopedomType类型，只对New,Edit有效</param>
/// <returns></returns>
public static bool sys_UserTableCheckPK(sys_UserTable fam, PopedomType pt)
{
QueryParam qp = new QueryParam();
if (pt == PopedomType.New)
qp.Where = string.Format(" Where U_LoginName='{0}'", fam.U_LoginName);
else if (pt == PopedomType.Edit)
qp.Where = string.Format(" Where U_LoginName='{0}' and UserID<>{1} ", fam.U_LoginName, fam.UserID);
int RecordCount = 0;
sys_UserList(qp, out RecordCount);
if (RecordCount > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 根据ID返回 sys_UserTable实体类 单笔资料
/// </summary>
/// <param name="UserID">用户ID号</param>
/// <returns>返回sys_UserTable实体类 UserID为0则无记录</returns>
public static sys_UserTable sys_UserDisp(int UserID)
{
sys_UserTable fam = new sys_UserTable();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = " Where sys_User.UserID = " + UserID;
int RecordCount = 0;
ArrayList lst = sys_UserList(qp, out RecordCount);
if (RecordCount > 0)
{
fam = (sys_UserTable)lst[0];
}
return fam;
}
/// <summary>
/// 新增/删除/修改 sys_User
/// </summary>
/// <param name="fam">sys_UserTable实体类</param>
/// <returns>返回0操正常</returns>
public static int sys_UserInsertUpdate(sys_UserTable fam)
{
return DataProvider.Instance().sys_UserInsertUpdate(fam);
}
