public int Comfirm_Smar1(Smar request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { if (request.UpdateAllString != null && request.UpdateAllString != "") { JArray ja = (JArray)JsonConvert.DeserializeObject(request.UpdateAllString); if (ja != null) { for (int i = 0; i < ja.Count(); i++) { string strSql = ""; string PhoneNumber = ja[i]["PhoneNumber"].ToString(); string PassWord = ja[i]["PassWord"].ToString(); string YogaStudioName = ja[i]["YogaStudioName"].ToString(); string Sex = ja[i]["Sex"].ToString(); string Remark = ja[i]["Remark"].ToString(); string AreaCode = ja[i]["AreaCode"].ToString(); strSql = "insert into Samr1( " + " YogaStudioName," + " AreaCode," + " Sex," + " Remark ," + " PhoneNumber ," + " PassWord ," + " CreateDateTime," + " UpdateDateTime" + " )" + "values( " + Modfunction.SQLSafeValue(YogaStudioName) + "," + Modfunction.SQLSafeValue(AreaCode) + "," + Modfunction.SQLSafeValue(Sex) + "," + Modfunction.SQLSafeValue(Remark) + "," + Modfunction.SQLSafeValue(PhoneNumber) + "," + Modfunction.SQLSafeValue(PassWord) + "," + "GETDATE()," + "GETDATE()" + ") "; db.ExecuteSql(strSql); } Result = 1; } } } } catch { throw; } return(Result); }
public List <Samr1> LoginCheck(Smar request) { List <Samr1> Result = null; try { using (var db = DbConnectionFactory.OpenDbConnection("Yoga")) { string strSql = ""; if (request.PhoneNumber != null && request.PhoneNumber.Length > 0 && request.PassWord != null && request.PassWord.Length > 0) { strSql = "Select isnull(PhoneNumber,'') as PhoneNumber ,isnull(PassWord,'') as PassWord From Samr1 Where PhoneNumber='" + request.PhoneNumber + "' And PassWord ='******' "; Result = db.Select <Samr1>(strSql); } } } catch { throw; } return(Result); }