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