110,571
社区成员
发帖
与我相关
我的任务
分享
//conn是经操作层到业务层传来的
public static int execute_simple(string sql,SqlConnection conn)
{
try
{
SqlCommand com = new SqlCommand(sql, conn);
com.ExecuteNonQuery();
com.Dispose();
return 1;
}
catch (Exception e)
{
//AppException errlog = new AppException();
//errlog.ExceptionLog("execute_simple sqlmake层错误", e.Message);
string fileName = DateTime.Now.ToString("yyyyMMddhhmmss") + ".txt";
write_error_tolog.ErrorLog("sqlmaker_forcycle.execute_simple错误位置\r" + e.ToString(), fileName, "/ErrorLog/");
return 0;
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DAL;
namespace BLL
{
public class receivedlist_bll
{
public DataTable getexcomitem()
{
receivedlist_dal receivelistdal = new receivedlist_dal();
return receivelistdal.getexcomitem();
}
public DataTable getcutorderitems(string weblogin)
{
receivedlist_dal receivelistdal = new receivedlist_dal();
return receivelistdal.getcutorderitems(weblogin);
}
public bool getoneitem(string tmpkey)
{
receivedlist_dal sysdal = new receivedlist_dal();
return sysdal.getoneitem(tmpkey);
}
public string getoneitem2(string tmpkey)
{
receivedlist_dal sysdal = new receivedlist_dal();
return sysdal.getoneitem2(tmpkey);
}
public bool getoneitem3(string tmpkey)
{
receivedlist_dal sysdal = new receivedlist_dal();
return sysdal.getoneitem3(tmpkey);
}
public int retreccount(string weblogin)
{
receivedlist_dal receivelistdal = new receivedlist_dal();
return receivelistdal.retreccount(weblogin);
}
public DataTable getdataset_curentpage(string weblogin, int pageIndex, int pageSize)
{
receivedlist_dal rettable = new receivedlist_dal();
return rettable.getdataset_curentpage(weblogin, pageIndex, pageSize);
}
public bool addexpress(string tmpexnum,string tmpexcom,string weblogin)
{
receivedlist_dal dal = new receivedlist_dal();
return dal.addexpress(tmpexnum, tmpexcom,weblogin);
}
public bool delorderitem(int itemid)
{
receivedlist_dal dal = new receivedlist_dal();
return dal.delorderitem(itemid);
}
public bool updateitem(string cutremark,int itemid)
{
receivedlist_dal dal = new receivedlist_dal();
return dal.updateitem(cutremark,itemid);
}
}
}