public List <TC_OA_SmallGoodsModel> GetTC_OA_SmallGoodsList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string UserCodeEqual, string UnitCodeEqual, DateTime ApplayDateEqual, string NameEqual, string UseWayEqual, string TypeEqual, string GoodsCodeEqual, int AuditingEqual)
{
List <TC_OA_SmallGoodsModel> models = new List <TC_OA_SmallGoodsModel>();
TC_OA_SmallGoodsQueryModel objQueryModel = new TC_OA_SmallGoodsQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.UserCodeEqual = UserCodeEqual;
objQueryModel.UnitCodeEqual = UnitCodeEqual;
objQueryModel.ApplayDateEqual = ApplayDateEqual;
objQueryModel.NameEqual = NameEqual;
objQueryModel.UseWayEqual = UseWayEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.GoodsCodeEqual = GoodsCodeEqual;
objQueryModel.AuditingEqual = AuditingEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
models = new TC_OA_SmallGoodsBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public int Delete(TC_OA_SmallGoodsModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new TC_OA_SmallGoodsBLL().Delete(ObjModel.Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public int Insert(TC_OA_BigGoodsDetailModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new TC_OA_BigGoodsDetailBLL().Insert(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public List <TC_OA_BigGoodsDetailModel> GetTC_OA_BigGoodsDetailList(string SortColumns, int StartRecord, int MaxRecords, string MastCodeEqual, int IsSubmitEqual)
{
List <TC_OA_BigGoodsDetailModel> models = new List <TC_OA_BigGoodsDetailModel>();
TC_OA_BigGoodsDetailQueryModel objQueryModel = new TC_OA_BigGoodsDetailQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
if (SortColumns == null)
{
SortColumns = "";
}
objQueryModel.SortColumns = SortColumns;
objQueryModel.MastCodeEqual = MastCodeEqual;
objQueryModel.IsSubmitEqual = IsSubmitEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new TC_OA_BigGoodsDetailBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <InquirePriceModel> GetInquirePriceList(string SortColumns, int StartRecord, int MaxRecords, int InquirePriceCodeEqual, string ProjectNameEqual, string InquireObjectEqual, string RequirementEqual, int AduitingEqual, string Field1Equal)
{
List <InquirePriceModel> models = new List <InquirePriceModel>();
InquirePriceQueryModel objQueryModel = new InquirePriceQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.InquirePriceCodeEqual = InquirePriceCodeEqual;
objQueryModel.ProjectNameEqual = ProjectNameEqual;
objQueryModel.InquireObjectEqual = InquireObjectEqual;
objQueryModel.RequirementEqual = RequirementEqual;
objQueryModel.AduitingEqual = AduitingEqual;
objQueryModel.Field1Equal = Field1Equal;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new InquirePriceBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
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 InquirePriceBLL().ModifyPassAuditing(Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public int Update(TY_ReferendumReportModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new TY_ReferendumReportBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public List <TCheckPaymentSumModel> GetTCheckPaymentSumList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string SendUnitEqual, DateTime SumDateEqual, string AuditingEqual)
{
List <TCheckPaymentSumModel> models = new List <TCheckPaymentSumModel>();
TCheckPaymentSumQueryModel objQueryModel = new TCheckPaymentSumQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.SendUnitEqual = SendUnitEqual;
objQueryModel.SumDateEqual = SumDateEqual;
objQueryModel.AuditingEqual = AuditingEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
models = new TCheckPaymentSumBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public TC_OA_BigGoodsModel GetTC_OA_BigGoods(int Code)
{
TC_OA_BigGoodsModel model = new TC_OA_BigGoodsModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new TC_OA_BigGoodsBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public InquirePriceModel GetInquirePrice(int Code)
{
InquirePriceModel model = new InquirePriceModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new InquirePriceBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public TY_ReferendumReportModel GetTY_ReferendumReport(int Code)
{
TY_ReferendumReportModel model = new TY_ReferendumReportModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
try
{
model = new TY_ReferendumReportBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public ContractBillModel GetContractBill(int Code)
{
ContractBillModel model = new ContractBillModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new ContractBillBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public TC_OA_PaymentSumModel GetTC_OA_PaymentSum(int Code)
{
TC_OA_PaymentSumModel model = new TC_OA_PaymentSumModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new TC_OA_PaymentSumBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <TC_OA_PaymentSumModel> GetTC_OA_PaymentSumListOne(int Code)
{
List <TC_OA_PaymentSumModel> list = new List <TC_OA_PaymentSumModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
TC_OA_PaymentSumBLL mbll = new TC_OA_PaymentSumBLL();
list.Add(mbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <TY_ReferendumReportModel> GetTY_ReferendumReportListOne(int Code)
{
List <TY_ReferendumReportModel> list = new List <TY_ReferendumReportModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
try
{
TY_ReferendumReportBLL tbll = new TY_ReferendumReportBLL();
list.Add(tbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <ContractBillModel> GetContractBillListOne(int Code)
{
List <ContractBillModel> list = new List <ContractBillModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
ContractBillBLL lbll = new ContractBillBLL();
list.Add(lbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <TC_OA_SmallGoodsDetailModel> GetTC_OA_SmallGoodsDetailListOne(int Code)
{
List <TC_OA_SmallGoodsDetailModel> list = new List <TC_OA_SmallGoodsDetailModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
TC_OA_SmallGoodsDetailBLL lbll = new TC_OA_SmallGoodsDetailBLL();
list.Add(lbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <InquirePriceModel> GetInquirePriceListOne(int Code)
{
List <InquirePriceModel> list = new List <InquirePriceModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
InquirePriceBLL ebll = new InquirePriceBLL();
list.Add(ebll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <TC_OA_PaymentSumModel> GetTC_OA_PaymentSumList(TC_OA_PaymentSumQueryModel QueryModel)
{
List <TC_OA_PaymentSumModel> models = new List <TC_OA_PaymentSumModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
if (QueryModel == null)
{
QueryModel = new TC_OA_PaymentSumQueryModel();
}
models = new TC_OA_PaymentSumBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <ContractBillModel> GetContractBillList(ContractBillQueryModel QueryModel)
{
List <ContractBillModel> models = new List <ContractBillModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new ContractBillQueryModel();
}
models = new ContractBillBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <TC_OA_PurchasePriceModel> GetTC_OA_PurchasePriceList(TC_OA_PurchasePriceQueryModel QueryModel)
{
List <TC_OA_PurchasePriceModel> models = new List <TC_OA_PurchasePriceModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new TC_OA_PurchasePriceQueryModel();
}
models = new TC_OA_PurchasePriceBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <TY_ReferendumReportModel> GetTY_ReferendumReportList(TY_ReferendumReportQueryModel QueryModel)
{
List <TY_ReferendumReportModel> models = new List <TY_ReferendumReportModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
try
{
if (QueryModel == null)
{
QueryModel = new TY_ReferendumReportQueryModel();
}
models = new TY_ReferendumReportBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <TC_OA_UnusualModel> GetTC_OA_UnusualList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string ProjectCodeEqual, string ProjectNameEqual, string UserCodeEqual, DateTime ApplayDateEqual, string CoustomTypeEqual, string CoustomNameEqual, string TelephoneEqual, string EmailEqual, string RemarkEqual, string ReasonEqual, string suggestEqual, int AuditingEqual)
{
List <TC_OA_UnusualModel> models = new List <TC_OA_UnusualModel>();
TC_OA_UnusualQueryModel objQueryModel = new TC_OA_UnusualQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.ProjectCodeEqual = ProjectCodeEqual;
objQueryModel.ProjectNameEqual = ProjectNameEqual;
objQueryModel.UserCodeEqual = UserCodeEqual;
objQueryModel.ApplayDateEqual = ApplayDateEqual;
objQueryModel.CoustomTypeEqual = CoustomTypeEqual;
objQueryModel.CoustomNameEqual = CoustomNameEqual;
objQueryModel.TelephoneEqual = TelephoneEqual;
objQueryModel.EmailEqual = EmailEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.ReasonEqual = ReasonEqual;
objQueryModel.suggestEqual = suggestEqual;
objQueryModel.AuditingEqual = AuditingEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new TC_OA_UnusualBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
