/// <summary>
/// 检查主键
/// </summary>
/// <param name="Tab">表名</param>
/// <param name="key">要检查的字段名</param>
/// <param name="value">要检查的值</param>
/// <param name="Id">Id等于0代表添加操作，否则就是修改操作</param>
public static bool CheckKey(string Tab, string key, string value, long Id)
{
bool Flag = false;
DataBase db = new DataBase();
SqlDataReader dr = null;
try
{
if (Id == 0)
{
db.GetDataReader(out dr, "select * from " + Tab + " where " + key + "='" + value + "'");
if (dr.Read()) { Flag = true; }
}
else
{
db.GetDataReader(out dr, "select * from " + Tab + " where Id<>" + Id + " and " + key + "='" + value + "'");
if (dr.Read()) { Flag = true; }
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dr.Close();
db.Dispose();
}
return Flag;
}
/// <summary>
/// 查询出所有的数据
/// </summary>
/// <returns>返回数据源</returns>
public static string BillInfoSql(string Code)
{
string retSql = "";
DataBase db = new DataBase();
DataBaseVisitor visitor = new BillInfoDAL();
SqlDataReader myread;
try
{
db.GetDataReader(visitor, null, out myread, "BillInfoSql");
while(myread.Read())
{
retSql += "," + myread["DBName"].ToString().Trim()+" as " + myread["Name"].ToString().Trim();
}
myread.Close();
retSql= retSql.Substring(1);
retSql = "Select " + retSql + " From V_D_Saver_D Where Code='"+Code.Trim()+"'";
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
return retSql;
}
/// <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;
}
/// <summary>
/// 最大ID
/// </summary>
/// <param name="Content"></param>
/// <returns></returns>
public static long MaxID()
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.MyLog.DL_Run();
long ret_V = 0;
try
{
SqlDataReader dr;
db.GetDataReader(visitor,null,out dr, "MaxID");
if (dr.Read())
{
if(dr[0] !=null)
ret_V = long.Parse(dr[0].ToString());
}
ret_V += 1;
//ds = db.ReturnDataSet(visitor, prams, "Select");
}
catch (Exception ex)
{ return 0; throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ret_V;
}
/// <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>
/// <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="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;
}
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>
/// <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>
/// <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>
/// ����SQL�ַ���
/// </summary>
/// <returns></returns>
public static string W_Char()
{
string field = "";
DataBase db = new DataBase();
SqlDataReader oddr = null;
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
SqlParameter[] prams ={
db.MakeInParam("@Flag", SqlDbType.VarChar,50," ")
};
db.GetDataReader(visitor, prams, out oddr, "GridViewName");
while (oddr.Read())
{
field += ",[" + oddr["DBName"] + "]";
}
if (!string.IsNullOrEmpty(field)) { field = field.Substring(1); }
return field;
}
/// <summary>
/// 查询角色拥有的权限
/// </summary>
/// <param name="RoleCode">角色编号</param>
/// <returns></returns>
public static string RolePower(string RoleCode)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new RoleDAL();
string Nid = "";
SqlParameter[] prams ={
db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,RoleCode)
};
try
{
SqlDataReader dr;
db.GetDataReader(visitor, prams, out dr, "RolePower");
while (dr.Read())
{
Nid += "," + dr["PowerCode"];
}
if (!string.IsNullOrEmpty(Nid)) { Nid = Nid.Substring(1); }
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
return Nid;
}
/// <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="CodeID">D_Base编号</param>
/// <param name="ParentCode">父类编号-DC_Base表编号</param>
/// <returns></returns>
public static bool ValiDateCode(string CodeID, string ParentCode)
{
bool Flag = false;
DataBase db = new DataBase();
DataBaseVisitor visitor = new D_BaseVisitor();
SqlDataReader dr = null;
SqlParameter[] prams ={
db.MakeInParam("@CodeID", SqlDbType.VarChar,50, CodeID),
db.MakeInParam("@ParentCode", SqlDbType.VarChar,50, ParentCode),
};
try
{
db.GetDataReader(visitor, prams, out dr, "SelectByCode");
if (dr.Read())
{
Flag = true;
}
dr.Close();
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return Flag;
}
/// <summary>
/// 根据编号查询表内容
/// </summary>
/// <param name="Item">D_Plan表model</param>
public static void GetPlan(ref Model.Plan.D_Plan Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
SqlDataReader dr = null;
SqlParameter[] prams ={
db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Item.Plan_Code),
};
try
{
db.GetDataReader(visitor, prams, out dr, "Select_D_PlanByCode");
if (dr.Read())
{
Item.Plan_Item = dr["Plan_Item"].ToString();
Item.Plan_Send = dr["Plan_Send"].ToString();
Item.Plan_Specs = dr["Plan_Specs"].ToString();
Item.Plan_Accept = dr["Plan_Accept"].ToString();
Item.Plan_CountWay = dr["Plan_CountWay"].ToString();
Item.Plan_Type = dr["Plan_Type"].ToString();
Item.Plan_Num = Convert.ToDecimal(dr["Plan_Num"]);
Item.Plan_SpareNum = Convert.ToDecimal(dr["Plan_SpareNum"]);
Item.Plan_Money = Convert.ToDecimal(dr["Plan_Money"]);
Item.Plan_SpareMoney = Convert.ToDecimal(dr["Plan_SpareMoney"]);
Item.Remark = dr["Remark"].ToString();
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
dr.Close();
db.Dispose();
}
}
/// <summary>
/// ��ѯ���ű���Ƿ浱ǰ����
/// </summary>
/// <param name="CarCode"></param>
/// <param name="Item"></param>
/// <returns></returns>
public static bool SelectCarCode1(string CarCode, WeightModel Item)
{
bool retvalue = true;
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Weight.WeightDAL();
SqlParameter[] prams ={
db.MakeInParam ("@CarCode",SqlDbType.VarChar ,50,CarCode )
};
SqlDataReader getReader = null;
try
{
db.GetDataReader(visitor, prams, out getReader, "selectCarCode1");
if (getReader.Read())
{
Item.Txt.CarCode = getReader["CarCode"].ToString();
Item.Txt.Driver = getReader["Driver"].ToString();
Item.Float.Tare = Convert.ToDecimal(getReader["Tare"].ToString());
}
else
{
retvalue = false;
}
getReader.Close();
}
catch (Exception err)
{
db.Dispose();
return false;
}
finally
{
db.Dispose();
}
return retvalue;
}
//�õ��Ƿ����ֶ�
/// <summary>
/// ˢ��ʱ�Ƿ����ֶ�
/// </summary>
/// <param name="S_Pr"></param>
/// <returns></returns>
public bool retretainflag(string S_Pr)
{
bool retvalue = false;
SqlDataReader getReader = null;
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
DataBase db = new DataBase();
SqlParameter[] prams ={
db.MakeInParam ("@name",SqlDbType.VarChar,50,S_Pr.Substring(4))
};
DataSet ds = new DataSet();
try
{
db.GetDataReader(visitor, prams, out getReader, "Retain");
if (getReader.Read())
{
if (getReader[0].ToString() == "True")
retvalue = true;
else if (getReader[0].ToString() == "False")
retvalue = false;
}
else
{
retvalue = false;
}
getReader.Close();
}
catch (Exception err)
{
db.Dispose();
throw err;
return false;
}
finally
{
if (getReader != null) getReader.Close();
db.Dispose();
}
return retvalue;
}
/// <summary>
/// ������Ƶ
/// </summary>
/// <param name="card"></param>
/// <param name="table"></param>
/// <param name="Values"></param>
public static void setvideo(int card, string table, Model.Weight.WeightModel Values)
{
SqlDataReader getReader = null;
DataBase db = new DataBase();
DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL();
SqlParameter[] prams = new SqlParameter[2];
try
{
prams[0] = db.MakeInParam("@VIDEO_name", SqlDbType.VarChar, 50, card.ToString());
prams[1] = db.MakeInParam("@VIDEO_table", SqlDbType.VarChar, 50, table);
db.GetDataReader(visitor, prams, out getReader, "retvideo");
if (getReader.Read())
{
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 0, int.Parse(getReader["VIDEO_Brightness"].ToString()));
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 1, int.Parse(getReader["VIDEO_Contrast"].ToString()));
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 3, int.Parse(getReader["VIDEO_Hue"].ToString()));
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 2, int.Parse(getReader["VIDEO_Saturation"].ToString()));
switch (card)
{
case 0:
Values.StateFun.imagesuality1 = int.Parse(getReader["VIDEO_Suality"].ToString());
break;
case 1:
Values.StateFun.imagesuality2 = int.Parse(getReader["VIDEO_Suality"].ToString());
break;
case 2:
Values.StateFun.imagesuality3 = int.Parse(getReader["VIDEO_Suality"].ToString());
break;
case 3:
Values.StateFun.imagesuality4 = int.Parse(getReader["VIDEO_Suality"].ToString());
break;
}
}
else
{
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 0, 80);
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 1, 44);
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 2, 40);
BLL.Weight.VideoInfo.VCStream_VCASetVidDeviceColor(card, 3, 0);
switch (card)
{
case 0:
Values.StateFun.imagesuality1 = 80;
break;
case 1:
Values.StateFun.imagesuality2 = 80;
break;
case 2:
Values.StateFun.imagesuality3 = 80;
break;
case 3:
Values.StateFun.imagesuality4 = 80;
break;
}
}
getReader.Close();
}
catch (Exception err)
{
MessageBox.Show("����" + err.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
}
}
/// <summary>
/// ������ݿ�����ı�
/// </summary>
/// <param name="item"></param>
/// <param name="header"></param>
/// <returns></returns>
public string ColElement(string HeaderName)
{
DataBase db = new DataBase();
string Ret = "";
string sql = "select Name from C_Alias where RuleName='" + HeaderName + "' and State = 1";
db.GetDataReader(out oddr, sql);
if (oddr.Read())
{
Ret = oddr["Name"].ToString();
}
oddr.Close();
return Ret;
}
/// <summary>
/// ����ֶΣ���ť���ı�����������
/// </summary>
/// <param name="item"></param>
/// <param name="label1"></param>
/// <param name="textbox1"></param>
/// <param name="button"></param>
public string element(string item, Label label1, TextBox textbox1)
{
DataBase db = new DataBase();
string sql = "select Name from C_Alias where DBName='" + item + "' and State = 1";
db.GetDataReader(out oddr, sql);
if (oddr.Read())
{
label1.Text = oddr["Name"].ToString();
}
else
{
label1.Visible = false;
textbox1.Visible = false;
}
oddr.Close();
return sql;
}
public static string MaxCode()
{
DataBase db = new DataBase();
string _MaxCode = "";
SqlDataReader dr = null;
string sql = "select max(Code) as Code from V_D_Saver_Temp";
db.GetDataReader(out dr, sql);
if (dr.Read())
{
_MaxCode = dr["Code"].ToString();
}
db.Dispose();
return _MaxCode;
}
/// <summary>
/// ��ѯ������
/// </summary>
/// <param name="TableName"></param>
/// <param name="Table"></param>
/// <returns></returns>
public static string MaxCode(string TableName, string Table)
{
DataBase db = new DataBase();
string _MaxCode = "";
SqlDataReader dr = null;
string sql = "select max(Code) as Code from " + TableName + " where Code like '" + Table + "%'";
db.GetDataReader(out dr, sql);
if (dr.Read())
{
_MaxCode = dr["Code"].ToString();
}
return _MaxCode;
}
public static string ShowImage(WeightModel values)
{
DataBase db = new DataBase();
SqlDataReader dr = null;
string _MaxCode = MaxCode();
string flag = SelectWeight(_MaxCode);
string sql = "select G_Image1,G_Image2,G_Image3,G_Image4,T_Image1,T_Image2,T_Image3,T_Image4 from D_Saver_Image where Code=" + _MaxCode;
db.GetDataReader(out dr, sql);
try
{
if (dr.Read())
{
if (flag == "G")
{
if (dr["G_Image1"] != System.DBNull.Value)
values.StateFun.G_Image1 = (byte[])dr["G_Image1"];
if (dr["G_Image2"] != System.DBNull.Value)
values.StateFun.G_Image2 = (byte[])dr["G_Image2"];
if (dr["G_Image3"] != System.DBNull.Value)
values.StateFun.G_Image3 = (byte[])dr["G_Image3"];
if (dr["G_Image4"] != System.DBNull.Value)
values.StateFun.G_Image4 = (byte[])dr["G_Image4"];
}
else if (flag == "T")
{
if (dr["T_Image1"] != System.DBNull.Value)
values.StateFun.T_Image1 = (byte[])dr["T_Image1"];
if (dr["T_Image2"] != System.DBNull.Value)
values.StateFun.T_Image2 = (byte[])dr["T_Image2"];
if (dr["T_Image3"] != System.DBNull.Value)
values.StateFun.T_Image3 = (byte[])dr["T_Image3"];
if (dr["T_Image4"] != System.DBNull.Value)
values.StateFun.T_Image4 = (byte[])dr["T_Image4"];
}
}
}
catch (Exception err)
{
db.Dispose();
return null;
MessageBox.Show("����û��ͼƬ��", "������ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
db.Dispose();
return flag;
}
/// <summary>
/// ��ѯ��ǰ����
/// </summary>
/// <param name="Card"></param>
/// <param name="Item"></param>
/// <returns></returns>
public static bool SelectCard(string Card, WeightModel Item)
{
bool retvalues = true;
DataBase db = new DataBase();
DataBaseVisitor visitor = new WeightDAL();
SqlParameter[] prams ={
db.MakeInParam("@Card",SqlDbType.VarChar,50,Card)
};
SqlDataReader getread = null;
db.GetDataReader(visitor, prams, out getread, "SelectCard");
try
{
if (getread.Read())
{
Item.Txt.Type = getread["Type"].ToString();
Item.Txt.Item = getread["Item"].ToString();
Item.Txt.Specs = getread["Specs"].ToString();
Item.Txt.Place = getread["Place"].ToString();
Item.Txt.Send = getread["Send"].ToString();
Item.Txt.Accept = getread["Accept"].ToString();
Item.Txt.Carry = getread["Carry"].ToString();
Item.Txt.Model = getread["Model"].ToString();
Item.Txt.Driver = getread["Driver"].ToString();
Item.Txt.Spare = getread["Spare"].ToString();
Item.Txt.CarCode = getread["CarCode"].ToString();
Item.Float.Tare = Convert.ToDecimal(getread["Tare"].ToString());
}
else
{
return retvalues = false;
}
getread.Close();
}
catch (Exception e)
{
db.Dispose();
return false;
}
finally
{
db.Dispose();
}
return retvalues;
}
public static string SelectWeight(string MaxCode)
{
DataBase db = new DataBase();
SqlDataReader dr = null;
string flag = "";
string sql = "select Tare,Gross from V_D_Saver_Temp where Code=" + MaxCode;
db.GetDataReader(out dr, sql);
if (dr.Read())
{
//string et = dr["Tare"].ToString();
if (Convert.ToDecimal(dr["Tare"].ToString()) > 0)
{
flag = "T";
}
else if (Convert.ToDecimal(dr["Gross"].ToString()) > 0)
{
flag = "G";
}
}
db.Dispose();
return flag;
}
/// <summary>
/// ������ݿ�����ı�
/// </summary>
/// <param name="item"></param>
/// <param name="header"></param>
/// <returns></returns>
public string element(string item, DataGridViewTextBoxColumn header)
{
DataBase db = new DataBase();
string sql = "select Name from C_Alias where RuleName='" + item + "' and State = 1";
db.GetDataReader(out oddr, sql);
if (oddr.Read())
{
header.HeaderText = oddr["Name"].ToString();
}
else
{
header.Visible = false;
}
oddr.Close();
return sql;
}
/// <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="flag"></param>
/// <param name="flag1"></param>
/// <param name="Item"></param>
/// <returns></returns>
public static bool selectByFlag(string flag, string flag1,int PortId2, WeightModel Item)
{
bool retvalue = true;
if (flag1 == "")
{
return false;
}
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Weight.WeightDAL();
SqlParameter[] prams ={
db.MakeInParam ("@flag",SqlDbType.VarChar ,50,flag ),
db.MakeInParam("@flag1",SqlDbType.VarChar,50,flag1),
db.MakeInParam("@PortId2",SqlDbType.Int,50,PortId2)
};
SqlDataReader getReader = null;
try
{
db.GetDataReader(visitor, prams, out getReader, "selectByFlag");
if (getReader.Read())
{
Item.Txt.IdCard = getReader["Code"].ToString();
Item.Txt.Name = getReader["Name"].ToString();
}
else
{
retvalue = false;
}
getReader.Close();
}
catch (Exception err)
{
db.Dispose();
return false;
}
finally
{
db.Dispose();
}
return retvalue;
}
/// <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="CarCode"></param>
/// <param name="Item"></param>
/// <returns></returns>
public static bool SelectCarCode(string CarCode, WeightModel Item)
{
bool retvalue = true;
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Weight.WeightDAL();
SqlParameter[] prams ={
db.MakeInParam ("@CarCode",SqlDbType.VarChar ,50,CarCode )
};
SqlDataReader getReader = null;
try
{
db.GetDataReader(visitor, prams, out getReader, "selectCarCode");
if (getReader.Read())
{
Item.Txt.Type = getReader["Type"].ToString();
Item.Code = getReader["Code"].ToString();
Item.Txt.Item = getReader["Item"].ToString();
Item.Txt.Specs = getReader["Specs"].ToString();
Item.Txt.Place = getReader["Place"].ToString();
Item.Txt.Accept = getReader["Accept"].ToString();
Item.Txt.Send = getReader["Send"].ToString();
Item.Txt.Carry = getReader["Carry"].ToString();
Item.StateFun.G_Oper = getReader["G_Oper"].ToString();
Item.StateFun.T_Oper = getReader["T_Oper"].ToString();
Item.StateFun.G_Time = getReader["G_Time"].ToString();
Item.StateFun.T_Time = getReader["T_Time"].ToString();
Item.Txt.Driver = getReader["Driver"].ToString();
Item.Txt.Model = getReader["Model"].ToString();
Item.Txt.Spare = getReader["Spare"].ToString();
Item.Txt.Plan_Code = getReader["Plan_Code"].ToString();
Item.Float.Cube = Convert.ToDecimal(getReader["Cube"].ToString());
Item.Float.Cubety = Convert.ToDecimal(getReader["Cubety"].ToString());
Item.Float.InhereWei = Convert.ToDecimal(getReader["InhereWei"].ToString());
Item.Float.DifferWei = Convert.ToDecimal(getReader["DifferWei"].ToString());
Item.Float.Gross = Convert.ToDecimal(getReader["Gross"].ToString());
Item.Float.Tare = Convert.ToDecimal(getReader["Tare"].ToString());
}
else
{
retvalue = false;
}
getReader.Close();
}
catch (Exception err)
{
db.Dispose();
return false;
}
finally
{
db.Dispose();
}
return retvalue;
}
