Example #1
0
        public bool Modify(informationsData datinformations)
        {
            int  iRel = -1;
            bool bRel = false;

            DataAccess.CommonDB objDB = new DataAccess.CommonDB();
            try
            {
                objDB.OpenConnection();
                string strSql = "update informations set thetit=@thetit,thetype=@thetype,thetime=@thetime,userid=@userid,memos=@memos,userclass=@userclass where Id = @Id";
                objDB.Command.CommandType = System.Data.CommandType.Text;
                objDB.Command.CommandText = strSql;
                objDB.Command.Parameters.AddWithValue("@thetit", datinformations.thetit);
                objDB.Command.Parameters.AddWithValue("@thetype", datinformations.thetype);
                objDB.Command.Parameters.AddWithValue("@thetime", datinformations.thetime);
                objDB.Command.Parameters.AddWithValue("@userid", datinformations.userid);
                objDB.Command.Parameters.AddWithValue("@memos", datinformations.memos);
                objDB.Command.Parameters.AddWithValue("@userclass", datinformations.userclass);
                objDB.Command.Parameters.AddWithValue("@Id", datinformations.Id);
                iRel = objDB.Command.ExecuteNonQuery();
            }
            catch (Exception ex)
            { iRel = -1; }
            objDB.CloseConnection();
            objDB.Dispose();
            objDB = null;
            bRel  = (iRel.Equals(1) ? true : false); return(bRel);
        }
Example #2
0
        public informationsData[] Put(string casestr)
        {
            int iRel = -1;

            DataAccess.CommonDB objDB           = new DataAccess.CommonDB();
            informationsData[]  datinformations = new informationsData[1];
            string sql = "select * from informations where 1 = 1 ";

            sql += casestr;
            try
            {
                objDB.OpenConnection();
                DataSet ds = objDB.QueryData(sql, "departmentinfo");
                if (ds.Tables.Count > 0)
                {
                    long nRow = ds.Tables[0].Rows.Count;
                    if (nRow > 0)
                    {
                        datinformations = new informationsData[nRow];
                        for (int i = 0; i < nRow; i++)
                        {
                            datinformations[i]           = new informationsData();
                            datinformations[i].thetit    = ds.Tables[0].Rows[i]["thetit"].ToString();
                            datinformations[i].thetype   = ds.Tables[0].Rows[i]["thetype"].ToString();
                            datinformations[i].thetime   = ds.Tables[0].Rows[i]["thetime"].ToString();
                            datinformations[i].userid    = ds.Tables[0].Rows[i]["userid"].ToString();
                            datinformations[i].memos     = ds.Tables[0].Rows[i]["memos"].ToString();
                            datinformations[i].userclass = ds.Tables[0].Rows[i]["userclass"].ToString();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                iRel = -1;
            }
            objDB.CloseConnection();
            objDB.Dispose();
            objDB = null;
            return(datinformations);
        }