コード例 #1
0
        public bool Insert(correctingData datcorrecting)
        {
            int  iRel = -1;
            bool bRel = false;

            DataAccess.CommonDB objDB = new DataAccess.CommonDB();
            try
            {
                objDB.OpenConnection();
                string strSql = " insert into correcting (hwtit,userid,ctime,ccon,ter,cdate,scores,messages)  values (@hwtit,@userid,@ctime,@ccon,@ter,@cdate,@scores,@messages) ";
                objDB.Command.CommandType = System.Data.CommandType.Text;
                objDB.Command.CommandText = strSql;
                objDB.Command.Parameters.AddWithValue("@hwtit", datcorrecting.hwtit);
                objDB.Command.Parameters.AddWithValue("@userid", datcorrecting.userid);
                objDB.Command.Parameters.AddWithValue("@ctime", datcorrecting.ctime);
                objDB.Command.Parameters.AddWithValue("@ccon", datcorrecting.ccon);
                objDB.Command.Parameters.AddWithValue("@ter", datcorrecting.ter);
                objDB.Command.Parameters.AddWithValue("@cdate", datcorrecting.cdate);
                objDB.Command.Parameters.AddWithValue("@scores", datcorrecting.scores);
                objDB.Command.Parameters.AddWithValue("@messages", datcorrecting.messages);
                iRel = objDB.Command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                iRel = -1;
            }
            objDB.CloseConnection();
            objDB.Dispose();
            objDB = null;
            bRel  = (iRel.Equals(1) ? true : false);
            return(bRel);
        }
コード例 #2
0
        public correctingData[] Select(string Id)
        {
            int iRel = -1;

            DataAccess.CommonDB objDB         = new DataAccess.CommonDB();
            correctingData[]    datcorrecting = new correctingData[1];
            string sql = "select * from correcting where Id= " + Id + " ";

            try
            {
                objDB.OpenConnection();
                DataSet ds = objDB.QueryData(sql, "departmentinfo");
                if (ds.Tables.Count > 0)
                {
                    long nRow = ds.Tables[0].Rows.Count;
                    if (nRow > 0)
                    {
                        datcorrecting = new correctingData[nRow];
                        for (int i = 0; i < nRow; i++)
                        {
                            datcorrecting[i]          = new correctingData();
                            datcorrecting[i].hwtit    = ds.Tables[0].Rows[i]["hwtit"].ToString();
                            datcorrecting[i].userid   = ds.Tables[0].Rows[i]["userid"].ToString();
                            datcorrecting[i].ctime    = ds.Tables[0].Rows[i]["ctime"].ToString();
                            datcorrecting[i].ccon     = ds.Tables[0].Rows[i]["ccon"].ToString();
                            datcorrecting[i].ter      = ds.Tables[0].Rows[i]["ter"].ToString();
                            datcorrecting[i].cdate    = ds.Tables[0].Rows[i]["cdate"].ToString();
                            datcorrecting[i].scores   = ds.Tables[0].Rows[i]["scores"].ToString();
                            datcorrecting[i].messages = ds.Tables[0].Rows[i]["messages"].ToString();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                iRel = -1;
            }
            objDB.CloseConnection();
            objDB.Dispose();
            objDB = null;
            return(datcorrecting);
        }