public int SaveEntity(paramTable entity) { if (entity.paramID == -1) { entity.paramID = 1 + MongoHelper.GetMaxId <paramTable>(collection); entity.deleteStatus = 1; try { collection.InsertOne(entity); return(1); } catch (Exception) { return(0); } } else { var idFilter = Builders <paramTable> .Filter.Eq(p => p.paramID, entity.paramID); var updateResult = collection.UpdateOne(idFilter, Builders <paramTable> .Update.Set("paramCode", entity.paramCode) .Set("paramText", entity.paramText) .Set("paramValue", entity.paramValue) .Set("paramType", entity.paramType) .Set("remark", entity.remark) ); return(updateResult.IsAcknowledged ? Convert.ToInt32(updateResult.ModifiedCount) : 0); } }
public paramTable GetEntityById(int Id) { SqlParameter param = new SqlParameter("@paramID", Id); string strSQL = "select * from [paramTable] where paramID = @paramID "; System.Data.SqlClient.SqlDataReader dr; dr = SQLHelper.ExecuteReader(strSQL, param); try { paramTable entity = new paramTable(); entity = SQLHelper.ReaderToList <paramTable>(dr)[0]; return(entity); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.StackTrace); return(null); } finally { if (!dr.IsClosed) { dr.Close(); } } }
public int SaveEntity(paramTable entity) { List <SqlParameter> paramList = new List <SqlParameter>(); var paramID_parameter = new SqlParameter("@paramID", SqlDbType.Int); if (entity.paramID > 0) { paramID_parameter.Value = entity.paramID; } else { paramID_parameter.Value = DBNull.Value; } SqlParameter paramCode_parameter = new SqlParameter("@paramCode", entity.paramCode); paramList.Add(paramCode_parameter); SqlParameter paramText_parameter = new SqlParameter("@paramText", entity.paramText); paramList.Add(paramText_parameter); SqlParameter paramValue_parameter = new SqlParameter("@paramValue", entity.paramValue); paramList.Add(paramValue_parameter); var paramType_parameter = new SqlParameter("@paramType", entity.paramType); paramList.Add(paramType_parameter); SqlParameter remark_parameter = new SqlParameter("@remark", entity.remark); paramList.Add(remark_parameter); string sql = ""; SqlParameter identityParameter = new SqlParameter("@IdentityId", SqlDbType.Int); if (entity.paramID == -1) { identityParameter.Direction = ParameterDirection.Output; paramList.Add(identityParameter); sql = "insert into paramTable(paramCode,paramText,paramValue,paramType,remark,deleteStatus) "; sql += "values(@paramCode,@paramText,@paramValue,@paramType,@remark,1) Select @IdentityId = @@identity "; } else { paramList.Add(paramID_parameter); sql = "update paramTable set paramCode = @paramCode,paramText = @paramText,paramValue = @paramValue,paramType = @paramType,remark = @remark where paramID =@paramID "; } int count = SQLHelper.ExecuteonQuery(sql, paramList.ToArray()); if (entity.paramID == -1 && identityParameter != null) { entity.paramID = Convert.ToInt32(identityParameter.Value); } return(count); }