public static string getQuerySaveMeasureType(MeasureType measureType)
{
return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}')", ID_TABLE_MEASURETYPE,
measureType.Id,
measureType.Description,
measureType.LocalInsertTime.ToString(DATETIMEFORMAT_MEASURETYPE),
measureType.InsertUser,
measureType.UpdateLocalDateTime.ToString(DATETIMEFORMAT_MEASURETYPE),
measureType.UpdateUser);
}
public static string getQueryUpdateMeasureType(MeasureType measureType)
{
return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}'WHERE {9}='{10}'",
ID_TABLE_MEASURETYPE,
ID_DESCRIPTION_MEASURETYPE, measureType.Description,
ID_UPDATETIME_MEASURETYPE, measureType.UpdateLocalDateTime.ToString(DATETIMEFORMAT_MEASURETYPE),
ID_UPDATEUSER_MEASURETYPE, measureType.UpdateUser,
ID_ID_MEASURETYPE, measureType.Id
);
}
public static IList<MeasureType> ParseDataSetToMeasureType(DataTable dataTable)
{
IList<MeasureType> measureTypeList = new List<MeasureType>();
foreach (DataRow row in dataTable.Rows)
{
MeasureType measureType = new MeasureType()
{
Id = row[POSITION_ID_MEASURETYPE].ToString(),
Description = row[POSITION_DESCRIPTION_MEASURETYPE].ToString(),
LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_MEASURETYPE].ToString()),
InsertUser = row[POSITION_INSERTUSER_MEASURETYPE].ToString(),
UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_MEASURETYPE].ToString()),
UpdateUser = row[POSITION_UPDATEUSER_MEASURETYPE].ToString()
};
measureTypeList.Add(measureType);
}
return measureTypeList;
}
public void Update(MeasureType measureType)
{
_repositoryHelper.UpdateMeasureType(measureType);
}
public void Save(MeasureType measureType)
{
_repositoryHelper.SaveMeasureType(measureType);
}
public bool Exists(MeasureType measureType)
{
return Get(measureType.Id) != null;
}
public void UpdateMeasureType(MeasureType measureType)
{
string query = MeasureTypeQuery.getQueryUpdateMeasureType(measureType);
MeasureTypeQuery.ParseDataSetToMeasureType(_provider.queryExecute(query,UPDATE_TYPE));
}
public void SaveMeasureType(MeasureType measureType)
{
string query = MeasureTypeQuery.getQuerySaveMeasureType(measureType);
MeasureTypeQuery.ParseDataSetToMeasureType(_provider.queryExecute(query,INSERT_TYPE));
}