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