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