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