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