/// <summary>
/// 满足条件的提交。
/// </summary>
/// <param name="m"></param>
public static void CommitReport(Member m)
{
var report = DAL.Get.Report(m.MID);
MemCache.Save("Report_Status", report.Status);
MemCache.Save("Report_Compulsory", report.Compulsory);
MemCache.Save("Report_Elective", report.Elective);
MemCache.Save("Report_Score", report.Score);
MemCache.Save("Learning_Finish", 0);
var r = DAL.Task.CommitReport(m, report);
if (r.Code == 0 && r.Value == 1)
{
MemCache.Save("Report_Status", 1);
}
if (m.Year >= 2012)
{
if (report.Score >= 60 && (report.Compulsory + report.Elective) * 45 >= 1080)
{
MemCache.Save("Learning_Finish", 1);
}
}
else
{
if ((report.Compulsory + report.Elective) * 45 >= 1080)
{
MemCache.Save("Learning_Finish", 1);
}
}
}
new public static R Member(Member member)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",member.MID),
new SqlParameter("@Login",member.Login),
new SqlParameter("@Password",member.Password),
new SqlParameter("@Name",member.Name),
new SqlParameter("@IDCard",member.IDCard),
new SqlParameter("@IDSN",member.IDSN),
new SqlParameter("@Year",member.Year),
new SqlParameter("@Type",member.Type),
new SqlParameter("@Level",member.Level),
new SqlParameter("@Phone",member.Phone),
new SqlParameter("@RegionCode",member.RegionCode),
new SqlParameter("@RegionName",member.RegionName)
};
param[0].Direction = ParameterDirection.InputOutput;
var r = SqlHelper.ExecuteNonQuery(SqlHelper.Local, CommandType.StoredProcedure, "Update_Member", param);
m.Code = 0;
m.Value = Convert.ToInt32(param[0].Value);
m.Message = "sucess";
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
public static R CheckAPI(string loginID, string loginPWD)
{
R r = new R();
var param = new ProveParams();
param.certId = loginPWD;
param.orderId = loginID;
var prove = Teach.TeachProveAction(param);
if (prove.proveValue == "prove000")
{
var member = new Member();
member.MID = 0;
member.Name = prove.personName;
member.Year = Convert.ToInt32(prove.yearValue);
member.IDCard = loginPWD;
member.IDSN = loginID;
member.Level = -1;
member.Type = -1;
member.Phone = prove.telValue;
r = Update.Member(member);
}
else
{
r.Code = 202;
r.Message = string.Format("{0}",prove.proveValue);
r.Value = -1;
log.Warn("{0},{1},{2}", loginID, loginPWD, prove.proveValue);
}
return r;
}
private R IsApiCheck(Member member)
{
var rx = new R();
var param = new API.GuangdongParams1();
param.cardNumber = member.IDCard;
param.compId = member.IDCert;
param.compName = member.Name;
param.areaName = member.City;
var r = API.Guangdong.compProve(param);
if (r.ResponseCode == "ZT000")
{
rx.Code = 0;
rx.Message = r.ResponseCode;
}
else
{
rx.Code = 104;
rx.Message = r.ResponseCode;
if (!string.IsNullOrEmpty(rx.Message))
{
if (rx.Message.Length > 20)
{
rx.Message = rx.Message.Substring(0, 20);
}
}
}
return rx;
}
public static R CommitReport(Member m, Report re)
{
var r = new R();
try
{
if (re.Status == 0)
{
var para = new AnnalParams();
para.certId = m.IDCard;
para.orderId = m.IDSN;
para.credits = "";
para.classHour = "24";
para.startTeachDate = m.RegDate.ToString("yyyy-MM-dd");
para.endTeachDate = DateTime.Now.ToString("yyyy-MM-dd");
para.isPass = "******";
if (m.Year >= 2012)
{
if (re.Score >= 60 && (re.Elective + re.Compulsory) * 45 >= 1080)
{
para.isPass = "******";
}
}
else
{
if ((re.Elective + re.Compulsory) * 45 >= 1080)
{
para.isPass = "******";
}
}
//已完成学习
if (para.isPass == "Pass")
{
var ps = Teach.TeachAnnalAction(para);
if (ps.annalValue == "annal000" || ps.annalValue == "annal003")
{
re.Status = 1;
DAL.Update.Report(re);
r.Value = 1;
r.Message = "success";
r.Code = 0;
}
else
{
log.Warn("{0},{1},{2}", ps.annalValue, ps.personName, ps.yearValue);
}
}
}
}
catch (Exception ex)
{
log.Fatal("{0},{1}", ex.Message, ex.StackTrace);
}
return r;
}
public ActionResult hooyes_compProve(Member member)
{
var param = new API.GuangdongParams1();
param.cardNumber = member.IDCard;
param.compId = member.IDCert;
param.compName = member.Name;
param.areaName = member.City;
var r = API.Guangdong.compProve(param);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult Add(Member member)
{
var r = new R();
try
{
if (!Regex.IsMatch(member.IDCard, @"^\d{6}(19|20)\d{2}([0][1-9]|10|11|12)([0,1,2][0-9]|[3][0,1])\d{3}([0-9]|X|x)$"))
{
r.Code = 101;
r.Message = "IDCard Error";
return Json(r);
}
if (!Regex.IsMatch(member.Phone, @"^1[3|4|5|7|8][0-9]\d{8}$"))
{
r.Code = 102;
r.Message = "Phone Error";
return Json(r);
}
if (!IsCanSignup(member.IDCard))
{
r.Code = 103;
r.Message = " IDCard Exist";
return Json(r);
}
var rx = IsApiCheck(member);
if (rx.Code != 0)
{
r.Code = rx.Code;
r.Message = rx.Message;
return Json(r);
}
if (r.Code == 0)
{
member.Login = member.IDCard;
if (string.IsNullOrEmpty(member.Password))
{
member.Password = member.Name;
}
r = DAL.Update.Member(member);
}
}
catch (Exception ex)
{
r.Code = 401;
r.Message = "System Error";
log.Error("{0},{1}", ex.Message, ex.StackTrace);
}
return Json(r);
}
public static Member Member(int MID)
{
var m = new Member();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",MID)
};
var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_Member", param);
if (dr.Read())
{
m.Code = 0;
m.MID = MID;
m.Name = Convert.ToString(dr["Name"]);
m.Login = Convert.ToString(dr["Login"]);
m.Password = Convert.ToString(dr["Password"]);
m.Year = Convert.ToInt32(dr["Year"]);
m.IDCard = Convert.ToString(dr["IDCard"]);
m.IDSN = Convert.ToString(dr["IDSN"]);
m.Level = Convert.ToInt32(dr["Level"]);
m.Type = Convert.ToInt32(dr["Type"]);
m.Phone = Convert.ToString(dr["Phone"]);
if (dr["RegionCode"] != DBNull.Value)
m.RegionCode = Convert.ToInt32(dr["RegionCode"]);
if (dr["RegionName"] != DBNull.Value)
m.RegionName = Convert.ToString(dr["RegionName"]);
if (dr["RegDate"] != DBNull.Value)
m.RegDate = Convert.ToDateTime(dr["RegDate"]);
if (dr["IDCert"] != DBNull.Value)
m.IDCert = Convert.ToString(dr["IDCert"]);
if (dr["Company"] != DBNull.Value)
m.Company = Convert.ToString(dr["Company"]);
}
else
{
m.Code = 101;
m.Message = "no records";
}
dr.Close();
}
catch (Exception ex)
{
m.Code = 300;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
public ActionResult Add(Member member)
{
var r = new R();
try
{
if (!Regex.IsMatch(member.IDCard, @"^\d{6}(19|20)\d{2}([0][1-9]|10|11|12)([0,1,2][0-9]|[3][0,1])\d{3}([0-9]|X|x)$"))
{
r.Code = 101;
r.Message = "IDCard Error";
return Json(r);
}
if (!Regex.IsMatch(member.Phone, @"^1[3|4|5|7|8][0-9]\d{8}$"))
{
r.Code = 102;
r.Message = "Phone Error";
return Json(r);
}
if (!IsCanSignup(member.IDCard))
{
r.Code = 103;
r.Message = " IDCard Exist";
return Json(r);
}
if (r.Code == 0)
{
member.Login = member.IDCard;
//member.Password = member.Name;
r = DAL.Update.Member(member);
////member ext
//var ext = new MemberExt();
//ext.MID = r.Value;
//ext.PID = 2014;
//ext.IDSN = "";
//ext.Flag = 10;
//DAL.Update.Member(ext);
}
}
catch (Exception ex)
{
r.Code = 401;
r.Message = "System Error";
log.Error("{0},{1}", ex.Message, ex.StackTrace);
}
return Json(r);
}
public ActionResult AddMember(string Name, string IDCard, int RegionCode)
{
var member = new Member();
member.MID = 0;
member.Name = Name;
member.Login = IDCard;
member.Password = Name;
member.IDCard = IDCard;
member.RegionCode = RegionCode;
member.IDSN = "0";
member.Phone = "0";
var r = DAL.Update.Member(member);
string Url = string.Format("{0}/Master/ViewMember?MID={1}", C.APP, r.Value);
Response.Redirect(Url);
return Content(string.Empty);
}
public static R Profiles(Member member)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",member.MID),
new SqlParameter("@IDCert",member.IDCert),
//new SqlParameter("@Name",member.Name),
new SqlParameter("@Level",member.Level),
new SqlParameter("@Phone",member.Phone),
new SqlParameter("@Gender",member.Gender),
new SqlParameter("@Company",member.Company),
new SqlParameter("@Email",member.Email),
new SqlParameter("@Address",member.Address),
new SqlParameter("@Zip",member.Zip),
new SqlParameter("@Job",member.Job)
};
string SQL = @"UPDATE [dbo].[Member]
SET [IDCert]= @IDCert
,[Level] = @Level
,[Phone] = @Phone
,[Gender] = @Gender
,[Company] = @Company
,[Email] = @Email
,[Address] = @Address
,[Zip] = @Zip
,[Job] = @Job
WHERE MID = @MID";
var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.Text, SQL, param);
m.Code = 0;
m.Message = "success";
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal("{0},{1}", ex.Message, ex.StackTrace);
}
return m;
}
public static R MemberPhoto(Member member)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",member.MID),
new SqlParameter("@Photo",member.Photo)
};
var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.StoredProcedure, "Update_MemberPhoto", param);
m.Code = 0;
m.Message = "success";
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
public ActionResult Setting(int Type, string Phone, string phonecode)
{
var r = API.SMSx.ValidateCode(phonecode);
if (r.Code == 0)
{
r = DAL.Get.CheckPhone(Client.MID, Client.Year, Phone);
if (r.Code == 0)
{
var m = new Member();
m.MID = Client.MID;
m.Phone = Phone;
m.Type = Type;
r = DAL.Update.Setting(m);
if (r.Code == 0)
{
U.SetLoginSession(Client.MID);
}
API.SMSx.ClearPhoneCode();
}
}
return Json(r);
}
public static List<Member> Member()
{
var l = new List<Member>();
try
{
SqlParameter[] param =
{
};
var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_MemberList", param);
while (dr.Read())
{
var m = new Member();
m.Code = 0;
m.ID = Convert.ToInt32(dr["ID"]);
m.MID = Convert.ToInt32(dr["MID"]);
m.Name = Convert.ToString(dr["Name"]);
m.Year = Convert.ToInt32(dr["Year"]);
m.IDCard = Convert.ToString(dr["IDCard"]);
m.IDSN = Convert.ToString(dr["IDSN"]);
m.Level = Convert.ToInt32(dr["Level"]);
m.Type = Convert.ToInt32(dr["Type"]);
m.Phone = Convert.ToString(dr["Phone"]);
l.Add(m);
}
dr.Close();
}
catch (Exception ex)
{
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return l;
}
public static R Profiles_10371(Member member)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",member.MID),
new SqlParameter("@IDCert",member.IDCert),
new SqlParameter("@IDCard",member.IDCard),
new SqlParameter("@Level",member.Level),
new SqlParameter("@Phone",member.Phone),
new SqlParameter("@Gender",member.Gender),
new SqlParameter("@Company",member.Company),
new SqlParameter("@Email",member.Email),
new SqlParameter("@Address",member.Address),
new SqlParameter("@Zip",member.Zip),
new SqlParameter("@Job",member.Job),
new SqlParameter("@City",member.City),
new SqlParameter("@Birthday",member.Birthday),
new SqlParameter("@Race",member.Race),
new SqlParameter("@Education",member.Education),
new SqlParameter("@Degree",member.Degree),
new SqlParameter("@Major",member.Major)
};
string SQL = @"UPDATE [dbo].[Member]
SET [IDCert]= @IDCert
,[IDCard]= @IDCard
,[Level] = @Level
,[Phone] = @Phone
,[Gender] = @Gender
,[Company] = @Company
,[Email] = @Email
,[Address] = @Address
,[Zip] = @Zip
,[Job] = @Job
,[City] = @City
,[Birthday] = @Birthday
,[Race] = @Race
,[Education] = @Education
,[Degree] = @Degree
,[Major] = @Major
WHERE MID = @MID";
var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.Text, SQL, param);
m.Code = 0;
m.Message = "success";
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal("{0},{1}", ex.Message, ex.StackTrace);
}
return m;
}
public ActionResult Profiles(Member member)
{
var r = new R();
try
{
member.MID = Client.MID;
member.RegionCode = Client.RegionCode;
if (!Regex.IsMatch(member.Phone, @"^1[3|4|5|7|8][0-9]\d{8}$"))
{
r.Code = 102;
r.Message = "Phone Error";
return Json(r);
}
if (r.Code == 0)
{
switch (member.RegionCode)
{
case 10371:
r = DAL.Update.Profiles_10371(member);
break;
default:
r = DAL.Update.Profiles(member);
break;
}
}
}
catch (Exception ex)
{
r.Code = 401;
r.Message = "System Error";
log.Error("{0},{1}", ex.Message, ex.StackTrace);
}
return Json(r);
}
public static R Setting(Member member)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",member.MID),
new SqlParameter("@Type",member.Type),
new SqlParameter("@Phone",member.Phone)
};
var r = SqlHelper.ExecuteNonQuery(SqlHelper.Local, CommandType.StoredProcedure, "Update_Setting", param);
m.Code = 0;
m.Value = 0;
m.Message = "sucess";
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
public ActionResult UpdatePhone2(string Phone, string phonecode)
{
var r = DAL.Get.CheckPhone(Client.MID, Client.Year, Phone);
if (r.Code == 0)
{
var m = new Member();
m.MID = Client.MID;
m.Phone = Phone;
m.Type = Client.Type;
r = DAL.Update.Setting(m);
if (r.Code == 0)
{
U.SetLoginSession(Client.MID);
}
}
return Json(r);
}
public ActionResult UpdateMember(Member member)
{
var r = DAL.Update.Member(member);
return Json(r);
}
public ActionResult ReceiveAcctInfo(string seq_num, string user_name, string card_id, string department_code)
{
string result = "1"; // Api Return 1 Success , 0 Fail
var member = new Member();
var logResult = new R();
logResult.Code = -1;
string ip = Request.UserHostAddress;
int MID = 0;
try
{
if (!string.IsNullOrEmpty(seq_num) && !string.IsNullOrEmpty(user_name) && !string.IsNullOrEmpty(card_id) && !string.IsNullOrEmpty(department_code))
{
member.IDSN = "0";
member.Name = Cipher.Decrypt(user_name);
member.IDCard = Cipher.Decrypt(card_id);
member.RegionCode = Cipher.Decrypt(department_code);
member.Login = member.IDCard;
member.Password = member.Name;
if (!string.IsNullOrEmpty(member.Login) && !string.IsNullOrEmpty(member.Password) && !string.IsNullOrEmpty(member.IDSN))
{
// Check MID
var r1 = DAL.Login.Check(member.Login);
if (r1.Code == 0)
{
MID = r1.Value; // Login Exists
}
// Signup
if (MID == 0)
{
var r2 = DAL.Update.Member(member);
if (r2.Code != 0)
{
result = "0";
}
else
{
MID = r2.Value;
}
logResult.Message = logResult.Message + string.Format("->R2-{0}:{1}", r2.Code, r2.Message);
}
// IDSN Append!
if (MID > 0)
{
var memberExt = new MemberExt();
memberExt.MID = MID;
memberExt.IDSN = Cipher.Decrypt(seq_num);
memberExt.Year = Convert.ToInt32(memberExt.IDSN.Substring(0, 4));
memberExt.Flag = 10;
var r3 = DAL.Update.Member(memberExt);
if (r3.Code != 0)
{
result = "0";
}
logResult.Message = logResult.Message + string.Format("->R3-{0}:{1}", r3.Code, r3.Message);
}
}
else
{
logResult.Code = 101;
logResult.Message = "parameters error";
}
}
}
catch (Exception ex)
{
result = "0";
logResult.Code = 300;
logResult.Message = string.Format("-->Ex-{0},{1}", ex.Message, ex.StackTrace);
}
finally
{
if (result == "1")
{
log.Info("IP:{0}", ip);
log.Info("S:{0},{1},{2},{3}", seq_num, user_name, card_id, department_code);
log.Info("P:{0},{1},{2},{3}", member.IDSN, member.Name, member.IDCard, member.RegionCode);
log.Info("{0},{1}", logResult.Code, logResult.Message);
}
else
{
log.Warn("IP:{0}", ip);
log.Warn("S:{0},{1},{2},{3}", seq_num, user_name, card_id, department_code);
log.Warn("P:{0},{1},{2},{3}", member.IDSN, member.Name, member.IDCard, member.RegionCode);
log.Warn("{0},{1}", logResult.Code, logResult.Message);
}
}
return Content(result);
}
public static R Member2(Member member)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@Code",0),
new SqlParameter("@Message",SqlDbType.VarChar,200),
new SqlParameter("@MID",member.MID),
new SqlParameter("@Phone",member.Phone),
new SqlParameter("@RegionCode",member.RegionCode),
new SqlParameter("@IDCert",member.IDCert),
new SqlParameter("@Company",member.Company),
new SqlParameter("@Level",member.Level)
};
param[0].Direction = ParameterDirection.Output;
param[1].Direction = ParameterDirection.Output;
var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.StoredProcedure, "Update_Member_2", param);
m.Code = Convert.ToInt32(param[0].Value);
m.Message = Convert.ToString(param[1].Value);
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
public static R Member(string excelPath)
{
var r = new R();
var ds = PreviewMember(excelPath);
var dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
var member = new Member();
member.MID = 0;
member.Login = Convert.ToString(dr["Login"]);
member.Password = Convert.ToString(dr["Password"]);
member.Name = Convert.ToString(dr["Name"]);
member.IDCard = Convert.ToString(dr["IDCard"]);
member.RegionCode = Convert.ToInt32(dr["RegionCode"]);
member.IDSN = "0";
member.Phone = Convert.ToString(dr["Phone"]);
DAL.BaseUpdate.Member(member);
}
return r;
}
