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