/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(T_B_USERModel model) { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("INSERT INTO T_B_USER("); sBuilder.Append("USERNAME,"); sBuilder.Append("PASSWORD,"); sBuilder.Append("XM,"); sBuilder.Append("USERTYPE,"); sBuilder.Append("SFJY,"); sBuilder.Append("BL1,"); sBuilder.Append("BL2,"); sBuilder.Append("BL3"); sBuilder.Append(") VALUES("); sBuilder.Append(":USERNAME,"); sBuilder.Append(":PASSWORD,"); sBuilder.Append(":XM,"); sBuilder.Append(":USERTYPE,"); sBuilder.Append(":SFJY,"); sBuilder.Append(":BL1,"); sBuilder.Append(":BL2,"); sBuilder.Append(":BL3"); sBuilder.Append(")"); OracleParameter[] oparams = { new OracleParameter(":USERNAME", OracleType.VarChar), new OracleParameter(":PASSWORD", OracleType.VarChar), new OracleParameter(":XM", OracleType.VarChar), new OracleParameter(":USERTYPE", OracleType.VarChar), new OracleParameter(":SFJY", OracleType.Number), new OracleParameter(":BL1", OracleType.VarChar), new OracleParameter(":BL2", OracleType.VarChar), new OracleParameter(":BL3", OracleType.VarChar) }; oparams[0].Value = model.USERNAME; oparams[1].Value = model.PASSWORD; oparams[2].Value = model.XM; oparams[3].Value = model.USERTYPE; oparams[4].Value = model.SFJY; oparams[5].Value = model.BL1; oparams[6].Value = model.BL2; oparams[7].Value = model.BL3; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 查询列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <T_B_USERModel> QueryList(string swhere, string orders) { List <T_B_USERModel> models = new List <T_B_USERModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.USERNAME,"); sBuilder.Append("T.PASSWORD,"); sBuilder.Append("T.XM,"); sBuilder.Append("T.USERTYPE,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3 "); sBuilder.Append("FROM T_B_USER T "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_B_USERModel model = new T_B_USERModel(); model.USERNAME = ToString(dr["USERNAME"]); model.PASSWORD = ToString(dr["PASSWORD"]); model.XM = ToString(dr["XM"]); model.USERTYPE = ToString(dr["USERTYPE"]); model.SFJY = ToInt(dr["SFJY"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); models.Add(model); } } return(models); }
/// <summary> /// 查询 /// </summary> /// <param name="username"></param> /// <returns></returns> public T_B_USERModel Query(string username) { T_B_USERModel model = new T_B_USERModel(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.USERNAME,"); sBuilder.Append("T.PASSWORD,"); sBuilder.Append("T.XM,"); sBuilder.Append("T.USERTYPE,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3 "); sBuilder.Append("FROM T_B_USER T "); sBuilder.Append("WHERE T.USERNAME=:USERNAME "); OracleParameter[] oparams = { new OracleParameter(":USERNAME", OracleType.VarChar) }; oparams[0].Value = username; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.USERNAME = ToString(dr["USERNAME"]); model.PASSWORD = ToString(dr["PASSWORD"]); model.XM = ToString(dr["XM"]); model.USERTYPE = ToString(dr["USERTYPE"]); model.SFJY = ToInt(dr["SFJY"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); } return(model); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Modify(T_B_USERModel model) { return(access.Modify(model)); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(T_B_USERModel model) { return(access.Add(model)); }