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