/// <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));
}
