/// <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></returns>
public static bool CheckPwd(string pass)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new UsersDAL();
bool Flag = false;
SqlParameter[] prams ={
db.MakeInParam("@Uid",SqlDbType.VarChar,50,LUser.Uid),
db.MakeInParam("@Pwd",SqlDbType.VarChar,50,pass)
};
try
{
SqlDataReader dr;
db.GetDataReader(visitor, prams, out dr, "UserLock");
if (dr.Read())
{
Flag = true;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
return Flag;
}
/// <summary>
/// 查询角色是否拥有某个权限
/// </summary>
/// <param name="RoleCode">角色编号</param>
/// <param name="PowerCode">权限编号</param>
/// <returns></returns>
public static bool CheckRolePower(string RuleName)
{
if (LUser.Id <= 2)
return true;
DataBase db = new DataBase();
DataBaseVisitor visitor = new RoleDAL();
bool Flag = false;
SqlParameter[] prams ={
db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,LUser.Role),
db.MakeInParam("@RuleName", SqlDbType.VarChar,50,RuleName)
};
try
{
SqlDataReader dr;
db.GetDataReader(visitor, prams, out dr, "CheckRolePower");
if (dr.Read())
{
Flag = true;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
return Flag;
}
/// <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>"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";
}
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 UserLogin(D_User Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new UsersDAL();
bool Flag = false;
SqlParameter[] prams ={
db.MakeInParam("@Uid",SqlDbType.VarChar,50,Item.Uid),
db.MakeInParam("@Pwd",SqlDbType.VarChar,50,Item.Pwd)
};
try
{
DataSet ds = new DataSet();
ds = db.ReturnDataSet(visitor, prams, "UserLogin");
DataRowCollection drc = ds.Tables[0].Rows;
if (drc.Count > 0)
{
DataRow dr = drc[0];
CUser.Id = Convert.ToInt64(dr["Id"]);
CUser.Code = dr["Code"].ToString();
CUser.Uid = dr["Uid"].ToString();
CUser.Name = dr["Name"].ToString();
CUser.Role = dr["Role"].ToString();
//PublicFun.IniFile Ini = new PublicFun.IniFile(WSV.Model.FilePath.Config);
//if (Ini.ExistIniFile())
//{
// LUser.TableNum = Ini.IniReadValue("LoadoMeter", "TableNum");
//}
//ds = WSV.BLL.SysInfo.LoadoMeterBLL.SelectAll(" where TableNum='" + LUser.TableNum + "'");
//drc = ds.Tables[0].Rows;
//if (drc.Count > 0)
//{
// dr = drc[0];
// LUser.TableName = dr["Name"].ToString();
// LUser.Ip = dr["Ip"].ToString();
// LUser.Port = dr["Port"].ToString();
//}
//else
//{
// LUser.TableNum = "";
//}
Flag = true;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
return Flag;
}
public static bool AddCurve(string Code, WSV.Model.Weight.WeightModel value)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.MyLog.DL_WeightVisitor();
bool retvalue = true;
SqlParameter[] prams ={
db.MakeInParam("@Code",SqlDbType.VarChar,50,Code)
};
SqlDataReader Reader = null;
try
{
db.GetDataReader(visitor, prams, out Reader, "AddCurve");
if (Reader.Read())
{
value.StateFun.Curve = (byte[])Reader["Curve"];
}
else
{
retvalue = false;
}
}
catch (Exception e)
{
db.Dispose();
return false;
}
finally
{
db.Dispose();
}
return retvalue;
}
/// <summary>
/// 根据名字查询编号
/// </summary>
/// <returns></returns>
public static string SelectByName(string Name)
{
string Code = "";
DataBase db = new DataBase();
DataBaseVisitor visitor = new DC_BaseVisitor();
SqlDataReader dr = null;
SqlParameter[] prams ={
db.MakeInParam("@Name", SqlDbType.VarChar,50, Name),
};
try
{
db.GetDataReader(visitor, prams, out dr, "SelectByName");
if (dr.Read())
{
Code = dr["Code"].ToString();
}
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return Code;
}
/// <summary>
/// ���������
/// </summary>
/// <param name="s_Pr"></param>
/// <returns></returns>
public static string Data_Add(string s_Pr)
{
string CodeA = "";
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
SqlParameter[] prams ={
db.MakeInParam("@Flag", SqlDbType.VarChar,50,s_Pr)
};
SqlDataReader dr = null;
try
{
db.GetDataReader(visitor, prams, out dr, "D_Add");
if (dr.Read())
{
CodeA = dr["Code"].ToString();
}
dr.Close();
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return CodeA;
}
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="Item">model</param>
/// <returns></returns>
public static string Update(DC_BaseModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DC_BaseVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code),
db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name),
db.MakeInParam("@AS", SqlDbType.VarChar,50, Item.AS),
db.MakeInParam("@Flag", SqlDbType.VarChar,50, Item.Flag),
db.MakeInParam("@Rank", SqlDbType.VarChar,50, Item.Rank),
db.MakeInParam("@ID", SqlDbType.VarChar,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="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;
}
/// <summary>
/// 查询
/// </summary>
/// <param name="Item"> model</param>
public static void DataShow(ref Model.Video.D_Video Item)
{
SqlDataReader dr = null;
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Video.VideoVisitor();
SqlParameter[] prams ={
db.MakeInParam("@VIDEO_name", SqlDbType.VarChar, 50, Item.VIDEO_name),
db.MakeInParam("@table", SqlDbType.VarChar, 50, Item.VIDEO_table),
};
try
{
db.GetDataReader(visitor, prams, out dr, "Select_D_Video");
if (dr.Read())
{
Item.VIDEO_Standard = int.Parse(dr["VIDEO_Standard"].ToString());
Item.VIDEO_Brightness = int.Parse(dr["VIDEO_Brightness"].ToString());
Item.VIDEO_Contrast = int.Parse(dr["VIDEO_Contrast"].ToString());
Item.VIDEO_Hue = int.Parse(dr["VIDEO_Hue"].ToString());
Item.VIDEO_Saturation = int.Parse(dr["VIDEO_Saturation"].ToString());
Item.VIDEO_Suality = int.Parse(dr["VIDEO_Suality"].ToString());
}
else
{
Item.VIDEO_Standard = 2;
Item.VIDEO_Brightness = 80;
Item.VIDEO_Contrast = 44;
Item.VIDEO_Hue = 0;
Item.VIDEO_Saturation = 40;
Item.VIDEO_Suality = 0;
}
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
dr.Close();
db.Dispose();
}
}
/// <summary>
/// ��ѯëƤͼƬ
/// </summary>
/// <param name="Item"></param>
/// <param name="Code"></param>
public static void DataShowImage(ref Model.Weight.StateModel Item, string Code)
{
SqlDataReader dr = null;
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
SqlParameter[] prams ={
db.MakeInParam("@Code",SqlDbType.VarChar,50,Code)
};
try
{
db.GetDataReader(visitor, prams, out dr, "SelectCode");
if (dr.Read())
{
if (dr["G_Image1"] != System.DBNull.Value)
Item.G_Image1 = (byte[])dr["G_Image1"];
if (dr["G_Image2"] != System.DBNull.Value)
Item.G_Image2 = (byte[])dr["G_Image2"];
if (dr["G_Image3"] != System.DBNull.Value)
Item.G_Image3 = (byte[])dr["G_Image3"];
if (dr["G_Image4"] != System.DBNull.Value)
Item.G_Image4 = (byte[])dr["G_Image4"];
if (dr["T_Image1"] != System.DBNull.Value)
Item.T_Image1 = (byte[])dr["T_Image1"];
if (dr["T_Image2"] != System.DBNull.Value)
Item.T_Image2 = (byte[])dr["T_Image2"];
if (dr["T_Image3"] != System.DBNull.Value)
Item.T_Image3 = (byte[])dr["T_Image3"];
if (dr["T_Image4"] != System.DBNull.Value)
Item.T_Image4 = (byte[])dr["T_Image4"];
if (dr["G_Curve"] != System.DBNull.Value)
Item.G_Curve = (byte[])dr["G_Curve"];
if (dr["T_Curve"] != System.DBNull.Value)
Item.T_Curve = (byte[])dr["T_Curve"];
}
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
dr.Close();
db.Dispose();
}
}
/// <summary>
/// ��ѯ������Ӧ�Ļ�����Ŀ
/// </summary>
/// <returns></returns>
public static DataSet SelectCode(string Code)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new CountDal();
DataSet ds = new DataSet();
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, Code),
};
try
{
ds = db.ReturnDataSet(visitor, prams, "SelectCode");
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ds;
}
/// <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="s_Pr"></param>
/// <param name="s_pr1"></param>
/// <returns></returns>
public static bool SelectName(string flag, WeightModel Item)
{
bool retvalue = true;
if (flag == "")
{
return false;
}
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Weight.PlanDAL();
SqlParameter[] prams ={
db.MakeInParam ("@flag",SqlDbType.VarChar ,50,flag ),
};
SqlDataReader getReader = null;
try
{
db.GetDataReader(visitor, prams, out getReader, "selectCode");
if (getReader.Read())
{
Item.Txt.Plan_Code=getReader["Plan_Code"].ToString();
}
else
{
retvalue = false;
}
getReader.Close();
}
catch (Exception err)
{
db.Dispose();
return false;
}
finally
{
db.Dispose();
}
return retvalue;
}
/// <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="Weight">model</param>
public static void GetDate(ref WSV.Model.Weight.WeightModel Weight)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData();
SqlDataReader oddr = null;
SqlParameter[] prams ={
db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code),
};
try
{
db.GetDataReader(visitor, prams, out oddr, "SelectByCode");
if (oddr.Read())
{
Weight.StateFun.Verify = Convert.ToBoolean(oddr["Verify"]);
Weight.StateFun.Used = Convert.ToBoolean(oddr["Used"]);
Weight.Txt.CarCode = oddr["CarCode"].ToString();
Weight.Txt.Item = oddr["Item"].ToString();
Weight.Txt.Specs = oddr["Specs"].ToString();
Weight.Txt.Place = oddr["Place"].ToString();
Weight.Txt.Send = oddr["Send"].ToString();
Weight.Txt.Accept = oddr["Accept"].ToString();
Weight.Txt.Carry = oddr["Carry"].ToString();
Weight.Txt.Model = oddr["Model"].ToString();
Weight.Txt.Driver = oddr["Driver"].ToString();
Weight.Txt.Spare = oddr["Spare"].ToString();
Weight.Txt.Card = oddr["Card"].ToString();
Weight.Txt.Plan_Code = oddr["Plan_Code"].ToString();
Weight.Txt.Type = oddr["Type"].ToString();
Weight.StateFun.G_Oper = oddr["G_Oper"].ToString();
Weight.StateFun.T_Oper = oddr["T_Oper"].ToString();
Weight.StateFun.G_Table = oddr["G_Table"].ToString();
Weight.StateFun.T_Table = oddr["T_Table"].ToString();
Weight.Float.Gross = Convert.ToDecimal(oddr["Gross"]);
Weight.Float.Tare = Convert.ToDecimal(oddr["Tare"]);
Weight.Float.Net = Convert.ToDecimal(oddr["Net"]);
Weight.Float.EndNet = Convert.ToDecimal(oddr["EndNet"]);
Weight.Float.Impurity = Convert.ToDecimal(oddr["Impurity"]);
Weight.Float.ImpurityRate = Convert.ToDecimal(oddr["ImpurityRate"]);
Weight.Float.DeductWei = Convert.ToDecimal(oddr["DeductWei"]);
Weight.Float.DeductRate = Convert.ToDecimal(oddr["DeductRate"]);
Weight.Float.Cube = Convert.ToDecimal(oddr["Cube"]);
Weight.Float.InhereWei = Convert.ToDecimal(oddr["InhereWei"]);
Weight.Float.DifferWei = Convert.ToDecimal(oddr["DifferWei"]);
Weight.Float.Price = Convert.ToDecimal(oddr["Price"]);
Weight.Float.Money = Convert.ToDecimal(oddr["Money"]);
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
oddr.Close();
db.Dispose();
}
}
/// <summary>
/// 带参数的数据查询
/// </summary>
/// <param name="Begin">开始时间</param>
/// <param name="Over">结束时间</param>
/// <returns>DataSet</returns>
public static DataSet SelectAll(string Begin, string Over)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.DL_WeightVisitor();
DataSet ds = new DataSet();
SqlParameter[] prams ={
db.MakeInParam("@Begin", SqlDbType.Char,50, Begin),
db.MakeInParam("@Over", SqlDbType.Char,50, Over),
};
try
{
ds = db.ReturnDataSet(visitor, prams, "Select");
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ds;
}
/// <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="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>
public static void SelectByName(string ProName, ref Model.Count.D_StatProjectModel Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal();
SqlDataReader dr = null;
SqlParameter[] prams ={
db.MakeInParam("@Name", SqlDbType.VarChar,50, ProName),
};
try
{
db.GetDataReader(visitor, prams, out dr, "SelectByName");
if (dr.Read())
{
Item.Type = dr["Type"].ToString();
Item.SataType = dr["SataType"].ToString();
Item.Flag = dr["Flag"].ToString();
Item.Month = dr["Month"].ToString();
Item.Day = dr["Day"].ToString();
Item.BeginTime = dr["BeginTime"].ToString();
Item.EndTime = dr["EndTime"].ToString();
}
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
}
/// <summary>
/// 修改主数据
/// </summary>
/// <param name="Weight">model</param>
/// <returns></returns>
public static string UpdateData(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("@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.Bit, 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),
db.MakeInParam("@Updata_Time", SqlDbType.VarChar, 50, Weight.StateFun.Updata_Time),
db.MakeInParam("@Updata_Oper", SqlDbType.VarChar, 50, Weight.StateFun.Updata_Oper),
db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code),
};
try
{
bSuc = db.TransactSql(visitor, "UpdateData", prams, out nEffectRows);
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
if (bSuc && nEffectRows > 0)
return "0101";
else
return "0";
}
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 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";
}
