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