/// <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;
}
/// <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="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;
}
