/// <summary>
/// 获取搬家信息详情
/// </summary>
/// <param name="msgID">信息ID</param>
/// <returns>搬家信息详情</returns>
public MvhInfoModel GetMvhInfoDetatil(int msgID)
{
MvhInfoModel mvhInfoList = null;
#region - sql qy -
string selectDetailQy = @"SELECT
`f_Bj_ID`,
`f_Bj_Name`,
`f_Bj_Mobile`,
`f_Bj_Title`,
`f_Bj_UID`,
`f_Bj_Site`,
`f_IsDiplaySex`,
`f_IsNeedHelpBj`,
`f_BjCostsStart`,
`f_BjCostEnd`,
`f_BjDecription`,
`f_InsertTime`,
`f_UpdateTime`,
`avg1`,
`avg2`
FROM `movehouse`.`mvhinfo` AS mvhInfo
WHERE mvhinfo.`f_Bj_ID`=@MsgID";
#endregion
#region - paras -
MySqlParameter[] paras =
{
new MySqlParameter("@MsgID",msgID)
};
#endregion
#region - excute -
try
{
//记录查询
DataTable dataTable = DbHelperMySql.GetDataSet(DbHelperMySql.connectionStringManager, selectDetailQy, paras).Tables[0];
if (dataTable != null)
{
mvhInfoList =new MvhInfoModel();
foreach (DataRow row in dataTable.Rows)
{
mvhInfoList=TransMvhInfo(row);
}
}
}
catch (Exception ex)
{
//记录日志
throw ex;
}
#endregion
return mvhInfoList;
}
public ContentResult PublishMvhInfoPost( string name,string mobile, short isNeedHelpBj, decimal costStart, decimal costEnd, string decription)
{
int resultInt = 0;
string uid = "aa897dd5-f352-4395-8fd5-250cba00598d";
short F_IsDisplaySex = 0;
#region - paras -
MvhInfoModel mvhInfoModel = new MvhInfoModel();
mvhInfoModel.F_Bj_Title =string.Empty;
mvhInfoModel.F_Mobile = mobile;
mvhInfoModel.F_Name = name;
mvhInfoModel.F_Bj_UID = uid;
mvhInfoModel.F_IsDisplaySex = F_IsDisplaySex;
mvhInfoModel.F_IsNeedHelpBj = isNeedHelpBj;
mvhInfoModel.F_BjCostStart = costStart;
mvhInfoModel.F_BjCostEnd = costEnd;
mvhInfoModel.F_BjDecription = decription;
#endregion
#region - excute -
resultInt = mvhInfoBll.InsertMvhInfo(mvhInfoModel);
#endregion
return Content(resultInt.ToString());
}
/// <summary>
/// 发布搬家信息
/// </summary>
/// <param name="mvhInfo">搬家信息实体</param>
/// <returns>影响行数</returns>
public int InsertMvhInfo(MvhInfoModel mvhInfo)
{
return mvhDal.InsertMvhInfo(mvhInfo);
}
/// <summary>
/// 转换至MoveHouesInfo
/// </summary>
/// <param name="row">数据项</param>
/// <returns>MoveHouesInfo实体</returns>
public MvhInfoModel TransMvhInfo(DataRow row)
{
MvhInfoModel mvhInfo = new MvhInfoModel();
mvhInfo.F_Bj_ID = row["f_bj_id"] != null ? Convert.ToInt32(row["f_bj_id"]) : 0;
mvhInfo.F_Name = row["f_Bj_Name"] != null ? row["f_Bj_Name"].ToString() : string.Empty;
mvhInfo.F_Mobile = row["f_Bj_Mobile"] != null ? row["f_Bj_Mobile"].ToString() : string.Empty;
mvhInfo.F_Bj_Site = row["f_Bj_Site"] != null ? Convert.ToInt32(row["f_Bj_Site"]) : 0;
mvhInfo.F_IsDisplaySex = row["f_IsDiplaySex"] != null ? Convert.ToInt32(row["f_IsDiplaySex"]) : 0;
mvhInfo.F_IsNeedHelpBj = row["f_IsNeedHelpBj"] != null ? Convert.ToInt32(row["f_IsNeedHelpBj"]) : 0;
mvhInfo.F_BjCostStart = row["f_BjCostsStart"] != null ? Convert.ToDecimal(row["f_BjCostsStart"]) : 0;
mvhInfo.F_BjCostEnd = row["f_BjCostEnd"] != null ? Convert.ToDecimal(row["f_BjCostEnd"]) : 0;
mvhInfo.F_BjDecription = row["f_BjDecription"] != null ? row["f_BjDecription"].ToString() : string.Empty;
mvhInfo.F_InsetTime = row["f_InsertTime"] != null ? Convert.ToDateTime(row["f_InsertTime"]) : DateTime.MinValue;
mvhInfo.F_InsetTime = row["f_UpdateTime"] != null ? Convert.ToDateTime(row["f_UpdateTime"]) : DateTime.MinValue;
return mvhInfo;
}
/// <summary>
/// 生成搬家信息记录
/// </summary>
/// <param name="mvhInfo">搬家信息实体</param>
/// <returns>影响行数</returns>
public int InsertMvhInfo(MvhInfoModel mvhInfo)
{
int resultInt = 0;
#region - sql qy -
string sqlQy = @"INSERT INTO `movehouse`.`MvhInfo`
(
`f_Bj_UID`,
`f_Bj_Name`,
`f_Bj_Mobile`,
`f_Bj_Title`,
`f_IsDiplaySex`,
`f_IsNeedHelpBj`,
`f_BjCostsStart`,
`f_BjCostEnd`,
`f_BjDecription`,
`f_InsertTime`,
`f_UpdateTime`,
`avg1`,
`avg2`)
VALUES (
@f_Bj_UID,
@f_Bj_Name,
@f_Bj_Mobile,
@f_Bj_Title,
@f_IsDiplaySex,
@f_IsNeedHelpBj,
@f_BjCostsStart,
@f_BjCostEnd,
@f_BjDecription,
@f_InsertTime,
@f_UpdateTime,
@avg1,
@avg2 );";
#endregion
#region - params -
MySqlParameter[] paras =
{
new MySqlParameter("@f_Bj_UID",mvhInfo.F_Bj_UID),
new MySqlParameter("@f_Bj_Name",mvhInfo.F_Name),
new MySqlParameter("@f_Bj_Mobile",mvhInfo.F_Mobile),
new MySqlParameter("@f_Bj_Title",string.Empty),
new MySqlParameter("@f_IsDiplaySex",mvhInfo.F_IsDisplaySex),
new MySqlParameter("@f_IsNeedHelpBj",mvhInfo.F_IsNeedHelpBj),
new MySqlParameter("@f_BjCostsStart",mvhInfo.F_BjCostStart),
new MySqlParameter("@f_BjCostEnd",mvhInfo.F_BjCostEnd),
new MySqlParameter("@f_BjDecription",mvhInfo.F_BjDecription),
new MySqlParameter("@f_InsertTime",mvhInfo.F_InsetTime),
new MySqlParameter("@f_UpdateTime",mvhInfo.F_UpdateTime),
new MySqlParameter("@avg1",string.Empty),
new MySqlParameter("@avg2",string.Empty)
};
#endregion
#region - Excute -
try
{
resultInt = Convert.ToInt32(DbHelperMySql.ExecuteNonQuery(DbHelperMySql.connectionStringManager,System.Data.CommandType.Text,sqlQy,paras));
}
catch (Exception ex)
{
//记录错误信息
throw;
}
#endregion
return resultInt;
}
