Esempio n. 1
0
 public int Edit(ChannelContact chc)
 {
     chc.Replace4MySQL();
     strSql = string.Format(@"update channel_contact set contact_type='{0}',contact_name='{1}',contact_phone1='{2}',contact_phone2='{3}',contact_mobile='{4}',contact_email='{5}'
         where rid='{6}'", chc.contact_type, chc.contact_name, chc.contact_phone1, chc.contact_phone2, chc.contact_mobile,
         chc.contact_email, chc.rid);
     return _accessMySql.execCommand(strSql);
 }
Esempio n. 2
0
 public int Save(ChannelContact chc)
 {
     chc.Replace4MySQL();
     strSql = string.Format(@"insert into channel_contact(contact_type,contact_name,contact_phone1,contact_phone2,contact_mobile,contact_email,channel_id) 
         values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", chc.contact_type, chc.contact_name, chc.contact_phone1, chc.contact_phone2, chc.contact_mobile, 
         chc.contact_email, chc.channel_id);
     return _accessMySql.execCommand(strSql);
 }