public List <YF_AssetMainRecordModel> GetYF_AssetMainRecordList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, int FKCodeEqual, string ContentEqual, int CostTimeEqual, decimal CostMoneyEqual, string ChangeDetailEqual, string UserSignEqual, string MainUserEqual, DateTime MainTimeEqual, string ResultEqual)
{
List <YF_AssetMainRecordModel> models = new List <YF_AssetMainRecordModel>();
YF_AssetMainRecordQueryModel objQueryModel = new YF_AssetMainRecordQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.FKCodeEqual = FKCodeEqual;
objQueryModel.ContentEqual = ContentEqual;
objQueryModel.CostTimeEqual = CostTimeEqual;
objQueryModel.CostMoneyEqual = CostMoneyEqual;
objQueryModel.ChangeDetailEqual = ChangeDetailEqual;
objQueryModel.UserSignEqual = UserSignEqual;
objQueryModel.MainUserEqual = MainUserEqual;
objQueryModel.MainTimeEqual = MainTimeEqual;
objQueryModel.ResultEqual = ResultEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new YF_AssetMainRecordBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public int Update(YF_AssetMainRecordModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new YF_AssetMainRecordBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public YF_AssetMainRecordModel GetYF_AssetMainRecord(int Code)
{
YF_AssetMainRecordModel model = new YF_AssetMainRecordModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new YF_AssetMainRecordBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <YF_AssetMainRecordModel> GetYF_AssetMainRecordList(YF_AssetMainRecordQueryModel QueryModel)
{
List <YF_AssetMainRecordModel> models = new List <YF_AssetMainRecordModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new YF_AssetMainRecordQueryModel();
}
models = new YF_AssetMainRecordBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <YF_AssetMainRecordModel> GetYF_AssetMainRecordList(string SortColumns, int StartRecord, int MaxRecords, string CodeEqual, string FKCodeEqual, string ContentEqual, string CostTimeEqual, string CostMoneyEqual, string ChangeDetailEqual, string UserSignEqual, string MainUserEqual, string MainTimeEqual, string ResultEqual)
{
List <YF_AssetMainRecordModel> models = new List <YF_AssetMainRecordModel>();
YF_AssetMainRecordQueryModel objQueryModel = new YF_AssetMainRecordQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
if (!string.IsNullOrEmpty(CodeEqual))
{
objQueryModel.CodeEqual = int.Parse(CodeEqual);
}
if (!string.IsNullOrEmpty(FKCodeEqual))
{
objQueryModel.FKCodeEqual = int.Parse(FKCodeEqual);
}
if (!string.IsNullOrEmpty(ContentEqual))
{
objQueryModel.ContentEqual = ContentEqual;
}
if (!string.IsNullOrEmpty(CostTimeEqual))
{
objQueryModel.CostTimeEqual = int.Parse(CostTimeEqual);
}
if (!string.IsNullOrEmpty(CostMoneyEqual))
{
objQueryModel.CostMoneyEqual = decimal.Parse(CostMoneyEqual);
}
if (!string.IsNullOrEmpty(ChangeDetailEqual))
{
objQueryModel.ChangeDetailEqual = ChangeDetailEqual;
}
if (!string.IsNullOrEmpty(UserSignEqual))
{
objQueryModel.UserSignEqual = UserSignEqual;
}
if (!string.IsNullOrEmpty(MainUserEqual))
{
objQueryModel.MainUserEqual = MainUserEqual;
}
if (!string.IsNullOrEmpty(MainTimeEqual))
{
objQueryModel.MainTimeEqual = DateTime.Parse(MainTimeEqual);
}
if (!string.IsNullOrEmpty(ResultEqual))
{
objQueryModel.ResultEqual = ResultEqual;
}
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
try
{
connection.Open();
models = new YF_AssetMainRecordBLL().GetModels(objQueryModel, connection);
}
catch (SqlException exception)
{
throw exception;
}
return(models);
}
finally
{
connection.Close();
}
}
return(models);
}
