public static bool Delete(string S_Pr)
{
bool retvalue = true;
DataBase db = new DataBase();
DataBaseVisitor visitor = new CardDAL();
SqlParameter[] prams =
{
db.MakeInParam("@Card",SqlDbType.VarChar,50,S_Pr)
};
try
{
db.TransactSql(visitor, "Delete", prams);
}
catch (Exception err)
{
db.Dispose();
MessageBox.Show(err.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
finally
{
db.Dispose();
}
return retvalue;
}
/// <summary>
/// 插入一条操作记录，并返回他的编号
/// </summary>
/// <param name="Content"></param>
/// <returns></returns>
public static string Insert(string Content)
{
string ret_Code = MaxID().ToString();
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.DL_Run();
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,8, long.Parse(ret_Code)),
db.MakeInParam("@Code", SqlDbType.VarChar,50,ret_Code),
db.MakeInParam("@Work", SqlDbType.VarChar,50, Content),
db.MakeInParam("@InTime", SqlDbType.DateTime,8, DateTime.Now),
db.MakeInParam("@OperCode", SqlDbType.VarChar,50, Model.User.LUser.Code),
db.MakeInParam("@TableNum", SqlDbType.VarChar,50, Model.User.LUser.TableNum)
};
try
{
db.TransactSql(visitor, "Insert", prams);
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ret_Code;
}
public static string Update(Model.Video.D_Video Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Video.VideoVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@VIDEOname",SqlDbType .Char ,10,Item.VIDEO_name),
db.MakeInParam("@VIDEOtable",SqlDbType .VarChar ,50,Item.VIDEO_table ),
db.MakeInParam("@VIDEOStandard",SqlDbType.Int ,4,Item.VIDEO_Standard ),
db.MakeInParam("@VIDEOSource",SqlDbType.Int,4,Item.VIDEO_Source ),
db.MakeInParam("@VIDEOBrightness",SqlDbType.Int,4,Item.VIDEO_Brightness ),
db.MakeInParam("@VIDEOContrast",SqlDbType.Int,4,Item.VIDEO_Contrast ),
db.MakeInParam("@VIDEOHue",SqlDbType.Int,4,Item.VIDEO_Hue ),
db.MakeInParam("@VIDEOSaturation",SqlDbType.Int,4,Item.VIDEO_Saturation ),
db.MakeInParam("@VIDEOSuality",SqlDbType.Int,4,Item.VIDEO_Suality)
};
try
{
bSuc = db.TransactSql(visitor, "Set_Video", 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 bool Insert(DC_Power Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new PowerDAL();
bool Flag = false, ReFlag = false;
int N = 0;
SqlParameter[] prams ={
db.MakeInParam("@Id", SqlDbType.BigInt,0,PublicFun.PublicFun.MaxId("DC_Power")),
db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code),
db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name),
db.MakeInParam("@ParentCode", SqlDbType.VarChar,50, Item.ParentCode),
db.MakeInParam("@RuleName", SqlDbType.VarChar,50, Item.RuleName)
};
try
{
ReFlag = db.TransactSql(visitor, "Insert", prams, out N);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
if (ReFlag && N > 0)
{
Flag = true;
}
return Flag;
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Item">model</param>
/// <returns>"0101"表示成功，"0"表示失败</returns>
public static string Insert(D_CarCodeModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new D_CarCodeVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_CarCode")),
db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code),
db.MakeInParam("@CarCode", SqlDbType.VarChar,50, Item.CarCode),
db.MakeInParam("@Tare", SqlDbType.Float,12, Item.Tare),
db.MakeInParam("@Driver", SqlDbType.VarChar,50, Item.Driver),
};
try
{
bSuc = db.TransactSql(visitor, "Insert", 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 Insert(Model.Count.D_StatProjectModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.VarChar,50, PublicFun.PublicFun.MaxId("D_StatProject")),
db.MakeInParam("@Code", SqlDbType.VarChar,50,PublicFun.PublicFun.MaxId("D_StatProject")),
db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name),
};
try
{
bSuc = db.TransactSql(visitor, "Insert", 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 bool Update(D_Bill Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new BillDAL();
bool Flag = false, ReFlag = false;
int N = 0;
SqlParameter[] prams ={
db.MakeInParam("@BillName", SqlDbType.VarChar,50, Item.BillName),
db.MakeInParam("@PrintTitle", SqlDbType.VarChar,50, Item.PrintTitle),
db.MakeInParam("@Preview", SqlDbType.Bit,50, Item.Preview),
db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id)
};
try
{
ReFlag = db.TransactSql(visitor, "Update", prams, out N);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
if (ReFlag && N > 0)
{
Flag = true;
}
return Flag;
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static bool Update(C_Weight Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WeightDAL();
bool Flag = false, ReFlag = false;
int N = 0;
SqlParameter[] prams ={
db.MakeInParam("@Save", SqlDbType.Bit,0, Item.Save),
db.MakeInParam("@Show", SqlDbType.Bit,0, Item.Show),
db.MakeInParam("@Time", SqlDbType.BigInt,0, Item.Time),
db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id)
};
try
{
ReFlag = db.TransactSql(visitor, "Update", prams, out N);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
if (ReFlag && N > 0)
{
Flag = true;
}
return Flag;
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static string AddData(WSV.Model.Weight.WeightModel Weight)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.Int,4, BLL.PublicFun.PublicFun.MaxId("D_Saver")),
db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code),
db.MakeInParam("@CarCode", SqlDbType.VarChar,50, Weight.Txt.CarCode),
db.MakeInParam("@Item", SqlDbType.VarChar,50, Weight.Txt.Item),
db.MakeInParam("@Specs", SqlDbType.VarChar,50, Weight.Txt.Specs),
db.MakeInParam("@Place", SqlDbType.VarChar,50, Weight.Txt.Place),
db.MakeInParam("@Send", SqlDbType.VarChar,50, Weight.Txt.Send),
db.MakeInParam("@Accept", SqlDbType.VarChar,50, Weight.Txt.Accept),
db.MakeInParam("@Carry", SqlDbType.VarChar,50, Weight.Txt.Carry),
db.MakeInParam("@Model", SqlDbType.VarChar,50, Weight.Txt.Model),
db.MakeInParam("@Driver", SqlDbType.VarChar,50, Weight.Txt.Driver),
db.MakeInParam("@Spare", SqlDbType.VarChar,50, Weight.Txt.Spare),
db.MakeInParam("@Type", SqlDbType.VarChar,50, Weight.Txt.Type),
db.MakeInParam("@Card", SqlDbType.VarChar,50, Weight.Txt.Card),
db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Weight.Txt.Plan_Code),
db.MakeInParam("@G_Table", SqlDbType.VarChar,50, Weight.StateFun.G_Table),
db.MakeInParam("@T_Table", SqlDbType.VarChar,50, Weight.StateFun.T_Table),
db.MakeInParam("@G_Oper", SqlDbType.VarChar,50, Weight.StateFun.G_Oper),
db.MakeInParam("@T_Oper", SqlDbType.VarChar,50, Weight.StateFun.T_Oper),
db.MakeInParam("@Gross", SqlDbType.Decimal, 10, Weight.Float.Gross),
db.MakeInParam("@Tare", SqlDbType.Decimal, 10, Weight.Float.Tare),
db.MakeInParam("@Net", SqlDbType.Decimal, 10, Weight.Float.Net),
db.MakeInParam("@EndNet", SqlDbType.Decimal, 10, Weight.Float.EndNet),
db.MakeInParam("@Impurity", SqlDbType.Decimal, 10, Weight.Float.Impurity),
db.MakeInParam("@ImpurityRate", SqlDbType.Decimal, 10, Weight.Float.ImpurityRate),
db.MakeInParam("@DeductWei", SqlDbType.Decimal, 10, Weight.Float.DeductWei),
db.MakeInParam("@DeductRate", SqlDbType.Decimal, 10, Weight.Float.DeductRate),
db.MakeInParam("@Cube", SqlDbType.Decimal, 10, Weight.Float.Cube),
db.MakeInParam("@Cubety", SqlDbType.Decimal, 10, Weight.Float.Cubety),
db.MakeInParam("@InhereWei", SqlDbType.Decimal, 10, Weight.Float.InhereWei),
db.MakeInParam("@DifferWei", SqlDbType.Decimal, 10, Weight.Float.DifferWei),
db.MakeInParam("@Price", SqlDbType.Decimal, 10, Weight.Float.Price),
db.MakeInParam("@Money", SqlDbType.Decimal, 10, Weight.Float.Money),
db.MakeInParam("@State", SqlDbType.Decimal, 10, Weight.StateFun.State),
db.MakeInParam("@G_Time", SqlDbType.VarChar, 50, Weight.StateFun.G_Time),
db.MakeInParam("@T_Time", SqlDbType.VarChar, 50, Weight.StateFun.T_Time),
db.MakeInParam("@N_Time", SqlDbType.VarChar, 50, Weight.StateFun.N_Time),
};
try
{
bSuc = db.TransactSql(visitor, "AddData", 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 bool Del(string Id)
{
DataBase db = new DataBase();
bool Flag = false;
try
{
if (db.TransactSql("delete from DC_Power where id in(" + Id + ")"))
{
Flag = true;
}
}
catch (Exception ex)
{
throw ex;
}
return Flag;
}
/// <summary>
/// 备份数据库
/// </summary>
/// <param name="bakUpName"></param>
public static bool BackUp(string bakUpName)
{
bool Flag = true;
DataBase db = new DataBase();
try
{
db.TransactSql("BACKUP DATABASE WSV TO DISK ='" + bakUpName + "'");
}
catch (Exception ex)
{
Flag = false;
throw ex;
}
finally
{
db.Dispose();
}
return Flag;
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static string AddData(Model.Plan.D_Plan Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
bool bSuc = false;
int nEffectRows = 0;
long id = BLL.PublicFun.PublicFun.MaxId("D_Plan");
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,12, BLL.PublicFun.PublicFun.MaxId("D_Plan")),
db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Item.Plan_Code),
db.MakeInParam("@Plan_CountWay", SqlDbType.VarChar,50, Item.Plan_CountWay),
db.MakeInParam("@Plan_Item", SqlDbType.VarChar,50, Item.Plan_Item),
db.MakeInParam("@Plan_Specs", SqlDbType.VarChar,50, Item.Plan_Specs),
db.MakeInParam("@Plan_Type", SqlDbType.VarChar,50, Item.Plan_Type),
db.MakeInParam("@Plan_Send", SqlDbType.VarChar,50, Item.Plan_Send),
db.MakeInParam("@Plan_Accept", SqlDbType.VarChar,50, Item.Plan_Accept),
db.MakeInParam("@Plan_Num", SqlDbType.Decimal,50, Item.Plan_Num),
db.MakeInParam("@Plan_SpareNum", SqlDbType.Decimal,50, Item.Plan_SpareNum),
db.MakeInParam("@Plan_Money", SqlDbType.Decimal,50, Item.Plan_Money),
db.MakeInParam("@Plan_SpareMoney", SqlDbType.Decimal,50, Item.Plan_SpareMoney),
db.MakeInParam("@Remark", SqlDbType.VarChar,50, Item.Remark),
db.MakeInParam("@Begin_Time", SqlDbType.VarChar,50, Item.Begin_Time),
db.MakeInParam("@End_Time", SqlDbType.VarChar,50, Item.End_Time),
};
try
{
bSuc = db.TransactSql(visitor, "Insert", 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="Code">�������</param>
/// <returns></returns>
public static string Delete(string ProCode)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, ProCode),
};
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="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>"0101"表示成功，"0"表示失败</returns>
public static string Update(Model.Record.D_TypeModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Record.D_TypeVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name),
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>
/// <param name="values"></param>
public static void Save_Card(WeightModel values)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.CardDAL();
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Card")),
db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card),
db.MakeInParam("@CarCode",SqlDbType.VarChar,50,values.Txt.CarCode),
db.MakeInParam("@Type",SqlDbType.VarChar,50,values.Txt.Type),
db.MakeInParam("@Item",SqlDbType.VarChar,50,values.Txt.Item),
db.MakeInParam("@Specs",SqlDbType.VarChar,50,values.Txt.Specs),
db.MakeInParam("@Place",SqlDbType.VarChar,50,values.Txt.Place),
db.MakeInParam("@Send",SqlDbType.VarChar,50,values.Txt.Send),
db.MakeInParam("@Accept",SqlDbType.VarChar,50,values.Txt.Accept),
db.MakeInParam("@Carry",SqlDbType.VarChar,50,values.Txt.Carry),
db.MakeInParam("@Model",SqlDbType.VarChar,50,values.Txt.Model),
db.MakeInParam("@Driver",SqlDbType.VarChar,50,values.Txt.Driver),
db.MakeInParam("@Spare",SqlDbType.VarChar,50,values.Txt.Spare),
db.MakeInParam("@Tare",SqlDbType.Float,50,values.Float.Tare),
db.MakeInParam("@State",SqlDbType.Bit,1,values.StateFun.State)
};
try
{
db.TransactSql(visitor, "Save_Card", prams);
}
catch (Exception err)
{
db.Dispose();
MessageBox.Show("���ݲ�ȫ��", "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
db.Dispose();
}
}
/// <summary>
/// ������
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static string Update(Model.Count.D_StatProjectModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Type", SqlDbType.VarChar,50, Item.Type),
db.MakeInParam("@SataType", SqlDbType.VarChar,50, Item.SataType),
db.MakeInParam("@Flag", SqlDbType.VarChar,50, Item.Flag),
db.MakeInParam("@Month", SqlDbType.VarChar,50, Item.Month),
db.MakeInParam("@Day", SqlDbType.VarChar,50, Item.Day),
db.MakeInParam("@BeginTime", SqlDbType.VarChar,50, Item.BeginTime),
db.MakeInParam("@EndTime", SqlDbType.VarChar,50, Item.EndTime),
db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code),
};
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>
/// <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>
/// <param name="Item">model</param>
/// <returns></returns>
public static bool Update(D_User Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new UsersDAL();
bool Flag= false,ReFlag=false;
int N= 0;
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code),
db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name),
db.MakeInParam("@Uid", SqlDbType.VarChar,50, Item.Uid),
db.MakeInParam("@Pwd", SqlDbType.VarChar,50, Item.Pwd),
db.MakeInParam("@Role", SqlDbType.VarChar,50, Item.Role),
db.MakeInParam("@Used", SqlDbType.Bit,0, Item.Used),
db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id)
};
try
{
ReFlag= db.TransactSql(visitor, "Update", prams, out N);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
if (ReFlag && N > 0)
{
Flag = true;
}
return Flag;
}
/// <summary>
/// 操作是否作废数据
/// </summary>
/// <param name="ID">表ID</param>
/// <param name="Used">是否作废</param>
/// <returns>"0101"表示成功，"0"表示失败</returns>
public static string Update_Used(long ID, bool Used)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new D_BaseVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Used", SqlDbType.Bit,8, Used),
db.MakeInParam("@ID", SqlDbType.BigInt,50,ID),
};
try
{
bSuc = db.TransactSql(visitor, "Update_Used", 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="Code">编号</param>
/// <returns></returns>
public static string UpdateCheck(string Code)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, Code),
};
try
{
bSuc = db.TransactSql(visitor, "OnCheck", 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="RoleCode">角色编号</param>
/// <param name="PowerCode">权限编号</param>
/// <returns></returns>
private static bool AddRolePower(string RoleCode,string RolePower)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new RoleDAL();
bool Flag = true;
int N = 0;
try
{
SqlParameter[] prams;
prams =new SqlParameter[]{
db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,RoleCode),
};
db.TransactSql(visitor, "DelRolePower", prams);
string[] PowerList =RolePower.Split(',');
for (int i = 0; i < PowerList.Length; i++)
{
db = new DataBase();
prams =new SqlParameter[]{
db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,RoleCode),
db.MakeInParam("@PowerCode", SqlDbType.VarChar,50,PowerList[i])
};
db.TransactSql(visitor, "AddRolePower", prams);
}
}
catch (Exception ex)
{
Flag = false;
throw ex;
}
finally
{
db.Dispose();
}
return Flag;
}
public static void upSpare(string Type, string Plan_Code, decimal Spare)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.PlanDAL();
SqlParameter[] prams = new SqlParameter[2];
if (Type == "01")
{
prams[0] = db.MakeInParam("@Plan_Code", SqlDbType.VarChar, 50, Plan_Code);
prams[1] = db.MakeInParam("@Plan_SpareNum", SqlDbType.Decimal, 50, Spare);
try
{
db.TransactSql(visitor, "Plan_SpareNum", prams);
}
catch (Exception e)
{
db.Dispose();
return;
}
}
if (Type == "02")
{
prams[0] = db.MakeInParam("@Plan_Code", SqlDbType.VarChar, 50, Plan_Code);
prams[1] = db.MakeInParam("@Plan_SpareMoney", SqlDbType.Decimal, 50, Spare);
try
{
db.TransactSql(visitor, "Plan_SpareMoney", prams);
}
catch (Exception e)
{
db.Dispose();
return;
}
}
}
/// <summary>
/// �����¼�����
/// </summary>
/// <param name="Sql"></param>
/// <param name="values"></param>
public static void Save_Data(string Sql, WeightModel values)
{
//�����¼�
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
if (Sql == "yucun")
{
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Saver")),
db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code),
db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card),
db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode),
db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type),
db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item),
db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs),
db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place),
db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send),
db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept),
db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry),
db.MakeInParam("@Model", SqlDbType.VarChar,50,values.Txt.Model),
db.MakeInParam("@Cube", SqlDbType.Decimal,50, values.Float.Cube),
db.MakeInParam("@Cubety", SqlDbType.Decimal,50, values.Float.Cubety),
db.MakeInParam("@InhereWei", SqlDbType.Decimal,50, values.Float.InhereWei),
db.MakeInParam("@DifferWei", SqlDbType.Decimal,50, values.Float.DifferWei),
db.MakeInParam("@Driver", SqlDbType.VarChar,50, values.Txt.Driver),
db.MakeInParam("@Spare", SqlDbType.VarChar,50, values.Txt.Spare),
db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross),
db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time),
db.MakeInParam("@Tare", SqlDbType.Decimal,50, values.Float.Tare),
db.MakeInParam("@T_Time",SqlDbType.VarChar,50,values.StateFun.T_Time),
db.MakeInParam("@Net",SqlDbType.Decimal,50,values.Float.Net),
db.MakeInParam("@EndNet",SqlDbType.Decimal,50,values.Float.EndNet),
db.MakeInParam("@N_Time",SqlDbType.VarChar,50,values.StateFun.N_Time),
db.MakeInParam("@Price",SqlDbType.Decimal,50,values.Float.Price),
db.MakeInParam("@Money",SqlDbType.Decimal,50,values.Float.Money),
db.MakeInParam("@DeductWei",SqlDbType.Decimal,50,values.Float.DeductWei),
db.MakeInParam("@DeductRate",SqlDbType.Decimal,50,values.Float.DeductRate),
db.MakeInParam("@Impurity",SqlDbType.Decimal,50,values.Float.Impurity),
db.MakeInParam("@ImpurityRate",SqlDbType.Decimal,50,values.Float.ImpurityRate),
db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,WSV.Model.User.LUser.Code),
db.MakeInParam("@Accepter",SqlDbType.VarChar,50,WSV.Model.User.CUser.Code),
db.MakeInParam("@State",SqlDbType.Bit,1,1),
db.MakeInParam("@Plan_Code",SqlDbType.VarChar,50,values.Txt.Plan_Code)
};
try
{
db.TransactSql(visitor, Sql, prams);
}
catch (Exception err)
{
db.Dispose();
MessageBox.Show("���ݲ�ȫ��", "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
db.Dispose();
}
}
else if (Sql == "IdCard")
{
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Saver")),
db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code),
db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card),
db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode),
db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type),
db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item),
db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs),
db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place),
db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send),
db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept),
db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry),
db.MakeInParam("@Model", SqlDbType.VarChar,50,values.Txt.Model),
db.MakeInParam("@Cube", SqlDbType.Decimal,50, values.Float.Cube),
db.MakeInParam("@Cubety", SqlDbType.Decimal,50, values.Float.Cubety),
db.MakeInParam("@InhereWei", SqlDbType.Decimal,50, values.Float.InhereWei),
db.MakeInParam("@DifferWei", SqlDbType.Decimal,50, values.Float.DifferWei),
db.MakeInParam("@Driver", SqlDbType.VarChar,50, values.Txt.Driver),
db.MakeInParam("@Spare", SqlDbType.VarChar,50, values.Txt.Spare),
db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross),
db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time),
db.MakeInParam("@Tare", SqlDbType.Decimal,50, values.Float.Tare),
db.MakeInParam("@T_Time",SqlDbType.VarChar,50,values.StateFun.T_Time),
db.MakeInParam("@Net",SqlDbType.Decimal,50,values.Float.Net),
db.MakeInParam("@EndNet",SqlDbType.Decimal,50,values.Float.EndNet),
db.MakeInParam("@N_Time",SqlDbType.VarChar,50,values.StateFun.N_Time),
db.MakeInParam("@Price",SqlDbType.Decimal,50,values.Float.Price),
db.MakeInParam("@Money",SqlDbType.Decimal,50,values.Float.Money),
db.MakeInParam("@DeductWei",SqlDbType.Decimal,50,values.Float.DeductWei),
db.MakeInParam("@DeductRate",SqlDbType.Decimal,50,values.Float.DeductRate),
db.MakeInParam("@Impurity",SqlDbType.Decimal,50,values.Float.Impurity),
db.MakeInParam("@ImpurityRate",SqlDbType.Decimal,50,values.Float.ImpurityRate),
db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,WSV.Model.User.LUser.Code),
db.MakeInParam("@Accepter",SqlDbType.VarChar,50,WSV.Model.User.CUser.Code),
db.MakeInParam("@State",SqlDbType.Bit,1,1),
db.MakeInParam("@Plan_Code",SqlDbType.VarChar,50,values.Txt.Plan_Code)
};
try
{
db.TransactSql(visitor, Sql, prams);
}
catch (Exception err)
{
db.Dispose();
MessageBox.Show("���ݲ�ȫ��", "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
db.Dispose();
}
}
}
/// <summary>
/// ����ͼƬ
/// </summary>
/// <param name="Sql"></param>
/// <param name="retselectflag"></param>
/// <param name="Values"></param>
public static void Save_Video(string Sql, bool retselectflag, WeightModel Values)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
SqlParameter[] prams = new SqlParameter[5];
if (!retselectflag)
{
if (Sql == "insertM")
{
prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code);
if (Values.StateFun.G_Image1 != null)
prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, Values.StateFun.G_Image1.Length, Values.StateFun.G_Image1);
else
prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.G_Image2 != null)
prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, Values.StateFun.G_Image2.Length, Values.StateFun.G_Image2);
else
prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.G_Image3 != null)
prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, Values.StateFun.G_Image3.Length, Values.StateFun.G_Image3);
else
prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.G_Image4 != null)
prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, Values.StateFun.G_Image4.Length, Values.StateFun.G_Image4);
else
prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, 0, DBNull.Value);
}
else if (Sql == "insertP")
{
prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code);
if (Values.StateFun.T_Image1 != null)
prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, Values.StateFun.T_Image1.Length, Values.StateFun.T_Image1);
else
prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.T_Image2 != null)
prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, Values.StateFun.T_Image2.Length, Values.StateFun.T_Image2);
else
prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.T_Image3 != null)
prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, Values.StateFun.T_Image3.Length, Values.StateFun.T_Image3);
else
prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.T_Image4 != null)
prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, Values.StateFun.T_Image4.Length, Values.StateFun.T_Image4);
else
prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, 0, DBNull.Value);
}
}
else
{
if (Sql == "updateM")
{
prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code);
if (Values.StateFun.G_Image1 != null)
prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, Values.StateFun.G_Image1.Length, Values.StateFun.G_Image1);
else
prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.G_Image2 != null)
prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, Values.StateFun.G_Image2.Length, Values.StateFun.G_Image2);
else
prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.G_Image3 != null)
prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, Values.StateFun.G_Image3.Length, Values.StateFun.G_Image3);
else
prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.G_Image4 != null)
prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, Values.StateFun.G_Image4.Length, Values.StateFun.G_Image4);
else
prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, 0, DBNull.Value);
}
else if (Sql == "updateP")
{
prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code);
if (Values.StateFun.T_Image1 != null)
prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, Values.StateFun.T_Image1.Length, Values.StateFun.T_Image1);
else
prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.T_Image2 != null)
prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, Values.StateFun.T_Image2.Length, Values.StateFun.T_Image2);
else
prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.T_Image3 != null)
prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, Values.StateFun.T_Image3.Length, Values.StateFun.T_Image3);
else
prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, 0, DBNull.Value);
if (Values.StateFun.T_Image4 != null)
prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, Values.StateFun.T_Image4.Length, Values.StateFun.T_Image4);
else
prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, 0, DBNull.Value);
}
}
try
{
db.TransactSql(visitor, Sql, prams);
}
catch (Exception err)
{
db.Dispose();
MessageBox.Show("����" + err.Message, "������Ϣ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
db.Dispose();
}
}
/// <summary>
/// 是否作废数据
/// </summary>
/// <param name="ID">表ID</param>
/// <param name="Used">是否作废</param>
/// <returns>"0101"表示成功，"0"表示失败</returns>
public static string Update_Used(string Code, int Used)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Plan_Used", SqlDbType.Bit,8, Used),
db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50,Code),
};
try
{
bSuc = db.TransactSql(visitor, "Used", 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="CurveFlag"></param>
/// <param name="CurveCode"></param>
/// <param name="values"></param>
public static void Save_Curve(string CurveFlag, string CurveCode, WeightModel values)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
SqlParameter[] prams = new SqlParameter[2];
prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, CurveCode);
if (values.StateFun.Curve != null)
prams[1] = db.MakeInParam("@Curve", SqlDbType.Binary, values.StateFun.Curve.Length, values.StateFun.Curve);
else
prams[1] = db.MakeInParam("@Curve", SqlDbType.Binary, 0, DBNull.Value);
try
{
db.TransactSql(visitor, CurveFlag, prams);
}
catch (Exception err)
{
db.Dispose();
MessageBox.Show("����" + err.Message, "������Ϣ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
db.Dispose();
}
}
public static void SaveCard(string sql, WeightModel values)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
if (sql == "one")
{
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Saver")),
db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code),
db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card),
db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode),
db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type),
db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item),
db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs),
db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place),
db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send),
db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept),
db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry),
db.MakeInParam("@Model", SqlDbType.VarChar,50,values.Txt.Model),
db.MakeInParam("@Driver", SqlDbType.VarChar,50, values.Txt.Driver),
db.MakeInParam("@Spare", SqlDbType.VarChar,50, values.Txt.Spare),
db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross),
db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time),
db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,WSV.Model.User.LUser.Code),
};
try
{
db.TransactSql(visitor, sql, prams);
}
catch (Exception er)
{
MessageBox.Show(er.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (sql == "two")
{
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code),
db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode),
db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type),
db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item),
db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs),
db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place),
db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send),
db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept),
db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry),
db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross),
db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time),
db.MakeInParam("@Tare", SqlDbType.Decimal,50, values.Float.Tare),
db.MakeInParam("@T_Time",SqlDbType.VarChar,50,values.StateFun.T_Time),
db.MakeInParam("@Net",SqlDbType.Decimal,50,values.Float.Net),
db.MakeInParam("@N_Time",SqlDbType.VarChar,50,values.StateFun.N_Time),
//db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,values.StateFun.G_Oper),
db.MakeInParam("@T_Oper",SqlDbType.VarChar,50,values.StateFun.T_Oper),
db.MakeInParam("@State",SqlDbType.Bit,1,1)
};
try
{
db.TransactSql(visitor, sql, prams);
}
catch (Exception er)
{
MessageBox.Show(er.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public static string AddMaintenance(Model.MyLog.DL_Maintenance DL_MainItem)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@ID", SqlDbType.Float,50, DL_MainItem.ID),
db.MakeInParam("@TableNum", SqlDbType.VarChar,50,DL_MainItem.TableNum),
db.MakeInParam("@SaverCode", SqlDbType.VarChar,50, DL_MainItem.SaverCode),
db.MakeInParam("@WorkCode", SqlDbType.VarChar,50, DL_MainItem.WorkCode),
db.MakeInParam("@OperCode", SqlDbType.VarChar,50, DL_MainItem.OperCode),
};
try
{
bSuc = db.TransactSql(visitor, "AddMaintenance", 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 bool Update(DC_LoadoMeter Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new LoadoMeterDAL();
bool Flag = false, ReFlag = false;
int N = 0;
SqlParameter[] prams ={
db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name),
db.MakeInParam("@Ip", SqlDbType.VarChar,50, Item.Ip),
db.MakeInParam("@Port", SqlDbType.VarChar,50, Item.Port),
db.MakeInParam("@Remark", SqlDbType.VarChar,255, Item.Remark),
db.MakeInParam("@Id", SqlDbType.Int,0,Item.Id)
};
try
{
ReFlag = db.TransactSql(visitor, "Update", prams, out N);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
if (ReFlag && N > 0)
{
Flag = true;
}
return Flag;
}
