public int SaveGCC(GroupCommitteContact query)
{
try
{
int i = _accessMySql.execCommand(_gccDao.SaveGCC(query));
return i;
}
catch (Exception ex)
{
throw new Exception(" GroupCommitteContactMgr -->SaveGCC " + ex.Message, ex);
}
}
public string DeleteGCC(GroupCommitteContact query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"DELETE FROM group_committe_contact where gcc_id={0}", query.gcc_id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception(" GroupCommitteContactDao -->SaveGCC " + ex.Message, ex);
}
}
public string UpdateGCC(GroupCommitteContact query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"UPDATE group_committe_contact SET gcc_chairman='{0}',gcc_phone={1},gcc_mail='{2}',m_user='******',m_date='{4}' WHERE gcc_id={5}", query.gcc_chairman, query.gcc_phone, query.gcc_mail, query.m_user, CommonFunction.DateTimeToString(query.m_date), query.gcc_id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception(" GroupCommitteContactDao -->SaveGCC " + ex.Message, ex);
}
}
public string SaveGCC(GroupCommitteContact query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"INSERT INTO group_committe_contact (group_id,gcc_chairman,gcc_phone,gcc_mail,k_user,k_date,m_user,m_date) VALUES({0},'{1}','{2}','{3}',{4},'{5}',{6},'{7}')", query.group_id, query.gcc_chairman, query.gcc_phone, query.gcc_mail, query.k_user, CommonFunction.DateTimeToString(query.k_date), query.m_user, CommonFunction.DateTimeToString(query.m_date));
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception(" GroupCommitteContactDao -->SaveGCC " + ex.Message, ex);
}
}
public string GetGroupCommitteContact(GroupCommitteContact query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"SELECT gcc_id,group_id,gcc_chairman,gcc_phone,gcc_mail FROM group_committe_contact WHERE group_id={0}", query.group_id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception(" GroupCommitteContactDao -->GetGroupCommitteContact " + ex.Message, ex);
}
}
public List<GroupCommitteContact> GetGroupCommitteContact(GroupCommitteContact query)
{
List<GroupCommitteContact> store = new List<GroupCommitteContact>();
try
{
string sql = _gccDao.GetGroupCommitteContact(query);
store = _accessMySql.getDataTableForObj<GroupCommitteContact>(sql);
return store;
}
catch (Exception ex)
{
throw new Exception(" GroupCommitteContactMgr -->GetGroupCommitteContact " + ex.Message, ex);
}
}
public HttpResponseBase DeleteGCC()
{
string json = string.Empty;
GroupCommitteContact query = new GroupCommitteContact();
_gccMgr = new GroupCommitteContactMgr(mySqlConnectionString);
try
{
if (!string.IsNullOrEmpty(Request.Params["gcc_id"]))
{
query.gcc_id = Convert.ToInt32(Request.Params["gcc_id"]);
}
int i = _gccMgr.DeleteGCC(query);
if (i > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,msg:'0'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SaveGCC()
{
string json = string.Empty;
GroupCommitteContact query = new GroupCommitteContact();
_gccMgr = new GroupCommitteContactMgr(mySqlConnectionString);
try
{
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
query.group_id = Convert.ToInt32(Request.Params["group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["group_committe_chairman"]))
{
query.gcc_chairman = Request.Params["group_committe_chairman"];
}
if (!string.IsNullOrEmpty(Request.Params["group_committe_phone"]))
{
query.gcc_phone = Request.Params["group_committe_phone"];
}
if (!string.IsNullOrEmpty(Request.Params["group_committe_mail"]))
{
query.gcc_mail = Request.Params["group_committe_mail"];
}
query.k_user = (Session["caller"] as Caller).user_id;
query.k_date = DateTime.Now;
query.m_user = (Session["caller"] as Caller).user_id;
query.m_date = DateTime.Now;
int i = _gccMgr.SaveGCC(query);
if (i > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,msg:'0'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetGroupCommitteContact()
{
List<GroupCommitteContact> store = new List<GroupCommitteContact>();
string json = string.Empty;
GroupCommitteContact query = new GroupCommitteContact();
_gccMgr = new GroupCommitteContactMgr(mySqlConnectionString);
try
{
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
query.group_id = Convert.ToInt32(Request.Params["group_id"]);
store = _gccMgr.GetGroupCommitteContact(query);
json = "{success:true,data:" + JsonConvert.SerializeObject(store) + "}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}