public int Edit(Channel ch) { ch.Replace4MySQL(); try { StringBuilder sql = new StringBuilder("update channel set "); sql.Append(string.Format("channel_status='{0}',channel_name_full='{1}',channel_name_simple='{2}',channel_invoice='{3}',channel_email='{4}',company_phone='{5}',company_fax='{6}',company_zip='{7}',company_address='{8}',invoice_title='{9}',invoice_zip='{10}',invoice_address='{11}',annaul_fee='{12}',renew_fee='{13}',channel_type='{14}',user_id='{15}',model_in='{16}',notify_sms='{17}',erp_id='{18}' ", ch.channel_status, ch.channel_name_full, ch.channel_name_simple, ch.channel_invoice, ch.channel_email, ch.company_phone, ch.company_fax, ch.company_zip, ch.company_address, ch.invoice_title, ch.invoice_zip, ch.invoice_address, ch.annaul_fee, ch.renew_fee, ch.channel_type, ch.user_id, ch.model_in, ch.notify_sms, ch.erp_id)); if (ch.contract_createdate != DateTime.MinValue) { sql.Append(string.Format(",contract_createdate='{0}'", ch.contract_createdate.ToString("yyyy/MM/dd"))); } if (ch.contract_start != DateTime.MinValue) { sql.Append(string.Format(",contract_start='{0}'", ch.contract_start.ToString("yyyy/MM/dd"))); } if (ch.contract_end != DateTime.MinValue) { sql.Append(string.Format(",contract_end='{0}'", ch.contract_end.ToString("yyyy/MM/dd"))); } sql.Append(string.Format(" WHERE channel_id = '{0}';", ch.channel_id)); sql.Append(string.Format(" UPDATE users SET user_name = '{0}' WHERE user_id='{1}'", ch.channel_name_full, ch.user_id)); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ChannelDao-->Edit-->" + ex.Message, ex); } }
public int SaveOther(Channel ch) { ch.Replace4MySQL(); try { strSql = string.Format(@"update channel set deal_method={0},deal_percent={1},deal_fee={2},creditcard_1_percent={3},creditcard_3_percent={4}, shopping_car_percent={5},commission_percent={6},cost_by_percent={7},cost_low_percent={8},cost_normal_percent={9},invoice_checkout_day={10}, invoice_apply_start={11},invoice_apply_end={12},checkout_note='{13}',receipt_to={14},channel_manager='{15}',channel_note='{16}' where channel_id='{17}'", ch.deal_method == 0 ? "null" : ch.deal_method.ToString(), ch.deal_percent == 0 ? "null" : ch.deal_percent.ToString(), ch.deal_fee == 0 ? "null" : ch.deal_fee.ToString(), ch.creditcard_1_percent == 0 ? "null" : ch.creditcard_1_percent.ToString(), ch.creditcard_3_percent == 0 ? "null" : ch.creditcard_3_percent.ToString(), ch.shopping_car_percent == 0 ? "null" : ch.shopping_car_percent.ToString(), ch.commission_percent == 0 ? "null" : ch.commission_percent.ToString(), ch.cost_by_percent == 0 ? "null" : ch.cost_by_percent.ToString(), ch.cost_low_percent == 0 ? "null" : ch.cost_low_percent.ToString(), ch.cost_normal_percent == 0 ? "null" : ch.cost_normal_percent.ToString(), ch.invoice_checkout_day == 0 ? "null" : ch.invoice_checkout_day.ToString(), ch.invoice_apply_start == 0 ? "null" : ch.invoice_apply_start.ToString(), ch.invoice_apply_end == 0 ? "null" : ch.invoice_apply_end.ToString(), ch.checkout_note, ch.receipt_to == 0 ? "null" : ch.receipt_to.ToString(), ch.channel_manager, ch.channel_note, ch.channel_id); return _accessMySql.execCommand(strSql); } catch (Exception ex) { throw new Exception("ChannelDao-->SaveOther-->" + ex.Message, ex); } }
public int Save(Channel ch) { ch.Replace4MySQL(); StringBuilder sbCloum = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); try { if (ch.contract_createdate != DateTime.MinValue) { sbCloum.Append("contract_createdate,"); sbValue.Append("'" + ch.contract_createdate.ToString("yyyy/MM/dd") + "',"); } if (ch.contract_start != DateTime.MinValue) { sbCloum.Append("contract_start,"); sbValue.Append("'" + ch.contract_start.ToString("yyyy/MM/dd") + "',"); } if (ch.contract_end != DateTime.MinValue) { sbCloum.Append("contract_end,"); sbValue.Append("'" + ch.contract_end.ToString("yyyy/MM/dd") + "',"); } //add by xiangwang0413w 2014/06/26 增加 ERP客戶代號(erp_id) strSql = string.Format(@"insert into channel(channel_status,channel_name_full,channel_name_simple,channel_invoice,channel_email,company_phone, company_fax,company_zip,company_address,invoice_title,invoice_zip,invoice_address,{0} annaul_fee,renew_fee,channel_type,user_id,model_in,notify_sms,erp_id) values ('{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},'{9}','{10}','{11}','{12}',{13} {14},{15},'{16}','{17}','{18}','{19}','{20}');select @@identity", sbCloum.ToString(), ch.channel_status, ch.channel_name_full, ch.channel_name_simple, ch.channel_invoice, ch.channel_email, ch.company_phone, ch.company_fax, ch.company_zip == 0 ? "null" : ch.company_zip.ToString(), ch.company_address, ch.invoice_title, ch.invoice_zip, ch.invoice_address, sbValue.ToString(), ch.annaul_fee == 0 ? "null" : ch.annaul_fee.ToString(), ch.renew_fee == 0 ? "null" : ch.renew_fee.ToString(), ch.channel_type, ch.user_id, ch.model_in, ch.notify_sms, ch.erp_id); return Int32.Parse(_accessMySql.getDataTable(strSql).Rows[0][0].ToString()); } catch (Exception ex) { throw new Exception("ChannelDao-->Save-->" + ex.Message, ex); } }