private UserListEntity GetUserListFromDataRow(DataRow dr)
{
UserListEntity dt = new UserListEntity();
if (dr["UserSerialID"].ToString() != "" || dr["UserSerialID"] != null) dt.UserSerialID = Int32.Parse(dr["UserSerialID"].ToString());
dt.UserID = dr["UserID"].ToString();
dt.PassWord = dr["PassWord"].ToString();
dt.UserName = dr["UserName"].ToString();
dt.UserType = dr["UserType"].ToString();
dt.UserTypeN = dr["UserTypeN"].ToString();
dt.UserEmail = dr["UserEmail"].ToString();
dt.UserCode = dr["UserCode"].ToString();
dt.DeptName = dr["DeptName"].ToString();
dt.UseFlag = dr["UseFlag"].ToString();
dt.CreateUser = dr["CreateUser"].ToString();
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
dt.LastModifier = dr["LastModifier"].ToString();
dt.LastModifyDate = Convert.ToDateTime(dr["LastModifyDate"]);
return dt;
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_UserListEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateUserList(UserListEntity _UserListEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@UserSerialID",(DbType)SqlDbType.Int,4,_UserListEntity.UserSerialID ),
MakeInParam("@UserID",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserID ),
MakeInParam("@PassWord",(DbType)SqlDbType.VarChar,50,_UserListEntity.PassWord ),
MakeInParam("@UserName",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserName ),
MakeInParam("@UserType",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserType ),
MakeInParam("@UserEmail",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserEmail ),
MakeInParam("@UserCode",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserCode ),
MakeInParam("@UseFlag",(DbType)SqlDbType.VarChar,1,_UserListEntity.UseFlag ),
MakeInParam("@LastModifier",(DbType)SqlDbType.VarChar,50,_UserListEntity.LastModifier ),
MakeInParam("@LastModifyDate",(DbType)SqlDbType.DateTime,16,_UserListEntity.LastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[UserList]");
sb.Append(" set ");
sb.Append(" [UserID]=@UserID,");
sb.Append(" [PassWord]=@PassWord,");
sb.Append(" [UserName]=@UserName,");
sb.Append(" [UserType]=@UserType,");
sb.Append(" [UserEmail]=@UserEmail,");
sb.Append(" [UserCode]=@UserCode,");
sb.Append(" [UseFlag]=@UseFlag,");
sb.Append(" [LastModifier]=@LastModifier,");
sb.Append(" [LastModifyDate]=@LastModifyDate ");
sb.Append(" where [UserSerialID]=@UserSerialID ");
return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_UserListEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddUserList(UserListEntity _UserListEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = {
MakeInParam("@UserID",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserID ),
MakeInParam("@UserCode",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserCode ),
MakeInParam("@UserType",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserType ),
};
string sql = "select * from UserList where (len(@UserID)>0 and UserID=@UserID) or (@UserType='0' and UserCode=@UserCode) ";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-2";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
MakeInParam("@UserID",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserID ),
MakeInParam("@PassWord",(DbType)SqlDbType.VarChar,50,_UserListEntity.PassWord ),
MakeInParam("@UserName",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserName ),
MakeInParam("@UserType",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserType ),
MakeInParam("@UserEmail",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserEmail ),
MakeInParam("@UserCode",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserCode ),
MakeInParam("@UseFlag",(DbType)SqlDbType.VarChar,1,_UserListEntity.UseFlag ),
MakeInParam("@CreateUser",(DbType)SqlDbType.VarChar,50,_UserListEntity.CreateUser ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,16,_UserListEntity.CreateDate ),
MakeInParam("@LastModifier",(DbType)SqlDbType.VarChar,50,_UserListEntity.LastModifier ),
MakeInParam("@LastModifyDate",(DbType)SqlDbType.DateTime,16,_UserListEntity.LastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[UserList]");
sb.Append("(");
sb.Append(" [UserID]");
sb.Append(",[PassWord]");
sb.Append(",[UserName]");
sb.Append(",[UserType]");
sb.Append(",[UserEmail]");
sb.Append(",[UserCode]");
sb.Append(",[UseFlag]");
sb.Append(",[CreateUser]");
sb.Append(",[CreateDate]");
sb.Append(",[LastModifier]");
sb.Append(",[LastModifyDate]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@UserID,");
sb.Append("@PassWord,");
sb.Append("@UserName,");
sb.Append("@UserType,");
sb.Append("@UserEmail,");
sb.Append("@UserCode,");
sb.Append("@UseFlag,");
sb.Append("@CreateUser,");
sb.Append("@CreateDate,");
sb.Append("@LastModifier,");
sb.Append("@LastModifyDate )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
}
protected void Share_Button(object sender, EventArgs e)
{
string szAllName;
szAllName = txtSendTo.Text;
int iCount = 0;
string[] szOneAllName = szAllName.Split(';');
int CalendarID=0, PermissionUserID=0;
foreach (string szOneName in szOneAllName)
{
if (szOneName != "")
{
string[] szName = szOneName.Split('(');
CalendarPermission _CalendarPermission = new CalendarPermission();
foreach (string szUserName in szName)
{
iCount++;
if (iCount == 1)
{
_CalendarPermission = new CalendarPermission();
UserListEntity _UserListEntity = new UserListEntity();
_UserListEntity = DbHelper.GetInstance().GetUserListEntityByUserID(szUserName);
if (_UserListEntity != null)
{
_CalendarPermission.CalendarPermissionUserID = _UserListEntity.UserSerialID; //共享人员ID
PermissionUserID = _UserListEntity.UserSerialID;
}
else
_CalendarPermission.CalendarID = 0;
_CalendarPermission.CalendarID = Int32.Parse(Context.Session["UserID"].ToString());
CalendarID = Int32.Parse(Context.Session["UserID"].ToString());
}
else
{
string[] szPermission = szUserName.Split(')');
int iPerCount = 0;
foreach (string szPermissionName in szPermission)
{
iPerCount++;
if (iPerCount == 1)
{
_CalendarPermission.CalendarPer = szPermissionName; //权限
CalendarPermission _Calendar = DbHelper.GetInstance().GetCalendarPermissionEntityByID(CalendarID, PermissionUserID);
if (_Calendar == null)
{
string szIndex = DbHelper.GetInstance().AddNewsCalenderPermission(_CalendarPermission); //添加
}
else
{
string szIndex = DbHelper.GetInstance().UpDateCalendarPermission(_CalendarPermission); //更新
}
}
else
iPerCount = 0;
}
iCount = 0;
}
}
}
}
}
private string SaveData()
{
UserListEntity _UserListEntity = new UserListEntity();
_UserListEntity.UserSerialID = Convert.ToInt32(txtUserSerialID.Value != string.Empty ? txtUserSerialID.Value : "0");
_UserListEntity.UserID = txtUserID.Text;
_UserListEntity.UserName = txtUserName.Text;
_UserListEntity.UserType = ddlUserType.SelectedValue;
_UserListEntity.UserEmail = txtUserEmail.Text;
_UserListEntity.UserCode = txtUserCode.Text;
_UserListEntity.UseFlag = chkUseFlag.Checked ? "1" : "0";
_UserListEntity.CreateUser = userEntity.UserID;
_UserListEntity.CreateDate = DateTime.Now;
_UserListEntity.LastModifier = userEntity.UserID;
_UserListEntity.LastModifyDate = DateTime.Now;
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddUserList(_UserListEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateUserList(_UserListEntity);
return sResult;
}
/// <summary>
/// BasePage类构造函数
/// </summary>
public BasePage()
{
strButtonHideScript = "<script type=\"text/javascript\" lanuage=\"javascript\"> \r\n" +
"buttonHidesuccess(); \r\n" +
"</script> \r\n";
config = GeneralConfigs.GetConfig();
//先看是否正常登陆
userid=WebUtils.GetCookieUser();
password = WebUtils.GetCookiePassword(config.Passwordkey);
if (userid == "" || password == "")
{
Context.Response.Redirect("/login.aspx",true);
return;
}
if (!Page.IsPostBack)
{
this.RegisterAdminPageClientScriptBlock();
}
if (userEntity == null)
{
userEntity = DbHelper.GetInstance().GetUserListEntityByUserID(userid);
}
if (config.Closed == 1 && pagename != "login.aspx" && pagename != "logout.aspx" && pagename != "register.aspx" )
{
ShowMessage(1);
return;
}
nowdate = Utils.GetDate();
nowtime = Utils.GetTime();
nowdatetime = Utils.GetDateTime();
link = "";
script = "";
isseccode = Utils.InArray(pagename, config.Seccodestatus);
if ((isseccode))
{
if (DNTRequest.GetString("vcode") == "")
{
if (pagename == "showforum.aspx")
{
}
else if (pagename.EndsWith("ajax.aspx"))
{
if (DNTRequest.GetString("t") == "quickreply")
{
ResponseAjaxVcodeError();
}
}
else
{
AddErrLine("验证码错误");
}
}
else
{
}
}
m_starttickDateTime = DateTime.Now;
ShowPage();
m_processtime = DateTime.Now.Subtract(m_starttickDateTime).TotalMilliseconds / 1000;
}
