public List<ElementDetailQuery> QueryPacketProd(ElementDetail model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.Append("select bd.element_id,bd.element_name,bd.packet_id,bd.element_content,ap.element_type ");
sql.Append(" FROM element_detail bd ");
sql.Append(" join area_packet ap on ap.packet_id=bd.packet_id");
sql.AppendFormat(" and bd.packet_id='{0}' ", model.packet_id);
sql.AppendFormat(" and bd.element_content='{0}' ", model.element_content);
return _access.getDataTableForObj<ElementDetailQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ElementDetailDao-->QueryPacketProd-->" + ex.Message + sql.ToString(), ex);
}
}
public int Update(ElementDetail model)
{
model.Replace4MySQL();
StringBuilder sqlStr = new StringBuilder("");
try
{
model.Replace4MySQL();
sqlStr.AppendFormat(@"update element_detail set ");
sqlStr.AppendFormat(" `element_content`='{0}',`element_name`='{1}',`element_link_url`='{2}',`element_link_mode`='{3}',", model.element_content, model.element_name, model.element_link_url, model.element_link_mode);
sqlStr.AppendFormat(" `element_sort`='{0}',`element_start`='{1}',`element_end`='{2}',`element_updatedate`='{3}',`update_userid`='{4}',`element_remark`='{5}',`packet_id`={6} ,`category_id`='{7}',`category_name`='{8}',element_img_big='{9}' ",
model.element_sort, CommonFunction.DateTimeToString(model.element_start),
CommonFunction.DateTimeToString(model.element_end),
CommonFunction.DateTimeToString(model.element_updatedate), model.update_userid, model.element_remark, model.packet_id, model.category_id, model.category_name,model.element_img_big);
sqlStr.AppendFormat(" where element_id='{0}'", model.element_id);
return _access.execCommand(sqlStr.ToString());
}
catch (Exception ex)
{
throw new Exception("ElementDetailDao-->Update-->" + ex.Message + sqlStr.ToString(), ex);
}
}
public ElementDetail GetModel(ElementDetail query)
{
query.Replace4MySQL();
StringBuilder sqlStr = new StringBuilder("");
try
{
query.Replace4MySQL();
sqlStr.Append(@"SELECT element_id,packet_id,category_id,category_name,element_content,element_name,");
sqlStr.Append(@"element_link_url,element_link_mode,element_sort,element_status,element_start,element_end,");
sqlStr.Append(@"element_createdate,element_updatedate,create_userid,update_userid,element_remark,element_img_big ");
sqlStr.AppendFormat(@"from element_detail where element_id={0};", query.element_id);
return _access.getSinggleObj<ElementDetail>(sqlStr.ToString());
}
catch (Exception ex)
{
throw new Exception("ElementDetailDao-->GetModel-->" + ex.Message + sqlStr.ToString(), ex);
}
}
public int Save(ElementDetail model)
{
model.Replace4MySQL();
StringBuilder sqlStr = new StringBuilder("");
try
{
model.Replace4MySQL();
sqlStr.Append(@"insert into element_detail(`element_content`,`element_name`,`element_link_url`,`element_link_mode`,`element_sort`,`element_status`,`element_start`,`element_end`,`element_createdate`,`element_updatedate`,`create_userid`,`update_userid`,`element_remark`,`packet_id`,`category_id`,`category_name`,`element_img_big`) ");
sqlStr.AppendFormat(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}',{13},'{14}','{15}','{16}') ",
model.element_content, model.element_name, model.element_link_url, model.element_link_mode, model.element_sort, model.element_status,
CommonFunction.DateTimeToString(model.element_start), CommonFunction.DateTimeToString(model.element_end), CommonFunction.DateTimeToString(model.element_createdate),
CommonFunction.DateTimeToString(model.element_updatedate), model.create_userid, model.update_userid, model.element_remark, model.packet_id, model.category_id, model.category_name,model.element_img_big);
return _access.execCommand(sqlStr.ToString());
}
catch (Exception ex)
{
throw new Exception("ElementDetailDao-->Save-->" + ex.Message + sqlStr.ToString(), ex);
}
}