public void SaleCarBillRemoved_Insert(FactoryArgs args, t_nText SaleInBillRemoveJson, t_nText SaleOutBillRemoveJson)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleInBillRemoveJson", SaleInBillRemoveJson));
parms.Add(new LBDbParameter("SaleOutBillRemoveJson", SaleOutBillRemoveJson));
parms.Add(new LBDbParameter("RemovedBy", new t_String(args.LoginName)));
string strSQL = @"
insert SaleCarBillRemoved(SaleInBillRemoveJson,SaleOutBillRemoveJson,RemovedTime,RemovedBy)
values(@SaleInBillRemoveJson,@SaleOutBillRemoveJson,getdate(),@RemovedBy)
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Update(FactoryArgs args, t_BigID ReportViewID,
t_String ReportViewName, t_nText ReportDataSource)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReportViewID", ReportViewID));
parms.Add(new LBDbParameter("ReportViewName", ReportViewName));
parms.Add(new LBDbParameter("ReportDataSource", ReportDataSource));
string strSQL = @"
update dbo.DbReportView
set ReportViewName=@ReportViewName,
ReportDataSource=@ReportDataSource
where ReportViewID = @ReportViewID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Insert(FactoryArgs args, out t_BigID ReportViewID,
t_String ReportViewName, t_nText ReportDataSource)
{
ReportViewID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReportViewID", ReportViewID, true));
parms.Add(new LBDbParameter("ReportViewName", ReportViewName));
parms.Add(new LBDbParameter("ReportDataSource", ReportDataSource));
string strSQL = @"
insert dbo.DbReportView( ReportViewName,ReportDataSource)
values(@ReportViewName,@ReportDataSource)
set @ReportViewID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReportViewID.SetValueWithObject(parms["ReportViewID"].Value);
}
public void Update(FactoryArgs args, t_BigID ReportViewID,
t_String ReportViewName, t_nText ReportDataSource)
{
_DALDbReportView.Update(args, ReportViewID, ReportViewName, ReportDataSource);
}
public void Insert(FactoryArgs args, out t_BigID ReportViewID,
t_String ReportViewName, t_nText ReportDataSource)
{
_DALDbReportView.Insert(args, out ReportViewID, ReportViewName, ReportDataSource);
}
