/// <summary> /// 验证数据的合法性 /// </summary> /// <param name="model"></param> /// <returns></returns> private string CheckAddInfor(MTFCEvidenceInfor model) { if (string.IsNullOrEmpty(model.userName)) { return("姓名必填!"); } if (string.IsNullOrEmpty(model.telNum)) { return("手机号码必填!"); } if (!PublicTools.CheckIsPhonNum(model.telNum)) { return("手机号码格式有误!"); } //// 检查手机号码是否已经被使用 if (new TFCEvidenceInforService().CheckPhonHasUser(model.telNum) > 0) { return("该手机号码已经提交过数据!"); } if (string.IsNullOrEmpty(model.roomNum)) { return("房号必填!"); } if (model.payAmount <= 0) { return("金额必填,且必须为正数!"); } if (string.IsNullOrEmpty(model.payDate)) { return("购买日期必填!"); } return(string.Empty); }
/// <summary> /// 新增平台用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(MTFCEvidenceInfor model) { MwxResult mwxResult = new MwxResult() { errcode = -1 }; try { //// 数据合法性检查 string checkResult = this.CheckAddInfor(model); if (!string.IsNullOrEmpty(checkResult)) { mwxResult.errmsg = checkResult; } else { //// 时间相关参数赋值 model.great_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.Id = PublicTools.GetRandomNumberByTime(); //// 数据落地入库 if (!new TFCEvidenceInforService().Add(model)) { mwxResult.errmsg = "提交失败"; } else { mwxResult.errcode = 0; mwxResult.errmsg = "提交成功"; } } } catch (Exception) { mwxResult.errmsg = "提交失败:系统异常!"; } return(JsonHelper.GetJson <MwxResult>(mwxResult)); }
/// <summary> /// 根据id获取信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public MTFCEvidenceInfor GetInfoById(string id) { string sql = "select amountType,Id,userName,telNum,buildNum,roomNum,thirdPartyCompanyName,payAmount,payDate,domicile,evidences,great_time from TFCEvidenceInfor where id=@id;"; List <SqlParameter> parameterList = new List <SqlParameter>(); SqlParameter parameter = new SqlParameter("@id", SqlDbType.VarChar, 25); parameter.Value = id; parameterList.Add(parameter); using (SqlDataReader sqlDataReader = SqlHelper.ExecuteReader(sql, parameterList.ToArray())) { if (sqlDataReader != null) { if (sqlDataReader.Read()) { MTFCEvidenceInfor model = new MTFCEvidenceInfor(); model.Id = sqlDataReader["Id"] != DBNull.Value ? sqlDataReader["Id"].ToString() : string.Empty; model.userName = sqlDataReader["userName"] != DBNull.Value ? sqlDataReader["userName"].ToString() : string.Empty; model.telNum = sqlDataReader["telNum"] != DBNull.Value ? sqlDataReader["telNum"].ToString() : string.Empty; model.buildNum = sqlDataReader["buildNum"] != DBNull.Value ? sqlDataReader["buildNum"].ToString() : string.Empty; model.roomNum = sqlDataReader["roomNum"] != DBNull.Value ? sqlDataReader["roomNum"].ToString() : string.Empty; model.thirdPartyCompanyName = sqlDataReader["thirdPartyCompanyName"] != DBNull.Value ? sqlDataReader["thirdPartyCompanyName"].ToString() : string.Empty; model.payAmount = sqlDataReader["payAmount"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["payAmount"].ToString()) : 0; model.payDate = sqlDataReader["payDate"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["payDate"]).ToString("yyyy-MM-dd") : "1900-01-01"; model.domicile = sqlDataReader["domicile"] != DBNull.Value ? sqlDataReader["domicile"].ToString() : string.Empty; model.evidences = sqlDataReader["evidences"] != DBNull.Value ? sqlDataReader["evidences"].ToString() : string.Empty; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()).ToString("yyyy-MM-dd") : "1900-01-01"; model.amountType = sqlDataReader["amountType"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["amountType"].ToString()):1; return(model); } } } return(null); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(MTFCEvidenceInfor model) { return(opertService.Add(model)); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(MTFCEvidenceInfor model) { //// sql语句 string sql = "INSERT INTO TFCEvidenceInfor(amountType,Id,userName,telNum,buildNum,roomNum,thirdPartyCompanyName,payAmount,payDate,domicile,evidences,great_time) " + "VALUES (@amountType,@Id,@userName,@telNum,@buildNum,@roomNum,@thirdPartyCompanyName,@payAmount,@payDate,@domicile,@evidences,@great_time)"; List <SqlParameter> parameterList = new List <SqlParameter>(); SqlParameter parameter = new SqlParameter("@Id", SqlDbType.VarChar, 25); parameter.Value = model.Id; parameterList.Add(parameter); parameter = new SqlParameter("@userName", SqlDbType.NVarChar, 50); parameter.Value = model.userName; parameterList.Add(parameter); parameter = new SqlParameter("@telNum", SqlDbType.NVarChar, 25); parameter.Value = model.telNum; parameterList.Add(parameter); parameter = new SqlParameter("@buildNum", SqlDbType.NVarChar, 25); parameter.Value = model.buildNum; parameterList.Add(parameter); parameter = new SqlParameter("@roomNum", SqlDbType.NVarChar, 25); parameter.Value = model.roomNum; parameterList.Add(parameter); parameter = new SqlParameter("@thirdPartyCompanyName", SqlDbType.NVarChar, 100); parameter.Value = model.thirdPartyCompanyName; parameterList.Add(parameter); parameter = new SqlParameter("@payAmount", SqlDbType.Decimal); parameter.Value = model.payAmount; parameterList.Add(parameter); parameter = new SqlParameter("@payDate", SqlDbType.DateTime); parameter.Value = model.payDate; parameterList.Add(parameter); parameter = new SqlParameter("@domicile", SqlDbType.NVarChar, 50); parameter.Value = model.domicile; parameterList.Add(parameter); parameter = new SqlParameter("@evidences", SqlDbType.NVarChar, 100); parameter.Value = model.evidences; parameterList.Add(parameter); DateTime dateTime = System.DateTime.Now; parameter = new SqlParameter("@great_time", SqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); parameter = new SqlParameter("@amountType", SqlDbType.Int); parameter.Value = model.amountType < 1?1: model.amountType; parameterList.Add(parameter); //// 执行操作 return(SqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 获取产品数据总条数 /// </summary> /// <param name="classid"></param> /// <param name="supclassid"></param> /// <param name="productname"></param> /// <param name="shelfstate"></param> /// <returns></returns> public List <MTFCEvidenceInfor> GetInfoPagList(int pagIndex, int pagCount, string userName, string buildNum, string amountType) { string sql = " SELECT TOP " + pagCount * pagIndex + " amountType,Id,userName,telNum,buildNum,roomNum,thirdPartyCompanyName,payAmount,payDate,domicile,evidences,great_time " + " FROM( SELECT ROW_NUMBER() OVER(ORDER BY buildNum asc, roomNum asc ) AS ROWID,* FROM [TFCEvidenceInfor]) AS TEMP1 WHERE ROWID> " + pagCount * (pagIndex - 1); if (!string.IsNullOrEmpty(userName)) { sql = sql + " and userName like @userName"; } if (!string.IsNullOrEmpty(buildNum) && buildNum != "0") { sql = sql + " and buildNum = @buildNum"; } if (!string.IsNullOrEmpty(amountType) && amountType != "0") { sql = sql + " and amountType = @amountType"; } List <SqlParameter> parameterList = new List <SqlParameter>(); SqlParameter parameter = new SqlParameter("@userName", SqlDbType.NVarChar, 50); parameter.Value = "%" + userName + "%"; parameterList.Add(parameter); parameter = new SqlParameter("@buildNum", SqlDbType.NVarChar, 25); parameter.Value = buildNum; parameterList.Add(parameter); parameter = new SqlParameter("@amountType", SqlDbType.Int); parameter.Value = amountType; parameterList.Add(parameter); List <MTFCEvidenceInfor> listModel = null; using (SqlDataReader sqlDataReader = SqlHelper.ExecuteReader(sql, parameterList.ToArray())) { if (sqlDataReader != null) { listModel = new List <MTFCEvidenceInfor>(); while (sqlDataReader.Read()) { MTFCEvidenceInfor model = new MTFCEvidenceInfor(); model.Id = sqlDataReader["Id"] != DBNull.Value ? sqlDataReader["Id"].ToString() : string.Empty; model.userName = sqlDataReader["userName"] != DBNull.Value ? sqlDataReader["userName"].ToString() : string.Empty; model.telNum = sqlDataReader["telNum"] != DBNull.Value ? sqlDataReader["telNum"].ToString() : string.Empty; model.buildNum = sqlDataReader["buildNum"] != DBNull.Value ? sqlDataReader["buildNum"].ToString() : string.Empty; model.roomNum = sqlDataReader["roomNum"] != DBNull.Value ? sqlDataReader["roomNum"].ToString() : string.Empty; model.thirdPartyCompanyName = sqlDataReader["thirdPartyCompanyName"] != DBNull.Value ? sqlDataReader["thirdPartyCompanyName"].ToString() : string.Empty; model.payAmount = sqlDataReader["payAmount"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["payAmount"].ToString()) : 0; model.payDate = sqlDataReader["payDate"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["payDate"]).ToString("yyyy-MM-dd") : "1900-01-01"; model.domicile = sqlDataReader["domicile"] != DBNull.Value ? sqlDataReader["domicile"].ToString() : string.Empty; model.evidences = sqlDataReader["evidences"] != DBNull.Value ? sqlDataReader["evidences"].ToString() : string.Empty; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()).ToString("yyyy-MM-dd") : "1900-01-01"; model.amountType = sqlDataReader["amountType"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["amountType"].ToString()) : 1; listModel.Add(model); } } } return(listModel); }
public string addMeth(MTFCEvidenceInfor model) { return(new TFCEvidenceInforBus().Add(model)); }