/// <summary> /// 获得数据列表 /// </summary> public List <RPT_SERVERPATH> DataTableToList(DataTable dt) { List <RPT_SERVERPATH> modelList = new List <RPT_SERVERPATH>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { RPT_SERVERPATH model; for (int n = 0; n < rowsCount; n++) { model = new RPT_SERVERPATH(); if (dt.Rows[n]["RKEY"].ToString() != "") { model.RKEY = int.Parse(dt.Rows[n]["RKEY"].ToString()); } model.SERVER_PATH = dt.Rows[n]["SERVER_PATH"].ToString(); model.FLODER_PATH = dt.Rows[n]["FLODER_PATH"].ToString(); if (dt.Rows[n]["TTYPE"].ToString() != "") { model.TTYPE = int.Parse(dt.Rows[n]["TTYPE"].ToString()); } if (dt.Rows[n]["ACTIVE_FLAG"].ToString() != "") { model.ACTIVE_FLAG = int.Parse(dt.Rows[n]["ACTIVE_FLAG"].ToString()); } if (dt.Rows[n]["EMP_PTR"].ToString() != "") { model.EMP_PTR = int.Parse(dt.Rows[n]["EMP_PTR"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RPT_SERVERPATH model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RPT_SERVERPATH("); strSql.Append("SERVER_PATH,FLODER_PATH,TTYPE,ACTIVE_FLAG,EMP_PTR)"); strSql.Append(" values ("); strSql.Append("@SERVER_PATH,@FLODER_PATH,@TTYPE,@ACTIVE_FLAG,@EMP_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SERVER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@FLODER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@TTYPE", SqlDbType.Int, 4), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.SERVER_PATH; parameters[1].Value = model.FLODER_PATH; parameters[2].Value = model.TTYPE; parameters[3].Value = model.ACTIVE_FLAG; parameters[4].Value = model.EMP_PTR; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_SERVERPATH model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RPT_SERVERPATH set "); strSql.Append("SERVER_PATH=@SERVER_PATH,"); strSql.Append("FLODER_PATH=@FLODER_PATH,"); strSql.Append("TTYPE=@TTYPE,"); strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,"); strSql.Append("EMP_PTR=@EMP_PTR"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), new SqlParameter("@SERVER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@FLODER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@TTYPE", SqlDbType.Int, 4), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.RKEY; parameters[1].Value = model.SERVER_PATH; parameters[2].Value = model.FLODER_PATH; parameters[3].Value = model.TTYPE; parameters[4].Value = model.ACTIVE_FLAG; parameters[5].Value = model.EMP_PTR; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_SERVERPATH model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RPT_SERVERPATH("); strSql.Append("SERVER_PATH,FLODER_PATH,TTYPE,ACTIVE_FLAG,EMP_PTR)"); strSql.Append(" values ("); strSql.Append("@SERVER_PATH,@FLODER_PATH,@TTYPE,@ACTIVE_FLAG,@EMP_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SERVER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@FLODER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@TTYPE", SqlDbType.Int, 4), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.SERVER_PATH; parameters[1].Value = model.FLODER_PATH; parameters[2].Value = model.TTYPE; parameters[3].Value = model.ACTIVE_FLAG; parameters[4].Value = model.EMP_PTR; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> public RPT_SERVERPATH GetModel(int RKEY) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RKEY,SERVER_PATH,FLODER_PATH,TTYPE,ACTIVE_FLAG,EMP_PTR from RPT_SERVERPATH with(nolock) "); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4) }; parameters[0].Value = RKEY; RPT_SERVERPATH model = new RPT_SERVERPATH(); DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "") { model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString()); } model.SERVER_PATH = ds.Tables[0].Rows[0]["SERVER_PATH"].ToString(); model.FLODER_PATH = ds.Tables[0].Rows[0]["FLODER_PATH"].ToString(); if (ds.Tables[0].Rows[0]["TTYPE"].ToString() != "") { model.TTYPE = int.Parse(ds.Tables[0].Rows[0]["TTYPE"].ToString()); } if (ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString() != "") { model.ACTIVE_FLAG = int.Parse(ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString()); } if (ds.Tables[0].Rows[0]["EMP_PTR"].ToString() != "") { model.EMP_PTR = int.Parse(ds.Tables[0].Rows[0]["EMP_PTR"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_SERVERPATH model) { dal.Update(cmd, conn, trans, model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(RPT_SERVERPATH model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_SERVERPATH model) { return(dal.Add(cmd, conn, trans, model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RPT_SERVERPATH model) { return(dal.Add(model)); }