public void ModifyGroupEmail(uint groupId, uint emailId, string emailName, uint emailStatus = 1) { uint email_status = (uint)(emailStatus == 1 ? 1 : 2); EdmGroupEmail ege = new EdmGroupEmail(); ege.email_id = emailId; ege.group_id = groupId; ege.email_name = emailName; ege.email_status = email_status; ege.email_updatedate = (uint)CommonFunction.GetPHPTime(); ege.Replace4MySQL(); string strSql = string.Format("update edm_group_email set email_name='{0}',email_status={1},email_updatedate={2} where email_id={3} and group_id={4}", ege.email_name, ege.email_status, (uint)CommonFunction.GetPHPTime(), ege.email_id, ege.group_id); try { _accessMySql.execCommand(strSql); } catch (Exception ex) { throw new Exception("UserEdmDao.modifyEmailName-->" + ex.Message + "sql--" + strSql, ex); } }
public void modifyEmailName(uint emailId, string emailName) { EdmGroupEmail ege = new EdmGroupEmail(); ege.email_name = emailName; ege.email_id = emailId; ege.Replace4MySQL(); string strSql = string.Format("update edm_email set email_name='{0}',email_updatedate={1} where email_id={2}", ege.email_name, CommonFunction.GetPHPTime(), ege.email_id); try { _accessMySql.execCommand(strSql); } catch (Exception ex) { throw new Exception("UserEdmDao.modifyEmailName-->" + ex.Message + "sql--" + strSql, ex); } }
public EdmGroupEmail getEdmGroupEmail(uint groupid, uint emailId) { EdmGroupEmail ege = new EdmGroupEmail(); string strSql = string.Format("select group_id,email_id,email_name,email_status,email_createdate,email_updatedate from edm_group_email where group_id={0} and email_id={1}", groupid, emailId); try { ege = _accessMySql.getSinggleObj<EdmGroupEmail>(strSql); } catch (Exception ex) { throw new Exception("UserEdmDao.AddEmail-->" + ex.Message + "sql--" + strSql, ex); } return ege; }
//edm_group_email表插入數據 public void AddGroupEmail(uint groupId, uint emailId, string emailName, uint emailStatus = 1) { string strSql = string.Empty; try { if (emailName.Length>0) { string tempStr = emailName.Substring(emailName.Length - 1, 1); if (tempStr == "\\") { emailName = emailName + "\\"; } } uint email_status = (uint)(emailStatus == 1 ? 1 : 2); EdmGroupEmail ege = new EdmGroupEmail(); ege.email_id = emailId; ege.group_id = groupId; ege.email_name = emailName; ege.email_status = email_status; ege.email_createdate = (uint)CommonFunction.GetPHPTime(); ege.email_updatedate = (uint)CommonFunction.GetPHPTime(); ege.Replace4MySQL(); strSql = string.Format("insert into edm_group_email (group_id,email_id,email_name,email_status,email_createdate,email_updatedate)values({0},{1},'{2}',{3},{4},{5})", ege.group_id, ege.email_id, ege.email_name, ege.email_status, ege.email_createdate, ege.email_updatedate); _accessMySql.execCommand(strSql); } catch (Exception ex) { throw new Exception("UserEdmDao.AddGroupEmail-->" + ex.Message + "sql--" + strSql, ex); } }
public List<EdmGroupEmailQuery> GetModel(EdmGroupEmail query) { try { return _IEdmGroupEmailMgr.GetModel(query); } catch (Exception ex) { throw new Exception("EdmGroupEmailMgr-->GetModel" + ex.Message, ex); } }
public List<EdmGroupEmailQuery> GetModel(EdmGroupEmail query) { StringBuilder sb = new StringBuilder(); try { sb.Append("SELECT ege.group_id,ee.email_address,ege.email_id,ee.email_name,ege.email_status,ege.email_createdate,ege.email_updatedate "); sb.Append(" FROM edm_group_email ege "); sb.Append(" LEFT JOIN edm_email ee ON ee.email_id=ege.email_id "); sb.AppendFormat(" WHERE ege.email_id='{0}' ", query.email_id); if (query.group_id !=0) { sb.AppendFormat(" AND ege.group_id='{0}' ", query.group_id); } return _accessMySql.getDataTableForObj<EdmGroupEmailQuery>(sb.ToString()); } catch (Exception ex) { throw new Exception("EdmGroupEmailDao-->GetModel" + ex.Message + sb.ToString(), ex); } }