Example #1
0
        //对象写入到数据库中
        public void Obj2Db(CDataAccessBase obj, string PkValue)
        {
            //修改版本号

            string tableName = obj.TableName;

            using (
                DataTable dt =
                    ExecQuery("select * from " + tableName + " where " + obj.PKFieldName + "='" +
                              (PkValue) + "' "))
            {
                obj.beforSave(this);
                DataRow dr;
                if (dt.Rows.Count > 0)
                {
                    dr = dt.Rows[0];
                    obj.proptertyToDataTable(dr);
                }
                else
                {
                    dr = dt.NewRow();
                    obj.proptertyToDataTable(dr);
                    dt.Rows.Add(dr);
                }

                Update(dt);
                obj.afterSave(this);
            }
        }