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