public int Update(YF_AssetDrawModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new YF_AssetDrawBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public int ModifyPassAuditing(int Code)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new YF_AssetDrawBLL().ModifyPassAuditing(Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public List <YF_AssetDrawModel> GetYF_AssetDrawList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, int ManageCodeEqual, string DrawUnitEqual, DateTime DrawDateEqual, string DrawPersonEqual, string UserCodeEqual, string StatusEqual, string UnitEqual, DateTime BackTimeEqual)
{
List <YF_AssetDrawModel> models = new List <YF_AssetDrawModel>();
YF_AssetDrawQueryModel objQueryModel = new YF_AssetDrawQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.ManageCodeEqual = ManageCodeEqual;
objQueryModel.DrawUnitEqual = DrawUnitEqual;
objQueryModel.DrawDateEqual = DrawDateEqual;
objQueryModel.DrawPersonEqual = DrawPersonEqual;
objQueryModel.UserCodeEqual = UserCodeEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.UnitEqual = UnitEqual;
objQueryModel.BackTimeEqual = BackTimeEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new YF_AssetDrawBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public YF_AssetDrawModel GetYF_AssetDraw(int Code)
{
YF_AssetDrawModel model = new YF_AssetDrawModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new YF_AssetDrawBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <YF_AssetDrawModel> GetYF_AssetDrawListOne(int Code)
{
List <YF_AssetDrawModel> list = new List <YF_AssetDrawModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
YF_AssetDrawBLL wbll = new YF_AssetDrawBLL();
list.Add(wbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <YF_AssetDrawModel> GetYF_AssetDrawList(YF_AssetDrawQueryModel QueryModel)
{
List <YF_AssetDrawModel> models = new List <YF_AssetDrawModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new YF_AssetDrawQueryModel();
}
models = new YF_AssetDrawBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
