/// <summary>
/// ɾ������
/// </summary>
/// <param name="ID">D_Saver��ID</param>
/// <returns>"0101"��ʾ�ɹ���"0"��ʾʧ��</returns>
public static string Delete(long ID)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Search.SearchDal();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,8,ID),
};
try
{
bSuc = db.TransactSql(visitor, "Delete", prams, out nEffectRows);
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
if (bSuc && nEffectRows > 0)
return "0101";
else
return "0";
}
/// <summary>
/// ��������Ϣ
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static string Update(Model.Search.C_SelectModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Search.SearchDal();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@As", SqlDbType.VarChar,50, Item.As),
db.MakeInParam("@Show", SqlDbType.Bit,4, Item.Show),
db.MakeInParam("@Place", SqlDbType.BigInt,8, Item.Place),
db.MakeInParam("@ID", SqlDbType.BigInt,50, Item.ID),
};
try
{
bSuc = db.TransactSql(visitor, "Update", prams, out nEffectRows);
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
if (bSuc && nEffectRows > 0)
return "0101";
else
return "0";
}
/// <summary>
/// ��ѯȫ��������Ŀ
/// </summary>
/// <returns></returns>
public static DataSet Select_Select()
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Search.SearchDal();
DataSet ds = new DataSet();
try
{
ds = db.ReturnDataSet(visitor, "Select_V_C_Select", "V_C_Select");
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ds;
}