public static JsMessage Add_Userinfo(UserInfo u)
{
JsMessage js = new JsMessage();
string SqlStr = "INSERT INTO [dbo].[AccountManage] ([am_LoginUser],[am_PWD],[am_Email],[am_Name],[am_Phone],[am_Status],[am_CreateTime],[am_Role]) values(@am_LoginUser,@am_PWD,@am_Email,@am_Name,@am_Phone,@am_Status,@am_CreateTime,@am_Role)";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_LoginUser",u.U_LoginName),
new SqlParameter("@am_PWD",u.U_PWD),
new SqlParameter("@am_Email",u.U_Email),
new SqlParameter("@am_Role",u.U_Role),
//new SqlParameter("@am_Phone",u.U_Phone),
new SqlParameter("@am_Name",""),
new SqlParameter("@am_Phone",""),
new SqlParameter("@am_Status",u.U_Status),
new SqlParameter("@am_CreateTime",u.CreateTime)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage ChangePWD(UserInfo user)
{
JsMessage jm = new JsMessage();
string SqlStr = " UPDATE [dbo].[AccountManage] SET [am_PWD]=@am_PWD WHERE am_LoginUser=@am_LoginUser";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_PWD",user.U_Name),
new SqlParameter("@am_LoginUser",user.U_LoginName)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
jm.IsSuccess = true;
jm.ErrorMsg = "密码修改完成";
}
else
{
jm.IsSuccess = false;
jm.ErrorMsg = "密码修改失败";
}
}
catch (SqlException ex)
{
jm.IsSuccess = false;
jm.ErrorMsg = ex.ToString();
}
return jm;
}
public ActionResult ChangePWD_DB(UserInfo user)
{
string ResultStr = string.Empty;
JsMessage jm = new JsMessage();
string dbpwd = Sql_AccounrManage.OldPWD_NewPWD(user.U_LoginName);
if (dbpwd == user.U_PWD)
{
jm = Sql_AccounrManage.ChangePWD(user);
}
else {
jm.IsSuccess = false;
jm.ErrorMsg = "原始密码不正确";
}
ResultStr = JsonTool.ObjToJson(jm);
return Content(ResultStr);
}
public ActionResult AddAccount(UserInfo u)
{
JsMessage jm=new JsMessage ();
string ResultStr = string.Empty;
if (u.U_ID != 0)
{
jm = Sql_AccounrManage.Modify_Userinfo(u);
}
else
{
u.CreateTime = DateTime.Now.ToString();
u.U_Role = "1";
u.U_PWD = "snnu111111";// 随机6位密码
jm= Sql_AccounrManage.Add_Userinfo(u);
}
ResultStr = JsonTool.ObjToJson(jm);
return Content(ResultStr);
}
/// <summary>
/// 添加组合题
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Add_ZHST(DanXuan DX)
{
JsMessage js = new JsMessage();
string SqlStr = @" INSERT INTO [dbo].[WT]
([wt_WJID]
,[wt_OrderNum]
,[wt_Title]
,[wt_Pageing]
,[wt_PID]
,[wt_LimitTime]
,[wt_Type]
,[wt_Problem]
,[wt_Options]
,[wt_IsAnswer]
,[wt_LogicRelated])
VALUES
(@wt_WJID,
@wt_OrderNum,
@wt_Title,
@wt_Pageing,
@wt_PID,
@wt_LimitTime,
@wt_Type,
@wt_Problem,
@wt_Options,
@wt_IsAnswer,
@wt_LogicRelated);SELECT @wt_ID=SCOPE_IDENTITY();";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wt_WJID",DX.wt_WJID),
new SqlParameter("@wt_OrderNum",DX.wt_OrderNum),
new SqlParameter("@wt_Title",DX.wt_Title),
new SqlParameter("@wt_Pageing",DX.wt_Pageing),
new SqlParameter("@wt_PID",DX.wt_PID),
new SqlParameter("@wt_LimitTime",DX.wt_LimitTime),
new SqlParameter("@wt_Type",DX.wt_Type),
new SqlParameter("@wt_Problem",SqlDbType.VarChar,400){Value=DX.wt_Problem},
new SqlParameter("@wt_Options",SqlDbType.VarChar,4000){Value=DX.wt_Options},
new SqlParameter("@wt_IsAnswer",SqlDbType.NVarChar,10){Value=DX.wt_IsAnswer},
new SqlParameter("@wt_LogicRelated",SqlDbType.NVarChar,2000){Value=DX.wt_LogicRelated},
new SqlParameter("@wt_ID",SqlDbType.Int){Direction = ParameterDirection.Output}
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
js.ReturnADD_ID = int.Parse(commandParameters[11].Value.ToString());
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage CheckUserIsExist(string LoginName)
{
JsMessage js = new JsMessage();
string SqlStr = " SELECT count(1) FROM [SXNU_Questionnaire].[dbo].[AccountManage] WHERE am_LoginUser=@am_LoginUser";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_LoginUser",LoginName)
};
try
{
js.IsExist = SqlHelper.Exists(SqlStr, commandParameters);
js.IsSuccess = true;
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改问卷
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_Question_BaseInfo(QuestionInfo Q)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WJ]
SET [wj_BaseInfo] = @wj_BaseInfo ,[wj_PageSize]=@wj_PageSize WHERE [wj_ID]=@wj_ID "; //pagesize 字段没有使用暂时作为姓名字段来使用 存储是否必须值
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_BaseInfo",SqlDbType.NVarChar,8000){Value=Q.wj_BaseInfo},
new SqlParameter("@wj_PageSize",Q.wj_PageSize),
new SqlParameter("@wj_ID",Q.wj_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage PublishWJ(QuestionInfo Q)
{
Q.wj_PublishTime = Q.wj_Status == "y" ? DateTime.Now.ToString() : "";
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WJ] SET [wj_Status] = @wj_Status ,[wj_PublishTime]=@wj_PublishTime WHERE [wj_ID]=@wj_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_Status",Q.wj_Status),
new SqlParameter("@wj_PublishTime",Q.wj_PublishTime),
new SqlParameter("@wj_ID",Q.wj_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage Add_Notice(NoticeInfo no)
{
JsMessage js = new JsMessage();
string SqlStr = "INSERT INTO [dbo].[Notice] ([no_Title],[no_Content],[no_PublicTime],[no_IsExpired]) values (@no_Title,@no_Content,@no_PublicTime,@no_IsExpired)";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@no_Title",no.No_Title),
new SqlParameter("@no_Content",no.No_Content),
new SqlParameter("@no_PublicTime",no.No_PublicTime),
new SqlParameter("@no_IsExpired",no.No_IsExpired)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改问卷
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_Question(QuestionInfo Q)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WJ]
SET [wj_ProjectSource]= @wj_ProjectSource,
[wj_Number] = @wj_Number,
[wj_Sponsor] = @wj_Sponsor,
[wj_Time] = @wj_Time,
[wj_Title] = @wj_Title,
[wj_BeginPic] = @wj_BeginPic,
[wj_BeginBody] = @wj_BeginBody,
[wj_EndBody] = @wj_EndBody,
[wj_PageSize] = @wj_PageSize,
[wj_PublishTime] = @wj_PublishTime,
[wj_Status] = @wj_Status,
[wj_ValidStart] = @wj_ValidStart,
[wj_ValidEnd] = @wj_ValidEnd
WHERE [wj_ID]=@wj_ID ";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_ProjectSource",SqlDbType.NVarChar,100){Value=Q.wj_ProjectSource},
new SqlParameter("@wj_Number",Q.wj_Number),
new SqlParameter("@wj_Sponsor",Q.wj_Sponsor),
new SqlParameter("@wj_Time",Q.wj_Time),
new SqlParameter("@wj_Title",Q.wj_Title),
new SqlParameter("@wj_BeginPic",SqlDbType.VarChar,100){Value=Q.wj_BeginPic},
new SqlParameter("@wj_BeginBody",SqlDbType.NVarChar,8000){Value=Q.wj_BeginBody},
new SqlParameter("@wj_EndBody",SqlDbType.NVarChar,2000){Value=Q.wj_EndBody},
new SqlParameter("@wj_PageSize",Q.wj_PageSize),
new SqlParameter("@wj_PublishTime",Q.wj_PublishTime),
new SqlParameter("@wj_Status",Q.wj_Status),
new SqlParameter("@wj_ValidStart",Q.wj_ValidStart),
new SqlParameter("@wj_ValidEnd",Q.wj_ValidEnd),
new SqlParameter("@wj_ID",Q.wj_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 设置试题逻辑关系
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Set_Relation(DanXuan dx)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WT] SET [wt_Options] = @wt_Options ,[wt_LogicRelated]=@wt_LogicRelated WHERE [wt_ID]=@wt_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wt_Options",SqlDbType.VarChar,6000){Value=dx.wt_Options},
new SqlParameter("@wt_LogicRelated",SqlDbType.VarChar,10){Value=dx.wt_LogicRelated},
new SqlParameter("@wt_ID",dx.wt_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 设置试题休息
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage SetST_Sleep(DanXuan DX)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WT]
SET [wt_Sleep] = @wt_Sleep WHERE [wt_ID]=@wt_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wt_Sleep",SqlDbType.VarChar,1000){Value=DX.wt_Sleep},
new SqlParameter("@wt_ID",DX.wt_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 添加问卷
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Add_Question(QuestionInfo Q)
{
JsMessage js = new JsMessage();
string SqlStr = @" INSERT INTO [dbo].[WJ] (
[wj_ProjectSource]
,[wj_Number]
,[wj_Sponsor]
,[wj_Time]
,[wj_Title]
,[wj_BeginPic]
,[wj_BeginBody]
,[wj_EndBody]
,[wj_PageSize]
,[wj_PublishTime]
,[wj_Status]
,[wj_ValidStart]
,[wj_ValidEnd])
VALUES
( @wj_ProjectSource
,@wj_Number
,@wj_Sponsor
,@wj_Time
,@wj_Title
,@wj_BeginPic
,@wj_BeginBody
,@wj_EndBody
,@wj_PageSize
,@wj_PublishTime
,@wj_Status
,@wj_ValidStart
,@wj_ValidEnd );SELECT @wj_ID=SCOPE_IDENTITY();";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_ProjectSource",SqlDbType.NVarChar,100){Value=Q.wj_ProjectSource},
new SqlParameter("@wj_Number",Q.wj_Number),
new SqlParameter("@wj_Sponsor",Q.wj_Sponsor),
new SqlParameter("@wj_Time",Q.wj_Time),
new SqlParameter("@wj_Title",Q.wj_Title),
new SqlParameter("@wj_BeginPic",SqlDbType.VarChar,100){Value=Q.wj_BeginPic},
new SqlParameter("@wj_BeginBody",SqlDbType.NVarChar,8000){Value=Q.wj_BeginBody},
new SqlParameter("@wj_EndBody",SqlDbType.NVarChar,2000){Value=Q.wj_EndBody},
new SqlParameter("@wj_PageSize",Q.wj_PageSize),
new SqlParameter("@wj_PublishTime",Q.wj_PublishTime),
new SqlParameter("@wj_Status",Q.wj_Status),
new SqlParameter("@wj_ValidStart",Q.wj_ValidStart),
new SqlParameter("@wj_ValidEnd",Q.wj_ValidEnd),
new SqlParameter("@wj_ID",SqlDbType.Int){Direction = ParameterDirection.Output}
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
js.ReturnADD_ID = int.Parse(commandParameters[13].Value.ToString());
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = true;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 删除分组
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Del_Group(int ID)
{
JsMessage js = new JsMessage();
string SqlStr = @" DELETE [SXNU_Questionnaire].[dbo].[Total_Group] WHERE ID=@ID ";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@ID", ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 添加分组
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Add_Group(Total_Group DX)
{
JsMessage js = new JsMessage();
string SqlStr = @" INSERT INTO [dbo].[Total_Group]
([GroupName]
,[WJID]
,[IDValue] )
VALUES
(@GroupName,
@WJID,
@IDValue);SELECT @ID=SCOPE_IDENTITY();";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@GroupName",DX.GroupName),
new SqlParameter("@WJID",DX.WJID),
new SqlParameter("@IDValue",DX.IDValue),
new SqlParameter("@ID",SqlDbType.Int){Direction = ParameterDirection.Output}
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
js.ReturnADD_ID = int.Parse(commandParameters[3].Value.ToString());
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage Modify_Notice(string SqlStr, SqlParameter[] commandParameters)
{
JsMessage js = new JsMessage();
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改通知信息
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
/*
* UPDATE [dbo].[AccountManage] SET [am_LoginUser] ='' ,[am_PWD] =,
[am_Email] = '',
[am_Name] ='',
[am_Phone] = '',
[am_Status] = '',
[am_CreateTime] = ''
WHERE [am_ID]=@am_ID
*/
public static JsMessage Modify_Notice(NoticeInfo no)
{
JsMessage js = new JsMessage();
string SqlStr = "UPDATE [dbo].[Notice] SET [no_Title] =@no_Title,[no_Content] =@no_Content WHERE [no_ID]=@no_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@no_Title",no.No_Title),
new SqlParameter("@no_Content",no.No_Content),
new SqlParameter("@no_ID",no.No_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 删除试题
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static JsMessage Delete_SJ(int ID)
{
JsMessage js = new JsMessage();
string SqlStr = "DELETE FROM [dbo].[WT] WHERE [wt_ID]=@wt_ID";
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@wt_ID", ID) };
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 设置试题排序号码
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage SetST_UD(Up_Down UD)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WT] SET [wt_OrderNum] ='" + UD.Pro_Num + "' WHERE [wt_ID]=" + UD.Pro_ID + " ; UPDATE [dbo].[WT] SET [wt_OrderNum] = '" + UD.Next_Num + "' WHERE [wt_ID]=" + UD.Next_ID;
//string SqlStr = @" UPDATE [dbo].[WT] SET [wt_PID]="+UD.Pro_PID+", [wt_OrderNum] ='" + UD.Pro_Num + "' WHERE [wt_ID]=" + UD.Pro_ID + " ; UPDATE [dbo].[WT] SET [wt_PID]="+UD.Next_PID+", [wt_OrderNum] = '" + UD.Next_Num + "' WHERE [wt_ID]=" + UD.Next_ID;
//SqlParameter[] commandParameters = new SqlParameter[]{ };
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, null);
if (flg == 2)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改试题
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_ST(DanXuan DX)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WT]
SET [wt_Title] = @wt_Title,
[wt_LimitTime]=@wt_LimitTime,
[wt_Type]=@wt_Type,
[wt_Problem]=@wt_Problem,
[wt_Options]= @wt_Options WHERE [wt_ID]=@wt_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wt_Title",DX.wt_Title),
new SqlParameter("@wt_LimitTime",DX.wt_LimitTime),
new SqlParameter("@wt_Type",DX.wt_Type),
new SqlParameter("@wt_Problem",SqlDbType.VarChar,400){Value=DX.wt_Problem},
new SqlParameter("@wt_Options",SqlDbType.VarChar,4000){Value=DX.wt_Options},
new SqlParameter("@wt_ID",DX.wt_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改分组
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_Group(Total_Group DX)
{
JsMessage js = new JsMessage();
// string SqlStr = @" UPDATE [dbo].[Total_Group]
// SET [GroupName]= @GroupName,
// [WJID] = @WJID,
// [IDValue] = @IDValue,
// WHERE ID=@ID ";
string SqlStr = @" UPDATE [dbo].[Total_Group]
SET [IDValue] = @IDValue
WHERE ID=@ID ";
SqlParameter[] commandParameters = new SqlParameter[]{
//new SqlParameter("@GroupName",SqlDbType.NVarChar,50){Value=DX.GroupName},
//new SqlParameter("@WJID",DX.WJID),
new SqlParameter("@IDValue",DX.IDValue),
new SqlParameter("@ID",DX.ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 删除问卷
/// </summary>
/// <param name="q"></param>
/// <returns></returns>
public static JsMessage Del_WJ(QuestionInfo q)
{
JsMessage js = new JsMessage();
string SqlStr = "DELETE FROM [dbo].[WJ] WHERE [wj_ID]=" + q.wj_ID + " ; DELETE FROM [dbo].[WT] WHERE [wt_WJID]=" + q.wj_ID + "; DELETE FROM [dbo].[AnswerUserInfo] WHERE [au_wjID]=" + q.wj_ID;
//SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@wt_ID", ID) };
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, null);
js.IsSuccess = true;
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
/*
* UPDATE [dbo].[AccountManage] SET [am_LoginUser] ='' ,[am_PWD] =,
[am_Email] = '',
[am_Name] ='',
[am_Phone] = '',
[am_Status] = '',
[am_CreateTime] = ''
WHERE [am_ID]=@am_ID
*/
public static JsMessage Modify_Userinfo(UserInfo u)
{
JsMessage js = new JsMessage();
string SqlStr = "UPDATE [dbo].[AccountManage] SET [am_LoginUser] =@am_LoginUser,[am_Email] =@am_Email WHERE [am_ID]=@am_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_LoginUser",u.U_LoginName),
new SqlParameter("@am_Email",u.U_Email),
new SqlParameter("@am_ID",u.U_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public ActionResult ResetPwd(int ID)
{
JsMessage jm = new JsMessage();
string ResultStr = string.Empty;
jm = Sql_AccounrManage.ResetPwd(ID);
ResultStr = JsonTool.ObjToJson(jm);
return Content(ResultStr);
}
public ActionResult Validate_Code(int wjid, string code)
{
JsMessage jm = new JsMessage();
DataTable dt = SqlStr_Process.GetWJByID_Answer(wjid);
string ResultStr = string.Empty;
if (dt != null)
{
if (dt.Rows.Count == 1)
{
string temp = dt.Rows[0]["wj_Number"].ToString();
if (code == temp)
{
jm.IsSuccess = true;
}
else {
jm.IsSuccess = false;
jm.ErrorMsg = "认证码不匹配";
}
}
else {
jm.IsSuccess = false;
jm.ErrorMsg = "问卷不存在";
}
}
else
{
jm.IsSuccess = false;
jm.ErrorMsg = "问卷不存在";
}
ResultStr = JsonTool.ObjToJson(jm);
return Content(ResultStr);
}