/// <summary> /// 添加报修 /// </summary> /// <param name="metId"></param> /// <returns></returns> public bool AddRepair(Model.WeChat.RepairAddDto repairDto) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hou_service_info("); strSql.Append("AreaID,NodeID,ClassID,ServiceSer,ContactPerson,ContactTel,Address,TodayDate,ServiceNote,Picture1,Picture2,Picture3,Memo,Sign,ISFeedback"); strSql.Append(") values ("); strSql.Append("@AreaID,@NodeID,@ClassID,dbo.F_GetClassSer(1),@ContactPerson,@ContactTel,@Address,getdate(),@ServiceNote,@Picture1,@Picture2,@Picture3,@Memo,0,@ISFeedback"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@AreaID", SqlDbType.VarChar, 10), new SqlParameter("@NodeID", SqlDbType.VarChar, 10), new SqlParameter("@ClassID", SqlDbType.Int, 4), new SqlParameter("@ContactPerson", SqlDbType.VarChar, 100), new SqlParameter("@ContactTel", SqlDbType.VarChar, 50), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@ServiceNote", SqlDbType.VarChar, 3000), new SqlParameter("@Picture1", SqlDbType.VarChar, 300), new SqlParameter("@Picture2", SqlDbType.VarChar, 300), new SqlParameter("@Picture3", SqlDbType.VarChar, 300), new SqlParameter("@Memo", SqlDbType.VarChar, 100), new SqlParameter("@ISFeedback", SqlDbType.SmallInt, 2) }; parameters[0].Value = repairDto.AreaID; parameters[1].Value = repairDto.NodeID; parameters[2].Value = 1; parameters[3].Value = repairDto.ContactPerson; parameters[4].Value = repairDto.ContactTel; parameters[5].Value = repairDto.Address; parameters[6].Value = repairDto.ServiceNote; parameters[7].Value = repairDto.Picture1; parameters[8].Value = repairDto.Picture2; parameters[9].Value = repairDto.Picture3; parameters[10].Value = repairDto.Memo; parameters[11].Value = repairDto.ISFeedback; int rows = sqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
/// <summary> /// 添加报修 /// </summary> /// <param name="metId"></param> /// <returns></returns> public bool AddRepair(Model.WeChat.RepairAddDto repairDto) { return(dal.AddRepair(repairDto)); }
public ResInfo AddRepair(Model.WeChat.RepairAddDto RepairDto) { BLL.WeChat.Repair bll = new BLL.WeChat.Repair(connStr); bll.AddRepair(RepairDto); return(resInfo); }