/// <summary> /// 获取装船机SQL字符串 /// </summary> /// <param name="loader">装船机对象</param> /// <returns></returns> private string GetShiploaderSqlString(Shiploader loader) { string sql = string.Empty; if (loader != null) { sql = string.Format(loader.Id <= 0 ? "insert into t_base_shiploader_info (shiploader_name, topic_name) values ('{0}', '{1}')" : "update t_base_shiploader_info set shiploader_name = '{0}', topic_name = '{1}' where shiploader_id = {2}", loader.Name, loader.TopicName, loader.Id); } return(sql); }
/// <summary> /// 保存装船机信息 /// </summary> /// <param name="loader">装船机对象</param> /// <returns></returns> public int SaveShiploader(Shiploader loader) { return(this.provider.ExecuteSql(this.GetShiploaderSqlString(loader))); }