public int Update(ChangePrimaryBus ChangePrimaryBusObj) { try { string strUpdate = "update " + strTableName + " set "; string strSets = ""; string strWhere = " where 1=1" + "" + " and ID=" + ChangePrimaryBusObj.ID; if (ChangePrimaryBusObj.MSISDN != null) { strSets += "MSISDN=" + DH.ToDBString(ChangePrimaryBusObj.MSISDN); } else { strSets += "MSISDN=null"; } if (ChangePrimaryBusObj.SMS_content != null) { strSets += ",SMS_content=" + DH.ToDBString(ChangePrimaryBusObj.SMS_content); } else { strSets += ",SMS_content=null"; } if (ChangePrimaryBusObj.SMS_Options != null) { strSets += ",SMS_Options=" + DH.ToDBString(ChangePrimaryBusObj.SMS_Options); } else { strSets += ",SMS_Options=null"; } if (ChangePrimaryBusObj.Reply_Option != null) { strSets += ",Reply_Option=" + DH.ToDBString(ChangePrimaryBusObj.Reply_Option); } else { strSets += ",Reply_Option=null"; } if (ChangePrimaryBusObj.status >= 0) { strSets += ",status=" + ChangePrimaryBusObj.status; } else { strSets += ",status=null"; } if (ChangePrimaryBusObj.error_desc != null) { strSets += ",error_desc=" + DH.ToDBString(ChangePrimaryBusObj.error_desc); } else { strSets += ",error_desc=null"; } if (ChangePrimaryBusObj.request_type >= 0) { strSets += ",request_type=" + ChangePrimaryBusObj.request_type; } else { strSets += ",request_type=null"; } if (strSets.Length > 0) { DH.ExecuteNonQuery(strUpdate + strSets + strWhere); } return(1); } catch (Exception ex) { throw ex; } }
public int Update(VAT_SHOP_ECARE VAT_SHOP_ECAREObj) { try { string strUpdate = "update " + strTableName + " set "; string strSets = ""; string strWhere = " where SEQ_ID=" + VAT_SHOP_ECAREObj.SEQ_ID; if (VAT_SHOP_ECAREObj.REQ_XML != null) { strSets += ",REQ_XML=" + DH.ToDBString(VAT_SHOP_ECAREObj.REQ_XML); } else { strSets += ",REQ_XML=null"; } if (VAT_SHOP_ECAREObj.SEQ_ID != null) { strSets += ",SEQ_ID=" + DH.ToDBString(VAT_SHOP_ECAREObj.SEQ_ID); } else { strSets += ",SEQ_ID=null"; } if (VAT_SHOP_ECAREObj.ResultDesc != null) { strSets += ",ResultDesc=" + DH.ToDBString(VAT_SHOP_ECAREObj.ResultDesc); } else { strSets += ",ResultDesc=null"; } if (VAT_SHOP_ECAREObj.OFFER_NAME != null) { strSets += ",OFFER_NAME=" + DH.ToDBString(VAT_SHOP_ECAREObj.OFFER_NAME); } else { strSets += ",OFFER_NAME=null"; } if (VAT_SHOP_ECAREObj.STATUS > 0) { strSets += ",STATUS=" + VAT_SHOP_ECAREObj.STATUS; } else { strSets += ",STATUS=null"; } if (VAT_SHOP_ECAREObj.CHANNEL != null) { strSets += ",CHANNEL=" + DH.ToDBString(VAT_SHOP_ECAREObj.CHANNEL); } else { strSets += ",CHANNEL=null"; } if (VAT_SHOP_ECAREObj.VAT_AMOUNT > 0) { strSets += ",VAT_AMOUNT=" + VAT_SHOP_ECAREObj.VAT_AMOUNT; } else { strSets += ",VAT_AMOUNT=null"; } if (VAT_SHOP_ECAREObj.RECHARGE_AMOUNT > 0) { strSets += ",RECHARGE_AMOUNT=" + VAT_SHOP_ECAREObj.RECHARGE_AMOUNT; } else { strSets += ",RECHARGE_AMOUNT=null"; } if (VAT_SHOP_ECAREObj.MSISDN != null) { strSets += ",MSISDN=" + DH.ToDBString(VAT_SHOP_ECAREObj.MSISDN); } else { strSets += ",MSISDN=null"; } if (VAT_SHOP_ECAREObj.TRANSDATE != null) { strSets += ",TRANSDATE=" + DH.ToDBString(VAT_SHOP_ECAREObj.TRANSDATE); } else { strSets += ",TRANSDATE=null"; } if (VAT_SHOP_ECAREObj.TRACK_ID != null) { strSets += ",TRACK_ID=" + DH.ToDBString(VAT_SHOP_ECAREObj.TRACK_ID); } else { strSets += ",TRACK_ID=null"; } if (strSets.Length > 0) { DH.ExecuteNonQuery(strUpdate + strSets + strWhere); } return(1); } catch (Exception ex) { throw ex; } }