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