public static CloudHealthDto GetOneCloudHealthDto(string table,string strwhere) { CloudHealthDto cloudHealthDto=new CloudHealthDto(); cloudHealthDto = CloudHealthDal.GetOneCloudHealth(table, strwhere); return cloudHealthDto; }
public static void AddCloudHealth(CloudHealthDto cloudHealthDto) { SqlParameter[] arParames = CloudHealthDal.getParameters(cloudHealthDto); SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString); try { SqlHelper.ExecuteNonQuery(myconn, CommandType.StoredProcedure, "CreateCloudHealth", arParames); } catch (SqlException ex) { throw ex; } finally { myconn.Close(); myconn.Dispose(); } }
public static List<CloudHealthDto> GetCloudHealthList(string table,string strwhere) { List<CloudHealthDto> cloudHealthlist = new List<CloudHealthDto>(); SqlParameter[] arParames = new SqlParameter[2]; arParames[0] = new SqlParameter("@table ", SqlDbType.VarChar, 200); arParames[0].Value = table; arParames[1] = new SqlParameter("@Where ", SqlDbType.VarChar, 8000); arParames[1].Value = strwhere; SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString); try { DataTable dt = null; DataSet ds = SqlHelper.ExecuteDataset(myconn, CommandType.StoredProcedure, "getModelByWhere", arParames); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { CloudHealthDto cloudHealthDto = new CloudHealthDto(); cloudHealthDto = CloudHealthDal.getDataRowToCloudHealthDto(dr); cloudHealthlist.Add(cloudHealthDto); } return cloudHealthlist; } catch (SqlException ex) { throw ex; } finally { myconn.Close(); myconn.Dispose(); } }
// // GET: /Cloud/ public ActionResult Index(string imei, string tel, string user, string sys, string dia, string pul) { if (string.IsNullOrEmpty(imei) || string.IsNullOrEmpty(tel) || string.IsNullOrEmpty(user) || string.IsNullOrEmpty(sys) || string.IsNullOrEmpty(dia) || string.IsNullOrEmpty(pul)) { return Content("OK" + System.DateTime.Now.ToString("yyyyMMddhhmmss")); } else { CloudHealthDto cloudHealthDto = new CloudHealthDto(); cloudHealthDto.CloudTel = tel; cloudHealthDto.CloudDiya = dia; cloudHealthDto.CloudGaoya = sys; cloudHealthDto.CloudMaibo = pul; cloudHealthDto.CloudUser = user; cloudHealthDto.CloudImei = imei; cloudHealthDto.CloudTime = System.DateTime.Now; CloudHealthBll.AddCloudHealth(cloudHealthDto); Xueya.sendMsg("赵征", sys, dia, pul); } return Content("OK"+System.DateTime.Now.ToString("yyyyMMddhhmmss")); }
public static void UpdateCloudHealthDto(CloudHealthDto cloudHealthDto) { CloudHealthDal.UpdateCloudHealth(cloudHealthDto); }
public static void AddCloudHealth(CloudHealthDto cloudHealthDto) { CloudHealthDal.AddCloudHealth(cloudHealthDto); }
private static SqlParameter[] getParameters(CloudHealthDto cloudHealthDto) { SqlParameter[] arParames = new SqlParameter[8]; arParames[0] = new SqlParameter("@CloudId", SqlDbType.Int); arParames[0].Value = cloudHealthDto.CloudId; arParames[1] = new SqlParameter("@CloudDiya", SqlDbType.VarChar, 50); arParames[1].Value = cloudHealthDto.CloudDiya; arParames[2] = new SqlParameter("@CloudGaoya", SqlDbType.VarChar, 50); arParames[2].Value = cloudHealthDto.CloudGaoya; arParames[3] = new SqlParameter("@CloudMaibo", SqlDbType.VarChar, 50); arParames[3].Value = cloudHealthDto.CloudMaibo; arParames[4] = new SqlParameter("@CloudTel", SqlDbType.VarChar, 50); arParames[4].Value = cloudHealthDto.CloudTel; arParames[5] = new SqlParameter("@CloudImei", SqlDbType.VarChar, 50); arParames[5].Value = cloudHealthDto.CloudImei; arParames[6] = new SqlParameter("@CloudUser", SqlDbType.VarChar, 50); arParames[6].Value = cloudHealthDto.CloudUser; arParames[7] = new SqlParameter("@CloudTime", SqlDbType.DateTime); arParames[7].Value = cloudHealthDto.CloudTime; return arParames; }
private static CloudHealthDto getDataRowToCloudHealthDto(DataRow dr) { CloudHealthDto cloudHealthDto = new CloudHealthDto(); cloudHealthDto.CloudId = int.Parse(dr["CloudHealthId"].ToString()); cloudHealthDto.CloudTel = dr["CloudHealthUserName"].ToString(); cloudHealthDto.CloudDiya = dr["CloudHealthRealName"].ToString(); cloudHealthDto.CloudGaoya = dr["CloudHealthPassword"].ToString(); cloudHealthDto.CloudMaibo = dr["CloudHealthPassword"].ToString(); cloudHealthDto.CloudImei = dr["CloudHealthPassword"].ToString(); cloudHealthDto.CloudUser = dr["CloudHealthPassword"].ToString(); cloudHealthDto.CloudTime = DateTime.Parse(dr["CloudHealthRegTime"].ToString()); return cloudHealthDto; }